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.
onset_date
date
The documented onset date of the condition, as specified by the FHIR bundle.
recorded_date
date
The date on which the condition was recorded, 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.
clinicalstatus_code, clinicalstatus_display, and clinicalstatus_code_system
string
The code, display, and code system of the condition’s documented status.
category_code, category_display, and category_code_system
string
The code, display, and code system of the condition’s documented type.
source_code, source_display, source_code_system, and source_code_text
string
The code, display, code system, and text of the condition, as provided by the source.
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.
recorder_npi, recorder_lastname, recorder_firstname, recorder_local_identifier, and recorder_id
string
The NPI, last name, first name, business identifier, and unique identifier (from providers.csv) of the provider who recorded the condition.
asserter_npi, asserter_lastname, asserter_firstname, asserter_local_identifier, and asserter_id
string
The NPI, last name, first name, business identifier, and unique identifier (from providers.csv) of the provider who asserted the condition.
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.
metadata_id
string
Reflects the origin of the data. Uniquely identifies a row in metadata.csv.