MMT_ORDERS · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

SERVICE_NAME → SERVICES.SERVICE_NAME
DOSE_FORM → MMT_DOSE_FORMS.DOSE_FORM
ACCOUNT, EPISODE_CARE_ID → PAT_PROGRAMS.ACCOUNT, EPISODE_CARE_ID
PROVIDER_CODE → PROVIDERS.PROVIDER_CODE
SCHEDULE_NAME → MMT_SCHEDULES.SCHEDULE_NAME
STAGE_ID → MMT_STAGES.STAGE_ID
SUPPLY_CODE → V_MMT_STOCK_SUPPLY.SUPPLY_CODE
SERVICE_NAME_START → SERVICES.SERVICE_NAME

03Columns

#	Column	Type	Source type	Null	Notes
1	ACCOUNT PK	string	varchar(12)	no
2	EPISODE_CARE_ID PK	integer	int	no
3	ORDER_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	SPLIT_DOSE	boolean	bit	no
18	START_DATE	datetime	datetime	no
19	END_DATE	datetime	datetime	yes
20	DOSE_AMOUNT	decimal	numeric(4,1)	no
21	DOSE_FORM	integer	int	no	Medication form. Codes: `MMT_DOSE_FORM`
22	THB_MON	boolean	bit	yes
23	THB_TUE	boolean	bit	yes
24	THB_WED	boolean	bit	yes
25	THB_THU	boolean	bit	yes
26	THB_FRI	boolean	bit	yes
27	THB_SAT	boolean	bit	yes
28	THB_SUN	boolean	bit	yes
29	NEXT_REVIEW_DATE	datetime	datetime	yes
30	DISPENSE_TIME	datetime	datetime	yes
31	DISPENSE_TIME_SPLIT	datetime	datetime	yes
32	URINE_FREQ	integer	int	yes
33	URINE_PER	integer	int	yes
34	DOSE_AMOUNT_2	decimal	numeric(5,2)	yes
35	TARGET_DOSE_2	decimal	numeric(5,2)	yes
36	DETOX_BUILD_UP	boolean	bit	yes
37	STEP_DAYS	integer	int	yes
38	STEP_AMOUNT	decimal	numeric(5,2)	yes
39	TARGET_DOSE	decimal	numeric(5,2)	yes
40	TABS_ONLY	boolean	bit	yes
41	START_DOSE	decimal	numeric(5,2)	yes
42	TEST_BAC	boolean	bit	yes
43	BAC_FREQ	integer	int	yes
44	BAC_PER	integer	int	yes
45	TEST_TYPE	integer	int	yes
46	BLIND_DOSE	boolean	bit	yes
47	SERVICE_NAME	string	varchar(40)	yes
48	VIVITROL_INTERVAL	integer	int	yes
49	NO_TAKE_HOME	boolean	bit	yes
50	TAB_40	boolean	bit	yes
51	TAB_10	boolean	bit	yes
52	TAB_5	boolean	bit	yes
53	SUPPLY_CODE	string	varchar(10)	yes
54	SERVICE_NAME_START	string	varchar(40)	yes
55	START_SVC_DAYS	integer	int	yes
56	ALL_TAKE_HOME	boolean	bit	yes
57	THIRD_PARTY	boolean	bit	yes
58	NUM_40_2	decimal	numeric(5,2)	yes
59	NUM_10_2	decimal	numeric(5,2)	yes
60	NUM_5_2	decimal	numeric(5,2)	yes
61	CHOOSE_TABS	boolean	bit	yes
62	NUM_40	decimal	numeric(5,2)	yes
63	NUM_10	decimal	numeric(5,2)	yes
64	NUM_5	decimal	numeric(5,2)	yes
65	ANNIV_DAY	integer	int	yes
66	CARRY_DAY	integer	int	yes
67	HOLIDAY_POLICY	integer	int	yes
68	FREQUENCY	integer	int	yes
69	COMMENTS	string	varchar(max)	yes
70	NUM_8	decimal	numeric(5,2)	yes
71	NUM_2	decimal	numeric(5,2)	yes
72	NUM_8_2	decimal	numeric(5,2)	yes
73	NUM_2_2	decimal	numeric(5,2)	yes
74	NUM_SUBLOCADE_300	integer	int	yes
75	NUM_12	decimal	numeric(5,2)	yes
76	NUM_4	decimal	numeric(5,2)	yes
77	NUM_12_2	decimal	numeric(5,2)	yes
78	NUM_4_2	decimal	numeric(5,2)	yes