EMR_ENCOUNTERS_MEDICATION_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.

02References

ENCOUNTER_ID → EMR_ENCOUNTERS.ENCOUNTER_ID

03Columns

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	ADVERSE_EFFECTS	string	varchar(max)	yes
3	DATE_1	datetime	datetime	yes
4	DATE_2	datetime	datetime	yes
5	DATE_3	datetime	datetime	yes
6	DATE_4	datetime	datetime	yes
7	DATE_5	datetime	datetime	yes
8	DATE_6	datetime	datetime	yes
9	DATE_7	datetime	datetime	yes
10	DATE_8	datetime	datetime	yes
11	DATE_9	datetime	datetime	yes
12	DATE_10	datetime	datetime	yes
13	MEDICATION_1	string	varchar(20)	yes
14	MEDICATION_2	string	varchar(20)	yes
15	MEDICATION_3	string	varchar(20)	yes
16	MEDICATION_4	string	varchar(20)	yes
17	MEDICATION_5	string	varchar(20)	yes
18	MEDICATION_6	string	varchar(20)	yes
19	MEDICATION_7	string	varchar(20)	yes
20	MEDICATION_8	string	varchar(20)	yes
21	MEDICATION_9	string	varchar(20)	yes
22	MEDICATION_10	string	varchar(20)	yes
23	DOSAGE_1	string	varchar(20)	yes
24	DOSAGE_2	string	varchar(20)	yes
25	DOSAGE_3	string	varchar(20)	yes
26	DOSAGE_4	string	varchar(20)	yes
27	DOSAGE_5	string	varchar(20)	yes
28	DOSAGE_6	string	varchar(20)	yes
29	DOSAGE_7	string	varchar(20)	yes
30	DOSAGE_8	string	varchar(20)	yes
31	DOSAGE_9	string	varchar(20)	yes
32	DOSAGE_10	string	varchar(20)	yes
33	SUPPLY_1	string	varchar(20)	yes
34	SUPPLY_2	string	varchar(20)	yes
35	SUPPLY_3	string	varchar(20)	yes
36	SUPPLY_4	string	varchar(20)	yes
37	SUPPLY_5	string	varchar(20)	yes
38	SUPPLY_6	string	varchar(20)	yes
39	SUPPLY_7	string	varchar(20)	yes
40	SUPPLY_8	string	varchar(20)	yes
41	SUPPLY_9	string	varchar(20)	yes
42	SUPPLY_10	string	varchar(20)	yes
43	STATUS_1	string	varchar(10)	yes
44	STATUS_2	string	varchar(10)	yes
45	STATUS_3	string	varchar(10)	yes
46	STATUS_4	string	varchar(10)	yes
47	STATUS_5	string	varchar(10)	yes
48	STATUS_6	string	varchar(10)	yes
49	STATUS_7	string	varchar(10)	yes
50	STATUS_9	string	varchar(10)	yes
51	STATUS_10	string	varchar(10)	yes
52	PURPOSE_1	string	varchar(50)	yes
53	PURPOSE_2	string	varchar(50)	yes
54	PURPOSE_3	string	varchar(50)	yes
55	PURPOSE_4	string	varchar(50)	yes
56	PURPOSE_5	string	varchar(50)	yes
57	PURPOSE_6	string	varchar(50)	yes
58	PURPOSE_7	string	varchar(50)	yes
59	PURPOSE_8	string	varchar(50)	yes
60	PURPOSE_9	string	varchar(50)	yes
61	PURPOSE_10	string	varchar(50)	yes
62	RATIONALE_FOR_CHANGE_1	string	varchar(50)	yes
63	RATIONALE_FOR_CHANGE_2	string	varchar(50)	yes
64	RATIONALE_FOR_CHANGE_3	string	varchar(50)	yes
65	RATIONALE_FOR_CHANGE_4	string	varchar(50)	yes
66	RATIONALE_FOR_CHANGE_5	string	varchar(50)	yes
67	RATIONALE_FOR_CHANGE_6	string	varchar(50)	yes
68	RATIONALE_FOR_CHANGE_7	string	varchar(50)	yes
69	RATIONALE_FOR_CHANGE_8	string	varchar(50)	yes
70	RATIONALE_FOR_CHANGE_9	string	varchar(50)	yes
71	RATIONALE_FOR_CHANGE_10	string	varchar(50)	yes
72	NAME_OF_PRESCRIBER_1	string	varchar(30)	yes
73	NAME_OF_PRESCRIBER_2	string	varchar(30)	yes
74	NAME_OF_PRESCRIBER_3	string	varchar(30)	yes
75	NAME_OF_PRESCRIBER_4	string	varchar(30)	yes
76	NAME_OF_PRESCRIBER_5	string	varchar(30)	yes
77	NAME_OF_PRESCRIBER_6	string	varchar(30)	yes
78	NAME_OF_PRESCRIBER_7	string	varchar(30)	yes
79	NAME_OF_PRESCRIBER_8	string	varchar(30)	yes
80	NAME_OF_PRESCRIBER_9	string	varchar(30)	yes
81	NAME_OF_PRESCRIBER_10	string	varchar(30)	yes
82	SOURCE_1	string	varchar(22)	yes
83	SOURCE_2	string	varchar(22)	yes
84	SOURCE_3	string	varchar(22)	yes
85	SOURCE_4	string	varchar(22)	yes
86	SOURCE_5	string	varchar(22)	yes
87	SOURCE_6	string	varchar(22)	yes
88	SOURCE_7	string	varchar(22)	yes
89	SOURCE_8	string	varchar(22)	yes
90	SOURCE_9	string	varchar(22)	yes
91	SOURCE_10	string	varchar(22)	yes
92	STATUS_8	string	varchar(10)	yes
93	MEDICATION_ID	integer	int	no
94	ACCOUNT	string	varchar(12)	no
95	DRUG_NAME	string	varchar(50)	yes
96	BRAND_NAME	string	varchar(50)	yes
97	GENERIC_NAME	string	varchar(80)	yes
98	DOSAGE_FORM	string	varchar(50)	yes
99	DOSAGE_DESCRIPTION	string	varchar(50)	yes
100	DOSAGE_VALUE	string	varchar(50)	yes
101	DOSAGE_FREQUENCY	string	varchar(50)	yes
102	REFILLS	string	varchar(10)	yes
103	ROUTE	string	varchar(50)	yes
104	DISPENSE	integer	smallint	no
105	PRESCRIPTION_NOTES	string	varchar(100)	yes
106	PRESCRIPTION_DATE	datetime	datetime	yes
107	PROVIDER_CODE	string	varchar(12)	yes
108	IS_ACTIVE	boolean	bit	yes
109	STRENGTH_VALUE	string	varchar(50)	yes
110	STRENGTH_UNITS	string	varchar(50)	yes
111	CPOE	boolean	bit	yes
112	SUBSTITUTION_PERMITTED	boolean	bit	yes
113	QUANTITY	string	varchar(10)	yes
114	QUANTITY_UNIT	string	varchar(20)	yes
115	FORMULA_STRENGTH	string	varchar(50)	yes
116	DRUG_FORM	string	varchar(50)	yes
117	DURATION	integer	int	yes
118	PAT_NOTES	string	varchar(350)	yes
119	OTHER_NOTES	string	varchar(350)	yes