conditions.csv
This file contains information on the conditions referenced in the FHIR bundle.
Columns
resource_id
string
The unique resource identifier from the FHIR bundle field condition.id.
condition_onsetdate
date
The documented onset date of the condition, as specified by the FHIR bundle.
encounter_date
date
The admit date of the encounter during which the condition was documented, as specified by the FHIR bundle.
condition_clinicalstatus_code, condition_clinicalstatus_display, and condition_clinicalstatus_code_system
string
The code, display, and code system of the condition’s documented status.
condition_category_code, condition_category_display, and condition_category_code_system
string
The code, display, and code system of the condition’s documented type.
source_code, source_display, and source_code_system
string
The code, display, and code system of the condition’s documented code.
icd10code[N] and icd10display[N]
string
The code and display of any ICD10 codes that Orchestrate derived from the condition code and uplift. Each pair will be numbered sequentially, e.g., icd10code1 and icd10display1, icd10code2 and icd10display2, etc.
snomedcode[N] and snomeddisplay[N]
string
The code and display of any SNOMED codes that Orchestrate derived from the condition code and uplift. Each pair will be numbered sequentially, e.g., snomedcode1 and snomeddisplay1, snomedcode2 and snomeddisplay2 etc.
patient_id
string
The patient identifier of the patient for whom the condition was documented. Uniquely identifies a row in patients.csv.
encounter_id
string
The encounter on which the condition 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.