Skip to main content
An allergy/intolerance record represents a patient’s allergy or intolerance to a substance. This includes details about the allergy/intolerance, its clinical status, and any reactions that have occurred. Reference Table: The allergy_intolerance_references table contains normalized references from the allergy/intolerance to other entities. It supports the following reference properties:
  • patient (required): links to the patient who has the allergy/intolerance
  • encounter: links to the encounter where the allergy/intolerance was recorded
  • recorder: links to the practitioner who recorded the allergy/intolerance
  • asserter: links to the practitioner or patient who asserted the allergy/intolerance
For detailed information about reference table structure and indexing, see the Reference Tables documentation. Allergy Intolerance Table: Primary Keys:
  • allergy_intolerance_id
Foreign Keys:
  • patient_id
ColumnData TypeDescription
allergy_intolerance_idvarcharUnique identifier for the allergy/intolerance
patient_idvarcharUnique identifier for the patient
clinical_status_hl7_codevarcharHL7 clinical status code
clinical_status_hl7_displayvarcharHuman-readable description of clinical status
source_clinical_status_codevarcharOriginal clinical status code from source system
source_clinical_status_displayvarcharOriginal clinical status display from source system
source_clinical_status_systemvarcharOriginal clinical status system from source system
snomed_codevarcharSNOMED CT code for the allergy/intolerance
snomed_displayvarcharHuman-readable description of SNOMED CT code
source_code_codevarcharOriginal coding code from source system
source_code_displayvarcharOriginal coding display from source system
source_code_systemvarcharOriginal coding system from source system
onset_datedateDate when the allergy/intolerance began
meta_sourcevarcharSource document filename from FHIR meta.source
data_source_extvarcharIntegration source of the data, derived from FHIR extension
Related Tables: