EMR_ENCOUNTERS_DRUGS_USED · Accumedic EHI Export Format

01Relates to the patient

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	ENCOUNTER_ID PK	integer	int	no
2	SEQUENCE_NO PK	integer	int	no
3	DRUG	string	varchar(max)	yes
4	DRUG_D_O	string	varchar(max)	yes
5	AMOUNT	string	varchar(max)	yes
6	FREQUENCY	string	varchar(max)	yes
7	DURATION	string	varchar(max)	yes
8	ROUTE	string	varchar(max)	yes
9	LAST_USE	datetime	datetime	yes
10	DRUGS_REVIEWED	boolean	bit	yes