EMR_DATA_ELEMENT_MASTER · Accumedic EHI Export Format

01Relates to the patient

reference data (no patient link)

Single-patient export: included in full (reference data).

02References

CONTROL_TYPE_ID → EMR_CONTROL_TYPES.CONTROL_TYPE_ID
LOOKUP_ID → EMR_V_CATEGORIES_MASTER.CATEGORY_MASTER_ID
TEMPLATE_TYPE_ID → EMR_TEMPLATE_TYPES.TEMPLATE_TYPE_ID
VALIDATION_RULE_ID → EMR_VALIDATION_RULES.VALIDATION_RULE_ID
LINK_TABLE_NAME → EMR_LINK_TABLES.LINK_TABLE_NAME

03Columns

#	Column	Type	Source type	Null
1	DATA_ELEMENT_ID PK	integer	int	no
2	DATA_ELEMENT_NAME	string	varchar(100)	no
3	DESCRIPTION	string	varchar(500)	yes
4	TEMPLATE_TYPE_ID	integer	smallint	no
5	TABLE_NAME	string	varchar(50)	yes
6	COLUMN_NAME	string	varchar(100)	no
7	DATA_TYPE	string	varchar(20)	yes
8	LENGTH	integer	smallint	yes
9	IS_GOC	boolean	bit	yes
10	CONTROL_TYPE_ID	integer	smallint	no
11	DEFAULT_VALUE	string	varchar(500)	yes
12	LOOKUP_ID	integer	int	yes
13	IS_REQUIRED	boolean	bit	no
14	DEIDENTIFY	boolean	bit	no
15	VALIDATION_RULE_ID	integer	smallint	yes
16	UNITS	string	varchar(50)	yes
17	RANGE_FROM	string	varchar(50)	yes
18	RANGE_TO	string	varchar(50)	yes
19	CREATED_DATE	datetime	datetime	no
20	CREATED_USER_ID	string	varchar(20)	no
21	MODIFIED_DATE	datetime	datetime	yes
22	MODIFIED_USER_ID	string	varchar(20)	yes
23	MACRO_TEXT	string	varchar(100)	yes
24	MACRO_POSITION	string	char(1)	yes
25	SEARCH_TYPE_ID	integer	int	yes
26	TABLE_ALIAS	string	varchar(50)	yes
27	NORMAL_VALUE	string	varchar(500)	yes
28	CHART_REVIEW_ELEMENT	boolean	bit	yes
29	LINK_TABLE_NAME	string	varchar(50)	yes
30	LINK_COLUMN_NAME	string	varchar(100)	yes
31	LINK_KEY_NAME	string	varchar(100)	yes
32	LOOKUP_TABLE_NAME	string	varchar(50)	yes
33	LOOKUP_COLUMN_NAME	string	varchar(100)	yes
34	IS_READ_ONLY	boolean	bit	yes
35	PULL_TABLE_NAME	string	varchar(50)	yes
36	PULL_COLUMN_NAME	string	varchar(100)	yes
37	IS_REQUIRED_LAST_SIG	boolean	bit	yes
38	PRINT_CAPTION	string	varchar(100)	yes
39	LOOKUP_TARGET_COLUMN_NAME	string	varchar(100)	yes
40	PACKAGE_FORM_ACTION_VALUE	string	varchar(50)	yes
41	PACKAGE_FORM_NAME	string	varchar(50)	yes
42	LINK_SEQUENCE_KEY_NAME	string	varchar(100)	yes
43	LINK_SEQUENCE	integer	int	yes
44	LOOKUP_KEY	string	varchar(100)	yes
45	HINT	string	varchar(100)	yes
46	WATERMARK	string	varchar(350)	yes
47	IS_PULL_ONLY	boolean	bit	yes
48	REPEAT_COLUMNS	integer	int	yes
49	NARRATIVE_POS	string	varchar(500)	yes
50	NARRATIVE_NEG	string	varchar(500)	yes
51	LINK_NOT_NULL	boolean	bit	yes