EMR_TASKS_MASTER · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

#	Column	Type	Source type	Null
1	TASK_ID PK	integer	int	no
2	ACCOUNT	string	varchar(20)	yes
3	TASK_START_DATE	datetime	datetime	yes
4	TASK_EXPIRY_DATE	datetime	datetime	yes
5	TASK_FREQUENCY_NUMBER	integer	smallint	yes
6	TASK_FREQUENCY_ID	integer	smallint	yes
7	TASK_REPEAT	boolean	bit	yes
8	TASK_MESSAGE	string	text	yes
9	TASK_TYPE_ID	integer	smallint	yes
10	TASK_STATUS_ID	integer	smallint	yes
11	TASK_PRIORITY	string	varchar(20)	yes
12	TASK_SUBJECT	string	varchar(100)	yes
13	USER_ID	string	varchar(20)	yes
14	TASK_CREATED_DATE	datetime	datetime	no
15	TASK_MODIFIED_USERID	string	varchar(20)	yes
16	TASK_MODIFIED_DATE	datetime	datetime	yes
17	IS_DELETED	boolean	bit	yes
18	TASK_MAP_ID	integer	int	yes