EMR_TEMPLATELIST_DETAILS · Accumedic EHI Export Format

01Relates to the patient

reference data (no patient link)

Single-patient export: not included (not referenced by patient records).

#	Column	Type	Source type	Null
1	TEMPLATE_LIST_ID PK	integer	int	no
2	TEMPLATE_ID PK	integer	int	no
3	DATA_ELEMENT_ID	integer	int	no
4	CONTROL_TYPE_ID	integer	smallint	no
5	LOOKUP_ID	integer	int	yes
6	CATEGORY_DETAIL_ID	integer	int	yes
7	CONTROL_HEIGHT	integer	smallint	no
8	CONTROL_WIDTH	integer	smallint	no
9	CONTROL_TOP_POS	integer	smallint	no
10	CONTROL_LEFT_POS	integer	smallint	no
11	ISBOLD	boolean	bit	yes
12	IS_ITALIC	boolean	bit	yes
13	FONT_SIZE	string	varchar(10)	yes
14	FONT_FAMILY	string	varchar(50)	yes
15	CAPTION	string	varchar(150)	yes
16	CAPTION_POSITION	integer	int	yes
17	CAPTION_SHOW_COLON	boolean	bit	yes
18	CAPTION_FONT_SIZE	string	varchar(10)	yes
19	CAPTION_FONT_FAMILY	string	varchar(50)	yes
20	CAPTION_IS_BOLD	boolean	bit	yes
21	CAPTION_IS_ITALIC	boolean	bit	yes
22	REPEAT_COLUMNS	integer	int	yes