- 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
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
- allergyintolerance_id
- 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 |
- allergyintolerance_clinicalstatus_coding
- allergyintolerance_code_coding
- allergyintolerance_extension
- allergyintolerance_reaction
Version diff
Renamedallergy_intolerance_id→allergyintolerance_idsnomed_code→code_snomed_codesnomed_display→code_snomed_displayclinical_status_hl7_code→clinicalstatus_hl7_codeclinical_status_hl7_display→clinicalstatus_hl7_display
source_code_code→allergyintolerance_code_coding.codew/code_rank = 1source_code_display→allergyintolerance_code_coding.displayw/code_rank = 1source_code_system→allergyintolerance_code_coding.systemw/code_rank = 1source_clinical_status_code→allergyintolerance_clinicalstatus_coding.codew/code_rank = 1source_clinical_status_display→allergyintolerance_clinicalstatus_coding.displayw/code_rank = 1source_clinical_status_system→allergyintolerance_clinicalstatus_coding.systemw/code_rank = 1