allergies.csv

This file contains information on the allergies referenced in the FHIR bundle.

Columns

resource_id string

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

recorded_date date

The date on which the allergy was recorded, as specified by the FHIR bundle.

onset_date date

The onset date of the allergy, as specified by the FHIR bundle.

encounter_date date

The admit date of the encounter during which the allergy 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 of the allergy, as provided by the source.

rxnormcode and rxnormdisplay string

The RxNorm 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.

icd10code and icd10display string

The ICD-10 code and display string that Orchestrate derived from the source code and uplift.

clinicalstatus_code, clinicalstatus_display, and clinicalstatus_code_system string

The code, display and code system of the allergy’s clinical status.

verificationstatus_code, verificationstatus_display, and verificationstatus_code_system string

The code, display and code system of the allergy’s verification status.

type_code, type_display, and type_code_system string

The code, display and code system of the allergy’s type.

category_code, category_display, and category_code_system string

The code, display and code system of the first allergy category.

criticality_code, criticality_display, and criticality_code_system string

The code, display and code system of the allergy’s criticality.

reaction_source_code, reaction_source_display, and reaction_source_code_system string

The code, display and code system of the allergy’s manifestation, if provided as a codeable type by the source.

reaction_snomedcode and reaction_snomeddisplay string

The SNOMED code and display string that Orchestrate derived from the manifestation coding.

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 allergy.

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 allergy.

patient_id string

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

encounter_id string

The encounter on which the allergy 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.