> ## 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`