lab_result

One row per laboratory result, holding both the order and the component measured. Source and normalized codes, units and reference ranges are kept side by side so you can compare a value against the range the performing lab actually used, or against a normalized range.

At a glance

Schema	dax_core
Table	lab_result
Layer	Core Data Model
Object type	table
Columns	34
Grain	lab_result_id, data_source
Tags	core

Columns

Column	Type	Key	Terminology	Constraints	Description
lab_result_id	varchar	PK	—	not null	Dax identifier for the lab result.
person_id	varchar		—	not null	The individual the specimen was taken from.
patient_id	varchar		—	—	—
encounter_id	varchar		—	—	Encounter the result is associated with, where known.
accession_number	varchar		—	—	Laboratory accession number for the specimen.
source_order_type	varchar		Code type	—	—
source_order_code	varchar		LOINC	—	—
source_order_description	varchar		—	—	—
source_component_type	varchar		—	—	—
source_component_code	varchar		LOINC	—	Code for the measured component, as received.
source_component_description	varchar		—	—	—
normalized_order_type	varchar		Code type	—	—
normalized_order_code	varchar		LOINC	—	—
normalized_order_description	varchar		—	—	—
normalized_component_type	varchar		—	—	—
normalized_component_code	varchar		LOINC	—	Measured component after terminology normalization.
normalized_component_description	varchar		—	—	—
status	varchar		—	—	—
result	varchar		—	—	The result value.
result_datetime	timestamp		—	—	When the result was reported.
collection_datetime	timestamp		—	—	When the specimen was collected.
source_units	varchar		—	—	Units as reported by the source.
normalized_units	varchar		—	—	Units after normalization.
source_reference_range_low	varchar		—	—	Lower bound of the source reference range.
source_reference_range_high	varchar		—	—	Upper bound of the source reference range.
normalized_reference_range_low	varchar		—	—	—
normalized_reference_range_high	varchar		—	—	—
source_abnormal_code	varchar		—	—	Abnormal flag as reported by the source.
normalized_abnormal_code	varchar		—	—	—
specimen	varchar		—	—	Specimen type.
ordering_practitioner_id	varchar		Provider	—	—
ingest_datetime	timestamp		—	—	—
dax_last_run	timestamp		—	—	Timestamp of the warehouse build that produced this row.
data_source	varchar	PK	—	not null	Label for the contributing system.

Querying

select *
from dax_core.lab_result
limit 100;