MMT_DOSE_DETAILS · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

BOTTLE_ID, FILL_DATE, ACTION_DATE → MMT_DISPENSING_BOTTLE_ACTIONS.BOTTLE_ID, FILL_DATE, ACTION_DATE
DOSE_FORM → MMT_DOSE_FORMS.DOSE_FORM
HOUSING_UNIT → HOUSING_UNITS.HOUSING_UNIT
OFFICE_LOCATION → LOCATIONS.OFFICE_LOCATION
RESERVE_USER_ID → USERS.USER_ID
STOCK_ID, STOCK_LINE_NO → MMT_STOCK_DEPLETIONS.STOCK_ID, STOCK_LINE_NO
TG_USER_ID → USERS.USER_ID
DISPENSE_USER_ID → USERS.USER_ID
WINDOW_USER_ID → USERS.USER_ID
DOSE_DATE, DOSE_SEQUENCE, DOSE_GEN, ACCOUNT, EPISODE_CARE_ID, ORDER_ID → MMT_ORDER_DETAILS.DOSE_DATE, DOSE_SEQUENCE, DOSE_GEN, ACCOUNT, EPISODE_CARE_ID, ORDER_ID

#	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	DOSE_DATE PK	datetime	smalldatetime	no
5	DOSE_SEQUENCE PK	integer	int	no
6	DOSE_LINE_NO PK	integer	int	no
7	STOCK_ID	integer	int	yes
8	STOCK_LINE_NO	integer	int	yes
9	BOTTLE_ID	integer	int	yes
10	ACTION_DATE	datetime	datetime	yes
11	FILL_DATE	datetime	smalldatetime	yes
12	COMMENTS	string	varchar(1000)	yes
13	EXCEPTION_DOSE	boolean	bit	no
14	DISPENSE_DATE	datetime	datetime	yes
15	DISPENSE_USER_ID	string	varchar(20)	yes
16	DOSE_FORM	integer	int	no	Medication form. Codes: `MMT_DOSE_FORM`
17	TAKE_HOME_DAY	boolean	bit	no
18	TAKE_HOME	boolean	bit	no
19	DOSE_AMOUNT	decimal	numeric(5,2)	no
20	DOSE_GEN PK	integer	int	no
21	ACTION	integer	int	yes
22	RESERVE_USER_ID	string	varchar(20)	yes
23	RESERVE_DATE	datetime	datetime	yes
24	WINDOW_USER_ID	string	varchar(20)	yes
25	TG_TH_PICKUP	boolean	bit	yes
26	TG_TH_LOCKBOX	boolean	bit	yes
27	TG_SIDE_EFFECTS	boolean	bit	yes
28	TG_MISSED_DOSES	boolean	bit	yes
29	TG_WITHDRAWAL	boolean	bit	yes
30	TG_OBSERVATION	string	varchar(1000)	yes
31	TG_OBS_SIDE_EFFECTS	string	varchar(1000)	yes
32	TG_OBS_MISSED_DOSES	string	varchar(1000)	yes
33	TG_OBS_WITHDRAWAL	string	varchar(1000)	yes
34	TG_INGESTION	boolean	bit	yes
35	TG_INGESTION_NONE	boolean	bit	yes
36	TG_INGESTION_MILD	boolean	bit	yes
37	TG_INGESTION_SEVERE	boolean	bit	yes
38	TG_USER_ID	string	varchar(20)	yes
39	TG_DATETIME	datetime	datetime	yes
40	TG_START_DATETIME	datetime	datetime	yes
41	HOUSING_UNIT	string	varchar(20)	yes
42	OFFICE_LOCATION	string	varchar(20)	yes