EMR_ALERTS_MASTER · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT; or ENCOUNTER_ID matches EMR_ENCOUNTERS.ENCOUNTER_ID on a row of EMR_ENCOUNTERS that relates to the patient

Single-patient export: the patient's rows.

#	Column	Type	Source type	Null
1	ALERT_ID PK	integer	int	no
2	ALERT_CAT_ID	integer	int	no
3	ALERT_CREATED_DATE	datetime	datetime	no
4	ALERT_EXPIRY_DATE	datetime	datetime	yes
5	ALERT_CLOSING_REASON	string	varchar(500)	yes
6	ALERT_CLOSING_DATE	datetime	datetime	yes
7	ALERT_FREQUENCY_NUMBER	integer	smallint	yes
8	ALERT_FREQUENCY_ID	integer	int	yes
9	ALERT_ON	boolean	bit	yes
10	ALERT_MESSAGE	string	varchar(max)	yes
11	ACCOUNT	string	varchar(12)	yes
12	PROVIDER_CODE	string	varchar(20)	yes
13	ALERT_START_DATE	datetime	datetime	yes
14	MODIFIED_USERID	string	varchar(20)	yes
15	MODIFIED_DATETIME	datetime	datetime	yes
16	ALERT_SUBJECT	string	varchar(100)	yes
17	IS_DELETED	boolean	bit	yes
18	ENCOUNTER_ID	integer	int	yes
19	APPT_ID	integer	int	yes
20	EPISODE_CARE_ID	integer	int	yes
21	LAB_ORDER_NUMBER	string	varchar(20)	yes
22	LAB_ID	string	varchar(40)	yes
23	SHOW_ON_ENC	boolean	bit	yes
24	CATEGORY_MASTER_ID	integer	int	yes
25	IMAGE_ID	integer	int	yes
26	FREQUENCY_ID	integer	int	yes