labs.csv

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.

Columns