Table List

Database Tables

 Pages produced by a web-based metadata application,
which joins the database dictionary to
entity-level information entered by the analyst.
See the author's web page

 

ETL Mapping

S.ADMISSION clin.adm (Clinical System)
audit_columns.g (ETL)
ColumnType ColumnTypeTable Comment
PATIENT_IDNUMBER ⇐ patient_numberclin.adm (Clinical System) 
CLINIC_IDNUMBER ⇐ clinic_numberclin.adm (Clinical System) 
ADMISSION_DATEDATE ⇐ clinic_admission_dtclin.adm (Clinical System) 
DISCHARGE_DATEDATE ⇐ clinic_discharge_dtclin.adm (Clinical System) 
ADMISSION_REASON_CODEVARCHAR2 ⇐ chief_complaintclin.adm (Clinical System) 
DISCHARGE_REASON_CODEVARCHAR2 ⇐ reason_for_discharge_codeclin.adm (Clinical System) 
INSERT_DATEDATE ⇐ system_date_at_insertaudit_columns.g (ETL) 
UPDATE_DATEDATE ⇐ system_date_at_updateaudit_columns.g (ETL) 
LATEST_ROW_INDCHAR ⇐ processaudit_columns.g (ETL) 
 

 

 

 

Although I worked at the world's largest provider of dialysis services, this data model is my invention.
It is a simplified model that serves as an example for the metadata application that I built.
It does not describe the data model of the company.

Version 2.0, 2014-05-02 13:52:50,  Questions? Contact 'chris _ thullen (a) yekesys d0t c0m'