PATIENT_NOTICE

Description:

The PATIENT_NOTICE table contains information on inpatient security alerts.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The ID of the patient with this notice.
2	LINE	INTEGER	No
	The line number of the notice for the patient.
3	NOTICE_TYPE_C_NAME	VARCHAR	No
	The category value corresponding to the notice type for the patient. May contain organization-specific values: Yes
4	NOTICE_COMMENT	VARCHAR	No
	Free text comment concerning this notice.
5	USER_ID	VARCHAR	No
	The unique ID of the employee who entered this notice.
6	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	UPDATE_TIME	DATETIME (Local)	No
	The date when this notice was last updated.