The ALLERGY_REACTIONS table contains the category values of the reactions associated with a given allergy. There may be multiple reactions associated with a single allergy. In this case, there will be multiple records in this table with the same ALLERGY_ID, but with different LINE values.
Primary Key
Column Name
Ordinal Position
ALLERGY_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
ALLERGY_ID
NUMERIC
No
The unique ID used to identify the allergy record.
2
LINE
INTEGER
No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3
REACTION_C_NAME
VARCHAR
No
The integer category value corresponding to the type of allergy reaction. To display names and/or abbreviations, link to the associated ZC lookup table.