EMR_GENERIC_GRID_DATA_ELEMENTS · 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	GRID PK	string	varchar(5)	no
2	DATA_ELEMENT_ID PK	integer	int	no
3	DATA_ELEMENT_NAME	string	varchar(50)	no
4	ELEMENT_DESCRIPTION	string	varchar(50)	yes
5	CONTROL_TYPE_ID	integer	int	yes
6	TABLE_NAME	string	varchar(50)	no
7	DATA_TYPE	string	varchar(20)	no
8	DATA_LENGTH	integer	int	yes
9	ELEMENT_HEIGHT	integer	int	no
10	ELEMENT_WIDTH	integer	int	no
11	ELEMENT_TOP_POS	integer	int	no
12	ELEMENT_LEFT_POS	integer	int	no
13	IS_VISIBLE	boolean	bit	yes
14	LOOKUP_ID	integer	int	yes
15	LOOKUP_TABLE	string	varchar(50)	yes
16	LOOKUP_COLUMN	string	varchar(50)	yes
17	LOOKUP_VALUE_COLUMN	string	varchar(50)	yes
18	IS_REQUIRED	boolean	bit	yes
19	CUSTOM_VALUE	boolean	bit	yes
20	IS_ORDER_COLUMN	boolean	bit	yes
21	COL_SPAN	integer	int	yes