This file contains information on the labs referenced in the FHIR bundle.
resource_id
string
The unique resource identifier from the FHIR bundle field observation.id where the observation represents a lab observation.
labreport_resource_id
string
The unique resource identifier from the FHIR bundle field diagnosticreport.id where the diagnostic report references the lab observation.
labobservation_date
date
The date on which the lab result was determined, as specified by the FHIR bundle.
labreport_date
date
The date on which the lab panel was taken, as specified by the FHIR bundle.
encounter_date
date
The admit date of the encounter during which the lab panel and result were documented, as specified by the FHIR bundle.
source_code, source_display, source_code_system, and source_code_text
string
The code, display, code system, and text for the lab observation, as provided by the source.
loinccode and loincdisplay
string
The LOINC code and display string that Orchestrate derived from the source code and uplift.
snomedcode and snomeddisplay
string
The SNOMED code and display string that Orchestrate derived from the source code and uplift.
value_string
string
A result for the observation, if provided as a string by the source.
value
decimal
A result for the observation, if provided as a physical quantity by the source.
unit_code, unit_display, and unit_code_system
string
The code, display, and code system components of the result’s unit of measurement.
value_source_code, value_source_display, value_source_code_system, and value_source_text
string
The code, display, code system, and text of the result, if provided as a codeable type by the source.
reference_range_low
decimal
The low end of the reference range for the lab observation.
reference_range_high
decimal
The high end of the reference range for the lab observation.
reference_range_unit_code, reference_range_unit_display, and reference_range_unit_code_system
string
The code, display, and code system of the reference range’s unit of measurement.
reference_range_text
string
The text of the reference range for the lab observation.
interpretation_code, interpretation_display, interpretation_code_system, and interpretation_text
string
The code, display, code system, and text of the lab observation’s interpretation.
labobservation_status_code, labobservation_status_display, and labobservation_status_code_system
string
The code, display, and code system of the lab observation status, as provided by the source.
labobservation_performer_npi, labobservation_performer_lastname, labobservation_performer_firstname, labobservation_performer_local_identifier, and labobservation_performer_id
string
The NPI, last name, first name, business identifier, and unique identifier (from providers.csv) of the performing provider for the lab observation. This can represent an individual performer or a performing facility.
labreport_source_code, labreport_source_display, labreport_source_code_system, labreport_source_code_text
string
The code, display, source system, and text of the lab panel, if provided as a codeable type by the source.
labreport_loinccode and labreport_loincdisplay
string
The LOINC code and display string that Orchestrate derived from the lab report source code and uplift.
labreport_snomedcode and labreport_snomeddisplay
string
The SNOMED code and display string that Orchestrate derived from the lab report source code and uplift.
labreport_hcpcscode and labreport_hcpcsdisplay
string
The HCPCS code and display string that Orchestrate derived from the lab report source code and uplift.
labreport_status_code, labreport_status_display, and labreport_status_code_system
string
The code, display, and code system of the lab panel status, as provided by the source.
patient_id
string
The patient identifier of the patient for whom the lab was documented. Uniquely identifies a row in patients.csv.
encounter_id
string
The encounter on which the lab was documented. Uniquely identifies a row in encounters.csv.
metadata_id
string
Reflects the origin of the data. Uniquely identifies a row in metadata.csv.