Schema
Lab Result
Schema documentation for the Lab Result table in the Metriport data model
The lab result table contains information about lab test results, including the LOINC code and description, units, reference range, and result.
Primary Keys:
- 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 | - |