ALLERGY_REACTIONS

Description:

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. May contain organization-specific values: Yes