| 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 |
LAB_RESULT
| Description: | Results of lab tests. Each row is one result. Multiple results are linked to one sample drawn from the patient. |
| What defines a unique row: | The logical key is CLINIC_ID, PATIENT_ID, DRAW_DATE, and RESULT_TYPE. Only one row with CURRENT_ROW_IND='Y' is expected for each logical key. The logical key and the INSERT_DATE consitute the database unique key. |
| Current rows: | CURRENT_ROW_IND = 'Y' |
| Historical rows: | CURRENT_ROW_IND = 'N' |
S.LAB_RESULT in DEMODB | view S.LAB_RESULT_VW in DEMODB | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| S.LAB_RESULT_VW | View Sources | ||||||||||
| Column Name | Type | Column Name | Type | Sources | Joins | Comments | |||||
| PATIENT_ID | NUMBER(22) | PATIENT_ID | NUMBER(22) | Clinical System: clin.rslt.patient_number | Join to table S.PATIENT on: PATIENT_ID = PATIENT_ID | Patient record number | |||||
| CLINIC_ID | NUMBER(22) | CLINIC_ID | NUMBER(22) | Clinical System: clin.rslt.clinic_number | Join to table S.CLINIC on: CLINIC_ID = CLINIC_ID | Clinic number | |||||
| RESULT_TYPE | VARCHAR2(18) | RESULT_TYPE | VARCHAR2(40) | Clinical System: clin.rslt.result_type | Join to table S.LAB_RESULT_TYPE on: RESULT_TYPE = S.LAB_RESULT_TYPE.LAB_RESULT_TYPE_CODE | Hemoglobin, albumin, ... Linked to reference table | |||||
| LAB_RESULT_TYPE_DESCRIPTION | VARCHAR2(18) | Available in the view based on join to the reference table | |||||||||
| DRAW_DATE | DATE(7) | DRAW_DATE | DATE(7) | Clinical System: clin.rslt.blood_draw_dt | The date when the sample was drawn from the patient | ||||||
| VALUE | NUMBER(22) | VALUE | NUMBER(22) | Clinical System: clin.rslt.result_value | The value returned by the lab | ||||||
| UNITS | VARCHAR2(9) | UNITS | VARCHAR2(9) | Clinical System: clin.rslt.result_unit | Unit of measure for the value, also known as dimension | ||||||
| RANGE | VARCHAR2(20) | RANGE | VARCHAR2(20) | Clinical System: clin.rslt.result_range | Range of acceptable values | ||||||
| INSERT_DATE | DATE(7) | INSERT_DATE | DATE(7) | ETL: audit_columns.g.system_date_at_insert | Date row was inserted into the table | ||||||
| UPDATE_DATE | DATE(7) | ||||||||||
| CURRENT_ROW_IND | VARCHAR2(5) | ||||||||||
Table Diagram:
Sample query script:
Highlight all, copy to clipboard, and paste as needed