EMR_DEMOG_TEMPLATE_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	DEMOG_ELEMENT_ID PK	integer	int	no
2	DEMOG_ELEMENT_NAME	string	varchar(50)	no
3	DESCRIPTION	string	varchar(50)	yes
4	CONTROL_TYPE_ID	integer	smallint	yes
5	TABLE_NAME	string	varchar(50)	yes
6	DATA_TYPE	string	varchar(20)	yes
7	LENGTH	integer	smallint	yes
8	CONTROL_HEIGHT	integer	smallint	yes
9	CONTROL_WIDTH	integer	smallint	yes
10	CONTROL_TOP_POS	integer	smallint	yes
11	CONTROL_LEFT_POS	integer	smallint	yes
12	IS_VISIBLE	boolean	bit	yes
13	LOOKUP_ID	integer	int	yes
14	LOOKUP_TABLE	string	varchar(50)	yes
15	LOOKUP_COLUMN	string	varchar(50)	yes
16	LOOKUP_VALUE_COLUMN	string	varchar(50)	yes
17	IS_REQUIRED	boolean	bit	yes