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.