socialhistoryobservations.csv
This file contains information on the social history observations 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 social history observation.
observation_date
date
The date when the social history observation was made, as specified by the FHIR bundle.
encounter_date
date
The admit date of the encounter during which the social history observation was 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 components of the social history observation, as provided by the source.
loinccode and loincdisplay
string
The code and display of any LOINC codes that Orchestrate derived from the source code and uplift.
value_string
string
A result for the social history observation, if provided as a string by the source.
value
decimal
A result for the social history 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 social history observation’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 social history, if provided as a codeable type by the source.
value_snomed_code and value_snomed_display
string
The SNOMED code and display that Orchestrate derived from the value source code and uplift.
patient_id
string
The patient identifier of the patient for whom the social history was documented. Uniquely identifies a row in patients.csv.
encounter_id
string
The encounter on which the social history 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.