MMT_ORDER_DETAILS · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

DOSE_FORM → MMT_DOSE_FORMS.DOSE_FORM
EXCEPTION_USER_ID → USERS.USER_ID
ORDER_ID, ACCOUNT, EPISODE_CARE_ID → MMT_ORDERS.ORDER_ID, ACCOUNT, EPISODE_CARE_ID

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	DOSE_DATE PK	datetime	smalldatetime	no
5	DOSE_SEQUENCE PK	integer	int	no
6	DOSE_FORM	integer	int	no	Medication form. Codes: `MMT_DOSE_FORM`
7	DOSE_AMOUNT	decimal	numeric(4,1)	no
8	TAKE_HOME	boolean	bit	no
9	TAKE_HOME_DAY	boolean	bit	no
10	DOSE_GEN PK	integer	int	no
11	EXCEPTION_DOSE	boolean	bit	no
12	EXCEPTION_USER_ID	string	varchar(20)	yes
13	EXCEPTION_DATE	datetime	datetime	yes
14	COMMENTS	string	varchar(1000)	yes
15	DOSE_REFUSED	boolean	bit	yes
16	ORIG_TAKE_HOME	boolean	bit	yes
17	BOTTLE_ID	string	varchar(20)	yes