| S.PATIENT | | clin.adm (Clinical System)
audit_columns.g (ETL) |
|
| Column | Type | | Column | Type | Table | | Comment |
|---|
| PATIENT_ID | NUMBER | ⇐ | patient_number | | clin.adm (Clinical System) | | |
| FIRST_DIALYSIS_DATE | DATE | ⇐ | patient_start_date | | clin.adm (Clinical System) | | |
| HEIGHT | NUMBER | ⇐ | patient_height_cm | | clin.adm (Clinical System) | | |
| HEIGHT_EFF_DATE | DATE | ⇐ | patient_height_date | | clin.adm (Clinical System) | | |
| PHYSICIAN_ID | NUMBER | ⇐ | physician_id | | clin.adm (Clinical System) | | |
| DIABETES_STATUS_CODE | VARCHAR2 | ⇐ | patient_has_diabetes | | clin.adm (Clinical System) | | |
| LAST_NAME | VARCHAR2 | ⇐ | patient_last_name | | clin.adm (Clinical System) | | |
| FIRST_NAME | VARCHAR2 | ⇐ | patient_first_name | | clin.adm (Clinical System) | | |
| GENDER | CHAR | ⇐ | patient_gender | | clin.adm (Clinical System) | | |
| DATE_OF_BIRTH | DATE | ⇐ | patient_dob | | clin.adm (Clinical System) | | |
| INSERT_DATE | DATE | ⇐ | system_date_at_insert | | audit_columns.g (ETL) | | |
| UPDATE_DATE | DATE | ⇐ | system_date_at_update | | audit_columns.g (ETL) | | |
| CURRENT_ROW_IND | CHAR | ⇐ | process | | audit_columns.g (ETL) | | |
| |