EMR_ENCOUNTERS_SUBSTANCE_ABUSE · 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	TOBACCO_TYPE	string	varchar(max)	yes
3	TOBACCO_DURATION	string	varchar(max)	yes
4	TOBACCO_AMOUNT	string	varchar(max)	yes
5	TOBACCO_HEALTH_PROBLEMS	string	varchar(max)	yes
6	TOBACCO_AGE_FIRST_USE	integer	int	yes
7	ALCOHOL_FREQUENCY	string	varchar(max)	yes
8	ALCOHOL_AMOUNT	string	varchar(max)	yes
9	ALCOHOL_TYPE_OF_USE	string	varchar(max)	yes
10	ALCOHOL_DURATION	string	varchar(max)	yes
11	ALCOHOL_PATTERN	string	varchar(max)	yes
12	ALCOHOL_LAST_USE	string	varchar(max)	yes
13	ALCOHOL_LONGEST_PERIOD_SOBRIETY	string	varchar(max)	yes
14	ALCOHOL_DATES_OF_SOBRIETY	string	varchar(max)	yes
15	ALCOHOL_HEALTH_PROBLEMS	string	varchar(max)	yes
16	ALCOHOL_AGE_FIRST_USE	integer	int	yes
17	ALCOHOL_PREVIOUS_TREATMENT	string	varchar(max)	yes
18	DRUG_USE	string	varchar(max)	yes
19	AGE_FIRST_DRUG_USE	string	varchar(max)	yes
20	DRUG_LONGEST_PERIOD_SOBRIETY	string	varchar(max)	yes
21	DRUG_DATES_OF_SOBRIETY	string	varchar(max)	yes
22	DRUG_HEALTH_OR_FUNCTIONAL_PROBLEMS	string	varchar(max)	yes
23	DRUG_PREVIOUS_TREATMENTS	string	varchar(max)	yes
24	PROGRESSION	string	varchar(max)	yes
25	WITHDRAWAL_SYMPTOMS	string	varchar(max)	yes
26	RELATED_ACCIDENTS_INJURIES	string	varchar(max)	yes
27	HISTORY_OF_ABSTINENCE	string	varchar(max)	yes
28	AA_NA_ATTENDANCE	boolean	bit	yes
29	AA_NA_DETAILS	string	varchar(max)	yes
30	ADDITIONAL_INFO	string	varchar(max)	yes
31	SUB_ABUSE_REVIEWED	boolean	bit	yes