> ## Documentation Index
> Fetch the complete documentation index at: https://docs.metriport.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](https://hl7.org/fhir/R4/allergyintolerance.html) for full details.

**Previous version:** [allergy\_intolerance](/medical-api/handling-data/schema-v000/allergy-intolerance/base)

**Tables in this resource:**

* **allergyintolerance** – Main allergy/intolerance record (this page)
* [allergyintolerance\_code\_coding](/medical-api/handling-data/schema-v100/allergyintolerance/code_coding)
* [allergyintolerance\_clinicalstatus\_coding](/medical-api/handling-data/schema-v100/allergyintolerance/clinicalstatus_coding)
* [allergyintolerance\_reaction](/medical-api/handling-data/schema-v100/allergyintolerance/reaction) – Reactions
* [allergyintolerance\_reaction\_substance\_coding](/medical-api/handling-data/schema-v100/allergyintolerance/reaction_substance_coding)
* [allergyintolerance\_reaction\_manifestation](/medical-api/handling-data/schema-v100/allergyintolerance/reaction_manifestation) – Manifestations
* [allergyintolerance\_reaction\_manifestation\_coding](/medical-api/handling-data/schema-v100/allergyintolerance/reaction_manifestation_coding)
* [allergyintolerance\_extension](/medical-api/handling-data/schema-v100/allergyintolerance/extension)
* [allergyintolerance\_extension\_vcc\_coding](/medical-api/handling-data/schema-v100/allergyintolerance/extension_vcc_coding)
* **allergyintolerance\_references** – Normalized references; see [Reference Tables](/medical-api/handling-data/schema-v100/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](/medical-api/handling-data/schema-v100/patient/base) who has the allergy/intolerance
* **recorder**: links to the [practitioner](/medical-api/handling-data/schema-v100/practitioner/base) who recorded the allergy/intolerance

For detailed information about reference table structure and indexing, see the [Reference Tables documentation](/medical-api/handling-data/schema-v100/reference_tables).

**Main table**:

**Primary Keys:**

* allergyintolerance\_id

**Foreign Keys:**

* patient\_id – links to the [patient](/medical-api/handling-data/schema-v100/patient/base) table

<div style={{textAlign: 'right'}}><sub>† Metriport Platform added</sub></div>

| 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](/medical-api/handling-data/schema-v100/patient/base)

**Child:**

* [allergyintolerance\_clinicalstatus\_coding](/medical-api/handling-data/schema-v100/allergyintolerance/clinicalstatus_coding)
* [allergyintolerance\_code\_coding](/medical-api/handling-data/schema-v100/allergyintolerance/code_coding)
* [allergyintolerance\_extension](/medical-api/handling-data/schema-v100/allergyintolerance/extension)
* [allergyintolerance\_reaction](/medical-api/handling-data/schema-v100/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`](/medical-api/handling-data/schema-v100/allergyintolerance/code_coding) w/ `code_rank = 1`
* `source_code_display` → [`allergyintolerance_code_coding.display`](/medical-api/handling-data/schema-v100/allergyintolerance/code_coding) w/ `code_rank = 1`
* `source_code_system` → [`allergyintolerance_code_coding.system`](/medical-api/handling-data/schema-v100/allergyintolerance/code_coding) w/ `code_rank = 1`
* `source_clinical_status_code` → [`allergyintolerance_clinicalstatus_coding.code`](/medical-api/handling-data/schema-v100/allergyintolerance/clinicalstatus_coding) w/ `code_rank = 1`
* `source_clinical_status_display` → [`allergyintolerance_clinicalstatus_coding.display`](/medical-api/handling-data/schema-v100/allergyintolerance/clinicalstatus_coding) w/ `code_rank = 1`
* `source_clinical_status_system` → [`allergyintolerance_clinicalstatus_coding.system`](/medical-api/handling-data/schema-v100/allergyintolerance/clinicalstatus_coding) w/ `code_rank = 1`


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.