EMR_ENCOUNTERS_OASAS_SUBSTANCE_HISTORY · 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.

02References

ENCOUNTER_ID → EMR_ENCOUNTERS.ENCOUNTER_ID

03Columns

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	TREATMENT_FOR_SUBSTANCE	string	varchar(3)	yes
3	WILLING_TO_ATTEND	string	varchar(max)	yes
4	HOME	boolean	bit	yes
5	EXPERIENCED_LOSS_OF_MEMORY	string	varchar(3)	yes
6	HOSPITALIZED	string	varchar(3)	yes
7	FELT_BAD	string	varchar(3)	yes
8	FIRST_THING_IN_MORNING	string	varchar(3)	yes
9	HANGOVERS	boolean	bit	yes
10	CUT_DOWN	string	varchar(3)	yes
11	SELFHELP_GROUPS	string	varchar(3)	yes
12	FRIEND_HOME	boolean	bit	yes
13	INGEST	string	varchar(max)	yes
14	NEED_MORE_ALCOHOL	string	varchar(3)	yes
15	PERSONALITY_CHANGE	string	varchar(max)	yes
16	NAUSEA	boolean	bit	yes
17	NERVOUSNESS	boolean	bit	yes
18	SEIZURES	boolean	bit	yes
19	DESCRIBE_YOU	string	varchar(max)	yes
20	JOB_TROUBLE	boolean	bit	yes
21	TO_RELIEVE_PSYCHIATRIC_SYMPTOMS	boolean	bit	yes
22	REASONS_OTHER_COMMENT	string	varchar(64)	yes
23	CHILDOFUSER	string	varchar(30)	yes
24	DETOXDAYS	string	varchar(max)	yes
25	CONSIDER_SOBER_SUPPORTS	string	varchar(max)	yes
26	ALCOHOLIC_WHY	string	varchar(max)	yes
27	SUICIDE_ATTEMPT_TIMES	integer	int	yes
28	PEOPLE_ANNOYED	string	varchar(3)	yes
29	HALLUCINATIONS	boolean	bit	yes
30	SYMPTONS_OTHER_COMMENT	string	varchar(32)	yes
31	FINANCIAL_PROBLEMS	boolean	bit	yes
32	TO_RELIEVE_PHYSICAL_PAIN	boolean	bit	yes
33	TO_RELIEVE_EMOTIONAL_PAIN	boolean	bit	yes
34	WITHDRAWAL	boolean	bit	yes
35	CURRENTLY_ATTENDING_SELF_HELP	string	varchar(3)	yes
36	BAR	boolean	bit	yes
37	ACCIDENT_TIMES	integer	int	yes
38	SUICIDE_ATTEMPT	string	varchar(3)	yes
39	PEOPLE_EXPRESSED_WORRY	string	varchar(3)	yes
40	CHANGE_IN_APPETITE	boolean	bit	yes
41	MOOD_SWINGS	boolean	bit	yes
42	LACK_OF_MOTIVATION	boolean	bit	yes
43	ITCHING	boolean	bit	yes
44	CRAVINGS	boolean	bit	yes
45	HAD_ACCIDENT	string	varchar(3)	yes
46	DWAI	boolean	bit	yes
47	LOSS_OF_CONTROL	string	varchar(3)	yes
48	FAMILY_PROBLEMS	boolean	bit	yes
49	PROBLEMS_OTHER	boolean	bit	yes
50	DESCRIBE_HOW	string	varchar(max)	yes
51	SPONSOR	string	varchar(3)	yes
52	LEVEL	string	varchar(45)	yes
53	WORK	boolean	bit	yes
54	OVERDOSED_ON_ALCOHOL	string	varchar(3)	yes
55	BY_ACCIDENT	string	varchar(3)	yes
56	VOMITING	boolean	bit	yes
57	INFECTED_VEINS	boolean	bit	yes
58	VIOLENCE	boolean	bit	yes
59	SOCIAL_PROBLEMS	boolean	bit	yes
60	PHYSICAL_PROBLEMS	boolean	bit	yes
61	TWELVESTEPNOW	string	varchar(10)	yes
62	WHAT_IS_THE_LONGEST_PERIOD_OF_TIME_YOU_HAVE_BEEN_ABLE_TO_MAINTAIN_SOBRIETY	string	varchar(100)	yes
63	HOW_OFEN	string	varchar(75)	yes
64	CAR	boolean	bit	yes
65	OUTDOORS	boolean	bit	yes
66	WHERE_OTHER_COMMENT	string	varchar(85)	yes
67	HOSPITALIZED_TIMES	integer	int	yes
68	FELT_TO_CUT_DOWN	string	varchar(max)	yes
69	SWEATS	boolean	bit	yes
70	BLACKOUTS	boolean	bit	yes
71	SYMPTONS_OTHER	boolean	bit	yes
72	ACCIDENT_DESCRIBE	string	varchar(max)	yes
73	SPENDING_INCREASED_TIME	string	varchar(3)	yes
74	CONSEQUENCES_DOES_NOT_APPLY	boolean	bit	yes
75	CONSEQUENCE_OF_DRINKING_DESCRIBE	string	varchar(max)	yes
76	LEGAL_PROBLEMS	boolean	bit	yes
77	PERSONAL_EMBARRASSMENT	boolean	bit	yes
78	TO_RELIEVE_STRESS	boolean	bit	yes
79	TO_RELIEVE_FRUSTRATION	boolean	bit	yes
80	NUMBEREPS	string	varchar(20)	yes
81	PREVIOUS_TIME_SPENT_SOBER	string	varchar(500)	yes
82	BELIEVE_YOU_ARE	string	varchar(3)	yes
83	WHERE_OTHER	boolean	bit	yes
84	LOSS_MEMORY_TIMES	integer	int	yes
85	DEHYDRATION	boolean	bit	yes
86	FORGETFULNESS	boolean	bit	yes
87	YAWNING	boolean	bit	yes
88	DWI	boolean	bit	yes
89	CONTINUED_TO_USE	string	varchar(3)	yes
90	EMOTIONAL_PROBLEMS	boolean	bit	yes
91	TO_SOCIALIZE	boolean	bit	yes
92	REASONS_OTHER	boolean	bit	yes
93	SOBER_ACTIVITIES	string	varchar(max)	yes
94	WHEN_USE_ALCOHOL	string	varchar(max)	yes
95	SUBSTANCE_IN_LARGER_AMOUNTS	string	varchar(3)	yes
96	TREMORS	boolean	bit	yes
97	HEADACHES	boolean	bit	yes
98	PARANOIA	boolean	bit	yes
99	PROBLEMS_OTHER_COMMENT	string	varchar(32)	yes
100	MORE_THAN_FIVE_ATTEMPTES	string	varchar(3)	yes
101	TX_HISTORY	string	varchar(650)	yes
102	NOT_APPLICABLE	boolean	bit	yes
103	SUD_IMPACTED_YOU	string	varchar(3)	yes
104	SUD_IMPACT_TB	string	varchar(max)	yes