OTP_ALERT_CSN

Description:

The contact serial numbers (CSNs) of all alerts (ALT records) that have been shown for the linked patient order template (OTP) record.

Primary Key

Column Name	Ordinal Position
OTP_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	OTP_ID	NUMERIC	No
	The order template ID.
2	CONTACT_DATE_REAL	FLOAT	No
	This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3	LINE	INTEGER	No
	The line number that corresponds to an alert contact serial number (CSN) in the order template in this row.
4	CONTACT_DATE	DATETIME	No
	The contact date in external format of the showing of an alert contact serial number (CSN) in the order template in this row.
5	CM_CT_OWNER_ID	VARCHAR	No
	The ID of the deployment owner for this contact.
6	ALERT_CSN	NUMERIC	No
	The contact serial number (CSN) of an alert in the order template in this row.