ORDER_MED_ALTCSN

Description:

It contains the unique contact specific alert number for the order. Link it to alert related tables, such as ALT_HISTORY, ALT_ORDINFO, to get alert related information.

Primary Key

Column Name	Ordinal Position
ORDER_MED_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	ORDER_MED_ID	NUMERIC	No
	The unique ID of the order record.
2	CONTACT_DATE_REAL	FLOAT	No
	The contact date that corresponds to the encounter this order alert occurred.
3	LINE	INTEGER	No
	The line number for each alert unique contact number.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	ALT_CSN_ID	NUMERIC	No
	The unique ID for the alert across all contacts and alerts in ALT master file. You could link this to ALT_HISTORY table to get the alert information.