observations.csv

In the FHIR to Manifest operation, this file collects observations with the following categories:

  • exam
  • procedure
  • survey
  • therapy

Other kinds of Observations can be found in other manifest files, such as Labs, Social History Observations, and Vital Signs.

Columns

resource_id string

The unique resource identifier from the FHIR bundle field observation.id.

observation_date date

The date on which the observation was made, as specified by the FHIR bundle.

encounter_date date

The admit date of the encounter during which the observation was documented, as specified by the FHIR bundle.

status_code, status_display, status_code_system, and status_code_text string

The code, display, code system, and text of the observation status, as provided by the source.

category_code, category_display, category_code_system, category_code_text string

The code, display, code system, and text of the observation category.

source_code, source_display, source_code_system, and source_code_text string

The code, display, code system, and text for the 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 observation.

reference_range_high decimal

The high end of the reference range for the 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 observation.

interpretation_code, interpretation_display, interpretation_code_system, and interpretation_text string

The code, display, code system, and text of the observation’s interpretation.

patient_id string

The patient identifier of the patient for whom the observation was documented. Uniquely identifies a row in patients.csv.

encounter_id string

The identifier of the encounter where the observation 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.