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.TREATMENT clin.treatmt (Clinical System)
audit_columns.g (ETL)
ColumnType ColumnTypeTable Comment
PATIENT_IDNUMBER ⇐ patient_numberclin.treatmt (Clinical System) 
CLINIC_IDNUMBER ⇐ clinic_numberclin.treatmt (Clinical System) 
TREATMENT_DATEDATE ⇐ dial_dateclin.treatmt (Clinical System) 
TREATMENT_START_TIMEVARCHAR2 ⇐ dialysis_start_timeclin.treatmt (Clinical System) 
BLOOD_FLOW_RATENUMBER ⇐ blood_flowclin.treatmt (Clinical System) 
DIALYSATE_FLOW_RATENUMBER ⇐ dial_flow_rateclin.treatmt (Clinical System) 
PRE_WEIGHTNUMBER ⇐ weight_before_treatmentclin.treatmt (Clinical System) 
POST_WEIGHTNUMBER ⇐ weight_after_treatmentclin.treatmt (Clinical System) 
TOTAL_FLUIDSNUMBER ⇐ fluids_qtyclin.treatmt (Clinical System) 
TREATMENT_DURATIONNUMBER ⇐ dialysis_timeclin.treatmt (Clinical System) 
CLEARANCENUMBER ⇐ dial_clearanceclin.treatmt (Clinical System) 
INSERT_DATEDATE ⇐ system_date_at_insertaudit_columns.g (ETL) 
UPDATE_DATEDATE ⇐ system_date_at_updateaudit_columns.g (ETL) 
LASTEST_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'