PAT_ENC_ED_AREA

Description:

The PAT_ENC_ED_AREA table contains a list of the Care Areas a patient was in during their stay in the ED.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_DATE_REAL	FLOAT	No
	This is a numeric representation of the date of this patient encounter.
2	CONTACT_DATE	DATETIME	No
	The contact date of the encounter associated with these care areas. Care areas typically represent a group of beds, a group of patients, or a unit within the hospital or organization.
3	LINE	INTEGER	No
	The line number of the care area list. Care areas typically represent a group of beds, a group of patients, or a unit within the hospital or organization.
4	ED_CARE_AREA_ID	NUMERIC	No
	The unique ID of the patient's care area during their stay in the Emergency Department. Care areas typically represent a group of beds, a group of patients, or a unit within the hospital or organization.
5	ED_AREA_TIME	DATETIME (Local)	No
	The instant that the patient was placed into this care area. Care areas typically represent a group of beds, a group of patients, or a unit within the hospital or organization.
6	PAT_ENC_CSN_ID	NUMERIC	No
	A unique serial number for this encounter. This number is unique across all patients and encounters in the system.