| S.LAB_RESULT | | clin.rslt (Clinical System)
audit_columns.g (ETL) |
|
| Column | Type | | Column | Type | Table | | Comment |
|---|
| PATIENT_ID | NUMBER | ⇐ | patient_number | | clin.rslt (Clinical System) | | |
| CLINIC_ID | NUMBER | ⇐ | clinic_number | | clin.rslt (Clinical System) | | |
| RESULT_TYPE | VARCHAR2 | ⇐ | result_type | | clin.rslt (Clinical System) | | |
| DRAW_DATE | DATE | ⇐ | blood_draw_dt | | clin.rslt (Clinical System) | | |
| VALUE | NUMBER | ⇐ | result_value | | clin.rslt (Clinical System) | | |
| UNITS | VARCHAR2 | ⇐ | result_unit | | clin.rslt (Clinical System) | | |
| RANGE | VARCHAR2 | ⇐ | result_range | | clin.rslt (Clinical System) | | |
| INSERT_DATE | DATE | ⇐ | system_date_at_insert | | audit_columns.g (ETL) | | |
| |