EMR_MMT_ORDER_DETAILS · 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.

#	Column	Type	Source type	Null	Notes
1	ACCOUNT PK	string	varchar(12)	no
2	EPISODE_CARE_ID PK	integer	int	no
3	ENCOUNTER_ID PK	integer	int	no
4	DOSE_DATE PK	datetime	smalldatetime	no
5	DOSE_SEQUENCE PK	integer	int	no
6	DOSE_GEN PK	integer	int	no
7	DOSE_FORM	integer	int	no	Medication form. Codes: `MMT_DOSE_FORM`
8	DOSE_AMOUNT	decimal	numeric(5,2)	no
9	TAKE_HOME_DAY	boolean	bit	no
10	TAKE_HOME	boolean	bit	no
11	EXCEPTION_DOSE	boolean	bit	no
12	EXCEPTION_USER_ID	string	varchar(20)	yes
13	EXCEPTION_DATE	datetime	datetime	yes
14	DOSE_REFUSED	boolean	bit	yes
15	COMMENTS	string	varchar(1000)	yes