EMR_FORM_RULES · Accumedic EHI Export Format

01Relates to the patient

reference data (no patient link)

Single-patient export: included in full (reference data).

#	Column	Type	Source type	Null
1	RULE_NAME PK	string	varchar(40)	no
2	RULE_TYPE	integer	int	no
3	FORM_TYPE	integer	int	yes
4	DAYS_LO	integer	int	no
5	DAYS_HI	integer	int	no
6	DAYS_START	integer	int	no
7	DAYS_DUE	integer	int	no
8	FORM_RULE_ACTION	integer	int	no
9	APPT_EXISTS	boolean	bit	no
10	MESSAGE_SUBJECT	string	varchar(100)	yes
11	MESSAGE_BODY	string	varchar(max)	yes
12	PRIORITY	integer	int	no
13	SEND_SUPERVISOR	boolean	bit	no
14	SEND_PROGRAM_PROV	boolean	bit	no
15	SEND_ATTEND_PROV	boolean	bit	no
16	SEND_ADMIT_PROV	boolean	bit	no
17	SEND_PROGRAM_ADMIN	boolean	bit	no
18	SEND_PROGRAM_DIRECTOR	boolean	bit	no
19	SEND_PROGRAM_MANAGER	boolean	bit	no
20	SEND_ADDL_USER_LIST	string	varchar(max)	yes
21	RECURRENCE	boolean	bit	no
22	APPT_CLASS	string	varchar(15)	yes
23	CATEGORY_DETAIL_ID	integer	int	no
24	ROLE_ID	integer	int	yes
25	PROGRAM_CODE	string	varchar(15)	yes
26	COMPANY_CODE	string	varchar(20)	yes
27	NUM_AUTH_LEFT	integer	int	yes
28	AUTH_DAYS_LEFT	integer	int	yes
29	CHECK_HISTORY	boolean	bit	yes
30	DAYS_HISTORY	integer	int	yes