allergyintolerance

A record of a clinical assessment of an allergy or intolerance; a propensity, or a potential risk to an individual, to have an adverse reaction on future exposure to the specified substance, or class of substance. See the HL7 FHIR R4 spec for full details.

Previous version: allergy_intolerance

Tables in this resource:

• allergyintolerance – Main allergy/intolerance record (this page)
• allergyintolerance_code_coding
• allergyintolerance_clinicalstatus_coding
• allergyintolerance_reaction – Reactions
• allergyintolerance_reaction_substance_coding
• allergyintolerance_reaction_manifestation – Manifestations
• allergyintolerance_reaction_manifestation_coding
• allergyintolerance_extension
• allergyintolerance_extension_vcc_coding
• allergyintolerance_references – Normalized references; see Reference Tables

Reference Table:

The allergyintolerance_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
• recorder: links to the practitioner who recorded the allergy/intolerance

For detailed information about reference table structure and indexing, see the Reference Tables documentation.

Main table:

Primary Keys:

• allergyintolerance_id

Foreign Keys:

• patient_id – links to the patient table

_{† Metriport Platform added}

Column	Data Type	Description
allergyintolerance_id	varchar	Unique identifier for the allergy/intolerance
patient_id	varchar	Unique identifier for the patient (subject)
onsetdatetime	datetime	Onset date/time if provided directly
onsetperiod_start	datetime	Start of onset period
onset_date†	datetime	Coalesced onset date (onsetdatetime or onsetperiod_start)
code_text	varchar	Free-text description of the allergy/intolerance code
code_snomed_code†	varchar	SNOMED CT code for the allergy/intolerance
code_snomed_display†	varchar	Human-readable SNOMED CT description
criticality	varchar	Criticality of the reaction (low, high, unable-to-assess)
clinicalstatus_text	varchar	Free-text clinical status
clinicalstatus_hl7_code†	varchar	HL7 clinical status code
clinicalstatus_hl7_display†	varchar	Human-readable HL7 description
meta_source	varchar	Source document filename from FHIR meta.source
data_source_ext†	varchar	Integration source derived from FHIR extension

Related Tables:

Parent:

• patient

Child:

• allergyintolerance_clinicalstatus_coding
• allergyintolerance_code_coding
• allergyintolerance_extension
• allergyintolerance_reaction

Version diff

Renamed

• allergy_intolerance_id → allergyintolerance_id
• snomed_code → code_snomed_code
• snomed_display → code_snomed_display
• clinical_status_hl7_code → clinicalstatus_hl7_code
• clinical_status_hl7_display → clinicalstatus_hl7_display

Moved to separate tables

• source_code_code → allergyintolerance_code_coding.code w/ code_rank = 1
• source_code_display → allergyintolerance_code_coding.display w/ code_rank = 1
• source_code_system → allergyintolerance_code_coding.system w/ code_rank = 1
• source_clinical_status_code → allergyintolerance_clinicalstatus_coding.code w/ code_rank = 1
• source_clinical_status_display → allergyintolerance_clinicalstatus_coding.display w/ code_rank = 1
• source_clinical_status_system → allergyintolerance_clinicalstatus_coding.system w/ code_rank = 1