EMR_ENCOUNTERS_PRESCRIPTIONS · 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	PRESCRIPTION_ID PK	integer	int	no
2	RCOPIA_ID	string	varchar(50)	yes
3	ACCOUNT	string	varchar(12)	no
4	ENCOUNTER_ID	integer	int	yes
5	ENTRY_DATE	datetime	datetime	no
6	DRUG_NAME	string	varchar(100)	yes
7	DOSAGE_VALUE	string	varchar(50)	yes
8	DOSAGE_FORM	string	varchar(50)	yes
9	DOSAGE_DESCRIPTION	string	varchar(80)	yes
10	DOSAGE_FREQUENCY	string	varchar(50)	yes
11	REFILLS	string	varchar(10)	yes
12	ROUTE	string	varchar(50)	yes
13	PRESCRIPTION_NOTES	string	varchar(100)	yes
14	PROVIDER_CODE	string	varchar(20)	yes
15	USER_ID	string	varchar(20)	yes
16	IS_DELETED	boolean	bit	yes
17	GENERIC_NAME	string	varchar(80)	yes
18	STOP_DATE	datetime	datetime	yes
19	DRUG_FORM	string	varchar(50)	yes
20	NDCID	string	varchar(max)	yes
21	MODIFIED_BY	string	varchar(20)	yes
22	MODIFIED_DATE	datetime	datetime	yes
23	SUBSTITUTION_PERMITTED	boolean	bit	yes
24	QUANTITY	string	varchar(10)	yes
25	QUANTITY_UNIT	string	varchar(20)	yes
26	PAT_NOTES	string	varchar(350)	yes
27	OTHER_NOTES	string	varchar(350)	yes
28	FORMULA_STRENGTH	string	varchar(50)	yes
29	DURATION	integer	int	yes
30	DRUG_DESCRIPTION	string	varchar(350)	yes
31	COMPLETED_DATE	datetime	datetime	yes
32	SIGNED_DATE	datetime	datetime	yes
33	PRESCRIPTION_DATE	datetime	datetime	yes
34	STATUS	string	varchar(25)	yes
35	FDB_MED_ID	string	varchar(6)	yes
36	RX_NORM_ID	string	varchar(20)	yes
37	RX_NORM_TYPE	string	varchar(10)	yes