- lab_result_id
- person_id
- patient_id
- encounter_id
| Column | Data Type | Description | Terminology |
|---|---|---|---|
| lab_result_id | string | Unique identifier for the lab result | - |
| person_id | string | Unique identifier for the person | - |
| member_id | string | Unique identifier for the member | - |
| patient_id | string | Unique identifier for the patient | - |
| encounter_id | string | Unique identifier for the encounter | - |
| practitioner_id | string | Unique identifier for the practitioner | - |
| lab_test_code | string | Standardized lab test code | LOINC |
| lab_test_code_type | string | Type of coding system used | loinc |
| lab_test_code_system | string | Coding system identifier | - |
| lab_test_code_version | string | Version of the coding system | - |
| lab_test_code_display | string | Human-readable description of the lab test | - |
| lab_test_date | date | Date when the lab test was performed | - |
| lab_result_value | string | Value of the lab result | - |
| lab_result_value_type | string | Data type of the lab result value | quantity, codeable-concept, string |
| lab_result_unit | string | Unit of measurement for the lab result | - |
| lab_result_status | string | Status of the lab result | final, preliminary, amended |
| reference_range_low | string | Lower bound of the reference range | - |
| reference_range_high | string | Upper bound of the reference range | - |
| reference_range_text | string | Text description of the reference range | - |
| abnormal_flag | string | Flag indicating if the result is abnormal | high, low, normal, critical |
| data_source | string | Source of the lab result data | claims, clinical, ehr |
| source_code | string | Original code from the source system | - |
| normalized_code | string | Standardized/normalized code | - |
| source_system | string | System that provided the lab result data | - |
| source_table | string | Table in the source system | - |
| source_id | string | Identifier from the source system | - |
| ingestion_date | timestamp | Date when the data was ingested | - |