EMR_MASTER_TEMPLATES · Accumedic EHI Export Format

01Relates to the patient

reference data (no patient link)

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

02References

MASTER_TEMPLATE_CLASS → EMR_V_MASTER_TEMPLATE_CLASSES.MASTER_TEMPLATE_CLASS
FORM_ID → FORMS.FORM_ID
FORM_TYPE → EMR_FORM_TYPES.FORM_TYPE
GOAL_FORM_ID → FORMS.FORM_ID
INTERVENTION_TYPE → EMR_CLINICAL_INTERVENTION_TYPES.INTERVENTION_TYPE
MASTER_TEMPLATE_NAME → EMR_MASTER_TEMPLATE_NAMES.MASTER_TEMPLATE_NAME
FUNCTIONAL_AREA_TYPE → FUNCTIONAL_AREA_TYPES.FUNCTIONAL_AREA_TYPE
GOAL_GROUP_ID → W_GOAL_GROUPS.GOAL_GROUP_ID

03Columns

#	Column	Type	Source type	Null
1	MASTER_TEMPLATE_ID PK	integer	int	no
2	MASTER_TEMPLATE_NAME	string	varchar(50)	no
3	CREATED_DATE	datetime	datetime	no
4	CREATED_USER_ID	string	varchar(20)	no
5	MODIFIED_DATE	datetime	datetime	yes
6	MODIFIED_USER_ID	string	varchar(20)	yes
7	IS_DELETED	boolean	bit	no
8	ENC_TYPE_ID	integer	int	no
9	IS_FOLLOWUP	boolean	bit	yes
10	MODIFIED_FROM	integer	int	yes
11	IS_ARCHIVED	boolean	bit	yes
12	IS_GROUP	boolean	bit	yes
13	COPY_FORWARD	string	varchar(8)	yes
14	IS_TXTYPE	boolean	bit	yes
15	CPT_REQUIRED	boolean	bit	yes
16	DX_CODE_REQUIRED	boolean	bit	yes
17	REPORT_DEFINITION	string	varchar(500)	yes
18	SHOW_HEADER	boolean	bit	yes
19	SHOW_TEMP_HEADER	boolean	bit	yes
20	GROUP_PN_TYPE	integer	int	yes
21	COLLABORATE	boolean	bit	yes
22	USE_GOAL_PAGE	boolean	bit	yes
23	GOAL_FORM_ID	integer	int	yes
24	SIGNATURE_REQUIRED	boolean	bit	yes
25	FORM_ID	integer	int	yes
26	FORM_TYPE	integer	int	yes
27	FUNCTIONAL_AREA_TYPE	string	varchar(10)	yes
28	TX_NEED_TYPE	string	varchar(15)	yes
29	SHOW_MED_LOG	boolean	bit	yes
30	REVIEW_REQUIRED	boolean	bit	yes
31	SHOW_ASSESSMENTS	boolean	bit	yes
32	OASAS	boolean	bit	yes
33	SHOW_ANNOTATIONS	boolean	bit	yes
34	HIDE_GOALS	boolean	bit	yes
35	MASTER_TEMPLATE_CLASS	string	varchar(15)	yes
36	PRINT_BILLING_INFO	boolean	bit	yes
37	SHOW_BILLING_INFO	boolean	bit	yes
38	SHOW_TX_BUILDER	boolean	bit	yes
39	NYSCRI_3_TX	boolean	bit	yes
40	UNLICENSED_REQ_SUPV_SIG	boolean	bit	yes
41	INTERVENTION_TYPE	integer	int	yes
42	VISIT_SUMMARY_REPORT	string	varchar(50)	yes
43	PRINT_NARRATIVE	boolean	bit	yes
44	GOAL_GROUP_ID	integer	int	yes
45	APPT_TIME_REQUIRED	boolean	bit	yes
46	DECOUPLE_TX_ACTIONS	boolean	bit	yes
47	HIDE_HEADER	boolean	bit	yes
48	MULTI_USER_ROLE_ROUTE	boolean	bit	yes
49	SHOW_PROGRAM_TRANSFER	boolean	bit	yes
50	SHOW_TXPLAN	boolean	bit	yes
51	ROUTE_PSYCH_IF_ACTIVE_MEDS	boolean	bit	yes
52	ROUTE_PSYCH_IF_MEDICAID	boolean	bit	yes
53	HIDE_FORM_NAME	boolean	bit	yes
54	HIDE_VISIT_INFO	boolean	bit	yes
55	FORM_VERSION	integer	int	yes