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

Table Details :: TREATMENT

 

TREATMENT

Description:Dialysis information. In-center treatments are expected to have most fields filled, whereas home treatments may only have the date and an approximate time.
What defines a unique row:The logical key is PATIENT_ID, CLINIC_ID, and TREATMENT_DATE. Note that multiple treatments less than 12 hours apart are considered as one treatment by the ETL process. Only one row with LASTEST_ROW_IND='Y' is expected for each logical key. The logical key and the INSERT_DATE consitute the database unique key.
Current rows:LASTEST_ROW_IND = 'Y'
Historical rows:LASTEST_ROW_IND = 'Y'

 

Show more details

S.TREATMENT in DEMODB

 

view S.TREATMENT_VW in DEMODB

 
S.TREATMENT_VW
Column Name Type   Column Name Type  
PATIENT_IDJoins:
Join to table S.PATIENT on:
PATIENT_ID = PATIENT_ID
Sources:
Clinical System: clin.treatmt.patient_number		 NUMBER(22)  PATIENT_IDJoins:
Join to table S.PATIENT on:
PATIENT_ID = PATIENT_ID
Sources:
Clinical System: clin.treatmt.patient_number		 NUMBER(22) 
CLINIC_IDJoins:
Join to table S.CLINIC on:
CLINIC_ID = CLINIC_ID
Sources:
Clinical System: clin.treatmt.clinic_number		 NUMBER(22)  CLINIC_IDJoins:
Join to table S.CLINIC on:
CLINIC_ID = CLINIC_ID
Sources:
Clinical System: clin.treatmt.clinic_number		 NUMBER(22) 
TREATMENT_DATEComments:
Date of treatment. Start date for overnight treatments
Sources:
Clinical System: clin.treatmt.dial_date		 DATE(7)  TREATMENT_DATEComments:
Date of treatment. Start date for overnight treatments
Sources:
Clinical System: clin.treatmt.dial_date		 DATE(7) 
TREATMENT_START_TIMEComments:
HH:MM in 24 hour format
Sources:
Clinical System: clin.treatmt.dialysis_start_time		 VARCHAR2(5)  TREATMENT_START_TIMEComments:
HH:MM in 24 hour format
Sources:
Clinical System: clin.treatmt.dialysis_start_time		 VARCHAR2(5) 
BLOOD_FLOW_RATESources:
Clinical System: clin.treatmt.blood_flow		 NUMBER(22)  BLOOD_FLOW_RATESources:
Clinical System: clin.treatmt.blood_flow		 NUMBER(22) 
DIALYSATE_FLOW_RATESources:
Clinical System: clin.treatmt.dial_flow_rate		 NUMBER(22)  DIALYSATE_FLOW_RATESources:
Clinical System: clin.treatmt.dial_flow_rate		 NUMBER(22) 
PRE_WEIGHTComments:
Measured in Kg
Sources:
Clinical System: clin.treatmt.weight_before_treatment		 NUMBER(22)  PRE_WEIGHTComments:
Measured in Kg
Sources:
Clinical System: clin.treatmt.weight_before_treatment		 NUMBER(22) 
POST_WEIGHTComments:
Measured in Kg
Sources:
Clinical System: clin.treatmt.weight_after_treatment		 NUMBER(22)  POST_WEIGHTComments:
Measured in Kg
Sources:
Clinical System: clin.treatmt.weight_after_treatment		 NUMBER(22) 
TOTAL_FLUIDSComments:
Measured in liters
Sources:
Clinical System: clin.treatmt.fluids_qty		 NUMBER(22)  TOTAL_FLUIDSComments:
Measured in liters
Sources:
Clinical System: clin.treatmt.fluids_qty		 NUMBER(22) 
TREATMENT_DURATIONComments:
Length of treatment in minutes
Sources:
Clinical System: clin.treatmt.dialysis_time		 NUMBER(22)  TREATMENT_DURATIONComments:
Length of treatment in minutes
Sources:
Clinical System: clin.treatmt.dialysis_time		 NUMBER(22) 
CLEARANCESources:
Clinical System: clin.treatmt.dial_clearance		 NUMBER(22)  CLEARANCESources:
Clinical System: clin.treatmt.dial_clearance		 NUMBER(22) 
INSERT_DATESources:
ETL: audit_columns.g.system_date_at_insert		 DATE(7)  INSERT_DATESources:
ETL: audit_columns.g.system_date_at_insert		 DATE(7) 
UPDATE_DATESources:
ETL: audit_columns.g.system_date_at_update		 DATE(7)  UPDATE_DATESources:
ETL: audit_columns.g.system_date_at_update		 DATE(7) 
LASTEST_ROW_INDSources:
ETL: audit_columns.g.process		 CHAR(1)  LASTEST_ROW_INDSources:
ETL: audit_columns.g.process		 CHAR(1) 

 

Show sources for TREATMENT

Table Diagram:

Table diagram

Sample query script:

Highlight all, copy to clipboard, and paste as needed

 

 

 

 

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:48,  Questions? Contact 'chris _ thullen (a) yekesys d0t c0m'