labs.csv
This file contains information on the labs referenced in the FHIR bundle.
Columns
The unique resource identifier from the FHIR bundle field observation.id
where the observation represents a lab observation.
The unique resource identifier from the FHIR bundle field diagnosticreport.id
where the diagnostic report references the lab observation.
The date on which the lab result was determined, as specified by the FHIR bundle.
The date on which the lab panel was taken, as specified by the FHIR bundle.
The admit date of the encounter during which the lab panel and result were documented, as specified by the FHIR bundle.
The code, display, and code system for the lab observation, as provided by the source.
The LOINC code and display string that Orchestrate derived from the source code and uplift.
The SNOMED code and display string that Orchestrate derived from the source code and uplift.
A result for the observation, if provided as a string by the source.
A result for the observation, if provided as a physical quantity by the source.
The code, display, and code system components of the result’s unit of measurement.
The code, display, and code system of the result, if provided as a codeable type by the source.
The code, display and source system of the lab panel, if provided as a codeable type by the source.
The LOINC code and display string that Orchestrate derived from the lab report source code and uplift.
The SNOMED code and display string that Orchestrate derived from the lab report source code and uplift.
The HCPCS code and display string that Orchestrate derived from the lab report source code and uplift.
The patient identifier of the patient for whom the lab was documented. Uniquely identifies a row in patients.csv
.
The encounter on which the lab was documented. Uniquely identifies a row in encounters.csv
.
Reflects the origin of the data. This may have been set in one of the previous convert operations. See Data Source.