PAT_ALLERGIES

Description:

The allergies that are associated with a patient are stored on this table. This table also provides a link from the Patient (EPT) based tables to the Problem List (LPL) based tables.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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	ALLERGY_RECORD_ID	NUMERIC	No
	This column contains the allergies that are associated with the patient. The allergies are stored as unique identifiers so they can be networked to the problem (LPL) master file.