EMR_ENCOUNTERS_ENC_MED_LOG · 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
1	MEDICATION_ID PK	integer	int	no
2	ENCOUNTER_ID PK	integer	int	no
3	ACCOUNT	string	varchar(12)	no
4	DRUG_NAME	string	varchar(100)	yes
5	BRAND_NAME	string	varchar(50)	yes
6	GENERIC_NAME	string	varchar(80)	yes
7	DOSAGE_FORM	string	varchar(50)	yes
8	DOSAGE_DESCRIPTION	string	varchar(50)	yes
9	DOSAGE_VALUE	string	varchar(50)	yes
10	DOSAGE_FREQUENCY	string	varchar(50)	yes
11	REFILLS	string	varchar(10)	yes
12	ROUTE	string	varchar(50)	yes
13	DISPENSE	integer	smallint	yes
14	PRESCRIPTION_NOTES	string	varchar(max)	yes
15	PRESCRIPTION_DATE	datetime	datetime	yes
16	PROVIDER_CODE	string	varchar(20)	yes
17	IS_ACTIVE	boolean	bit	yes
18	STRENGTH_VALUE	string	varchar(50)	yes
19	STRENGTH_UNITS	string	varchar(50)	yes
20	CPOE	boolean	bit	yes
21	SUBSTITUTION_PERMITTED	boolean	bit	yes
22	QUANTITY	string	varchar(10)	yes
23	QUANTITY_UNIT	string	varchar(20)	yes
24	FORMULA_STRENGTH	string	varchar(50)	yes
25	DRUG_FORM	string	varchar(50)	yes
26	DURATION	integer	int	yes
27	PAT_NOTES	string	varchar(350)	yes
28	OTHER_NOTES	string	varchar(350)	yes
29	STOP_DATE	datetime	datetime	yes
30	STOP_REASON	string	varchar(350)	yes
31	FILL_DATE	datetime	datetime	yes