EMR_MMT_ORDERS · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT; or ENCOUNTER_ID matches EMR_ENCOUNTERS.ENCOUNTER_ID on a row of EMR_ENCOUNTERS that relates to the patient

Single-patient export: the patient's rows.

02Columns

#	Column	Type	Source type	Null	Notes
1	ENCOUNTER_ID PK	integer	int	no
2	ACCOUNT PK	string	varchar(12)	no
3	EPISODE_CARE_ID PK	integer	int	no
4	ORDER_DATE	datetime	smalldatetime	no
5	PROVIDER_CODE	string	varchar(20)	no
6	STAGE_ID	integer	int	yes
7	ENTRY_USER_ID	string	varchar(20)	no
8	ENTRY_DATE	datetime	datetime	no
9	CHANGE_USER_ID	string	varchar(20)	no
10	CHANGE_DATE	datetime	datetime	no
11	SCHEDULE_NAME	string	varchar(40)	yes
12	ORDER_ACTIVE	boolean	bit	no
13	ORDER_VOID	boolean	bit	no
14	VOID_DATE	datetime	datetime	yes
15	VOID_USER_ID	string	varchar(20)	yes
16	NUM_TAKE_HOME	integer	int	no
17	CARRY_DAY	integer	int	yes
18	SPLIT_DOSE	boolean	bit	no
19	START_DATE	datetime	datetime	no
20	END_DATE	datetime	datetime	yes
21	DOSE_AMOUNT	decimal	numeric(5,2)	no
22	DOSE_AMOUNT_2	decimal	numeric(5,2)	yes
23	DOSE_FORM	integer	int	no	Medication form. Codes: `MMT_DOSE_FORM`
24	URINE_FREQ	integer	int	yes
25	URINE_PER	integer	int	yes
26	TEST_TYPE	integer	int	yes
27	BAC_FREQ	integer	int	yes
28	BAC_PER	integer	int	yes
29	TEST_BAC	boolean	bit	yes
30	DISPENSE_TIME	datetime	datetime	yes
31	DISPENSE_TIME_SPLIT	datetime	datetime	yes
32	NEXT_REVIEW_DATE	datetime	datetime	yes
33	THB_MON	boolean	bit	yes
34	THB_TUE	boolean	bit	yes
35	THB_WED	boolean	bit	yes
36	THB_THU	boolean	bit	yes
37	THB_FRI	boolean	bit	yes
38	THB_SAT	boolean	bit	yes
39	THB_SUN	boolean	bit	yes
40	DETOX_BUILD_UP	boolean	bit	yes
41	STEP_DAYS	integer	int	yes
42	STEP_AMOUNT	decimal	numeric(5,2)	yes
43	TARGET_DOSE	decimal	numeric(5,2)	yes
44	TARGET_DOSE_2	decimal	numeric(5,2)	yes
45	TABS_ONLY	boolean	bit	yes
46	BLIND_DOSE	boolean	bit	yes
47	START_DOSE	decimal	numeric(5,0)	yes
48	SERVICE_NAME	string	varchar(40)	yes
49	SERVICE_NAME_START	string	varchar(40)	yes
50	START_SVC_DAYS	integer	int	yes
51	NO_TAKE_HOME	boolean	bit	yes
52	ALL_TAKE_HOME	boolean	bit	yes
53	VIVITROL_INTERVAL	integer	int	yes
54	TAB_40	boolean	bit	yes
55	TAB_10	boolean	bit	yes
56	TAB_5	boolean	bit	yes
57	SUPPLY_CODE	string	varchar(10)	yes
58	THIRD_PARTY	boolean	bit	yes
59	CHOOSE_TABS	boolean	bit	yes
60	NUM_40	decimal	numeric(5,2)	yes
61	NUM_10	decimal	numeric(5,2)	yes
62	NUM_5	decimal	numeric(5,2)	yes
63	NUM_40_2	decimal	numeric(5,2)	yes
64	NUM_10_2	decimal	numeric(5,2)	yes
65	NUM_5_2	decimal	numeric(5,2)	yes
66	NUM_8	decimal	numeric(5,2)	yes
67	NUM_2	decimal	numeric(5,2)	yes
68	NUM_8_2	decimal	numeric(5,2)	yes
69	NUM_2_2	decimal	numeric(5,2)	yes
70	ANNIV_DAY	integer	int	yes
71	HOLIDAY_POLICY	integer	int	yes
72	FREQUENCY	integer	int	yes
73	NUM_SUBLOCADE_300	integer	int	yes
74	COMMENTS	string	varchar(4000)	yes