EMR_TEMPLATES_LIST · 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	TEMPLATE_ID PK	integer	int	no
2	TEMPLATE_TYPE_ID	integer	smallint	no
3	TEMPLATE_NAME	string	varchar(50)	no
4	TEMPLATE_DESCRIPTION	string	varchar(50)	no
5	CREATED_DATE	datetime	datetime	no
6	CREATED_USER_ID	string	varchar(20)	no
7	MODIFIED_DATE	datetime	datetime	yes
8	MODIFIED_USER_ID	string	varchar(20)	yes
9	IS_DELETED	boolean	bit	no
10	MODIFIED_FROM	integer	int	yes
11	IS_ARCHIVED	boolean	bit	yes
12	IS_GROUP	boolean	bit	yes
13	COPY_FORWARD	boolean	bit	yes
14	SHOW_NORMAL_RESET	boolean	bit	yes
15	DO_NOT_PRINT	boolean	bit	yes
16	NARRATIVE	string	varchar(max)	yes