ALT_PRC_DIAGNOSES

Description:

Diagnoses that are associated with Drug-Disease alerts.

Primary Key

Column Name	Ordinal Position
ALERT_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	ALERT_ID	NUMERIC	No
	This column stores the unique identifier of the alert record. You could link it to ALERT.ALT_ID to get patient and vendor information in table ALERT.
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 Count
4	CONTACT_DATE	DATETIME	No
	The date on which the encounter took place.
5	PRC_DIAGNOSES_ID	NUMERIC	No
	This item will have the diagnosis (EDG) IDs that cause this alert to fire.