| 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 |
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' |
S.TREATMENT in DEMODB | view S.TREATMENT_VW in DEMODB | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| S.TREATMENT_VW | View Sources | ||||||||||
| Column Name | Type | Column Name | Type | Sources | Joins | Comments | |||||
| PATIENT_ID | NUMBER(22) | PATIENT_ID | NUMBER(22) | Clinical System: clin.treatmt.patient_number | Join to table S.PATIENT on: PATIENT_ID = PATIENT_ID | ||||||
| CLINIC_ID | NUMBER(22) | CLINIC_ID | NUMBER(22) | Clinical System: clin.treatmt.clinic_number | Join to table S.CLINIC on: CLINIC_ID = CLINIC_ID | ||||||
| TREATMENT_DATE | DATE(7) | TREATMENT_DATE | DATE(7) | Clinical System: clin.treatmt.dial_date | Date of treatment. Start date for overnight treatments | ||||||
| TREATMENT_START_TIME | VARCHAR2(5) | TREATMENT_START_TIME | VARCHAR2(5) | Clinical System: clin.treatmt.dialysis_start_time | HH:MM in 24 hour format | ||||||
| BLOOD_FLOW_RATE | NUMBER(22) | BLOOD_FLOW_RATE | NUMBER(22) | Clinical System: clin.treatmt.blood_flow | |||||||
| DIALYSATE_FLOW_RATE | NUMBER(22) | DIALYSATE_FLOW_RATE | NUMBER(22) | Clinical System: clin.treatmt.dial_flow_rate | |||||||
| PRE_WEIGHT | NUMBER(22) | PRE_WEIGHT | NUMBER(22) | Clinical System: clin.treatmt.weight_before_treatment | Measured in Kg | ||||||
| POST_WEIGHT | NUMBER(22) | POST_WEIGHT | NUMBER(22) | Clinical System: clin.treatmt.weight_after_treatment | Measured in Kg | ||||||
| TOTAL_FLUIDS | NUMBER(22) | TOTAL_FLUIDS | NUMBER(22) | Clinical System: clin.treatmt.fluids_qty | Measured in liters | ||||||
| TREATMENT_DURATION | NUMBER(22) | TREATMENT_DURATION | NUMBER(22) | Clinical System: clin.treatmt.dialysis_time | Length of treatment in minutes | ||||||
| CLEARANCE | NUMBER(22) | CLEARANCE | NUMBER(22) | Clinical System: clin.treatmt.dial_clearance | |||||||
| INSERT_DATE | DATE(7) | INSERT_DATE | DATE(7) | ETL: audit_columns.g.system_date_at_insert | |||||||
| UPDATE_DATE | DATE(7) | UPDATE_DATE | DATE(7) | ETL: audit_columns.g.system_date_at_update | |||||||
| LASTEST_ROW_IND | CHAR(1) | LASTEST_ROW_IND | CHAR(1) | ETL: audit_columns.g.process | |||||||
Table Diagram:
Sample query script:
Highlight all, copy to clipboard, and paste as needed