labs.csv
This file contains information on the labs referenced in the FHIR bundle.
Columns
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, and source_code_system
string
The code, display, and code system 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_display, unit_code_system, and unit_code
string
The code, display, and code system components of the result’s unit of measurement.
value_source_code, value_source_code_system, and value_source_display
string
The code, display, and code system of the result, if provided as a codeable type by the source.
labreport_source_code, labreport_source_display, and labreport_source_code_system
string
The code, display and source system 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.
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.
datasource
string
Reflects the origin of the data. This may have been set in one of the previous convert operations. See Data Source.