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.MEDICATION clin.med (Clinical System)
audit_columns.g (ETL)
ColumnType ColumnTypeTable Comment
CLINIC_IDNUMBER ⇐ clinic_numberclin.med (Clinical System) 
ADMINISTRATION_DATENUMBER ⇐ med_administration_dateclin.med (Clinical System) 
DIAGNOSIS_CODEVARCHAR2 ⇐ med_diag_codeclin.med (Clinical System) 
DRUG_CODEVARCHAR2 ⇐ med_drug_numberclin.med (Clinical System) 
ROUTE_CODEVARCHAR2 ⇐ med_route_codeclin.med (Clinical System) 
MEASUREMENT_CODEVARCHAR2 ⇐ med_qty_unitclin.med (Clinical System) 
QUANTITYNUMBER ⇐ med_qty_numberclin.med (Clinical System) 
DOSE_CODENUMBER ⇐ med_doseclin.med (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'