PATIENT_ALG_UPD_HX

Description:

The PATIENT_ALG_UPD_HX table contains one record for each update of a patient's allergy information.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID assigned to the patient record.
2	LINE	INTEGER	No
	The line number of a specific allergy update in the patient's allergy update history. This is the second column in the primary key and, in addition to the patient ID, uniquely identifies a patient allergy update.
3	ALRG_UPDT_DATE	DATETIME	No
	The date on which the patient's allergy history was updated.
4	ALRG_UPDT_USER_ID	VARCHAR	No
	The user who last updated the patient's allergy history.
5	ALRG_UPDT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	ALRG_UPDT_TIME	DATETIME	No
	The time at which the patient's allergy history was updated.
7	ALRG_HX_REV_STAT_C_NAME	VARCHAR	No
	This item stores the history of the status of the review of allergies. May contain organization-specific values: Yes Category Entries: Not Used Mark as Reviewed Verified Viewed Only Fully Reviewed Partially Reviewed Unable to Assess
8	ALRG_HX_REV_REAS_C_NAME	VARCHAR	No
	This item stores the history of the review reason of allergies. May contain organization-specific values: Yes Category Entries: Patient unable to communicate Patient unreliable Patient not present Language barrier Parent, guardian, or caregiver unavailable
9	ALRG_UPDT_DTTM	DATETIME	No
	The date and time at which the patient's allergy history was updated.
10	ALRG_HX_REV_EPT_CSN	NUMERIC	No
	This column contains historical entries for the source encounter where allergies were reviewed. If allergies were reviewed outside the context of an encounter, the value is null.