Patient Labs
labs ordered for a patient, the corresponding observed
measurements, and the reference measurements for each lab
MRN
Medical record number which is a unique identifier for an
individual patient.
LOG_ID
Each row of this table contains a unique LOG_ID, which
represents a single patient encounter. It is possible for
this table to have duplicate MRNs, indicating that a single
patient has come in for multiple surgeries.
Lab Code, Lab Name
The Lab Code is the Logical Observation Identifier Names and
Codes (LOINC) code for the laboratory test and the Lab Name
is the long common name for the laboratory test.
Observation Value, Measurement Units
The observation value is the observed value for the lab and
the measurement units are the units associated with observed
value.
Reference Range, Abnormal Flag
The reference range is the range of values for the lab that
are considered normal. The abnormal flag indicates whether
the observed value is normal (within the reference range),
low (below the reference range), or high (above the
reference range).
Collection Datetime
This is the date and time at which the lab was taken.