EMR_ENCOUNTERS_PSYCHOSOCIAL_HISTORY_01 · 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	ROUTE_3	string	varchar(10)	yes
3	ROUTE_4	string	varchar(10)	yes
4	ROUTE_5	string	varchar(10)	yes
5	ROUTE_6	string	varchar(10)	yes
6	ROUTE_7	string	varchar(10)	yes
7	ROUTE_8	string	varchar(10)	yes
8	ROUTE_9	string	varchar(10)	yes
9	FREQUENCY_1	string	varchar(25)	yes
10	FREQUENCY_2	string	varchar(25)	yes
11	FREQUENCY_4	string	varchar(25)	yes
12	FREQUENCY_5	string	varchar(25)	yes
13	FREQUENCY_6	string	varchar(25)	yes
14	FREQUENCY_7	string	varchar(25)	yes
15	FREQUENCY_8	string	varchar(25)	yes
16	FREQUENCY_9	string	varchar(25)	yes
17	AGE_OF_ONSET_1	string	varchar(5)	yes
18	AGE_OF_ONSET_2	string	varchar(5)	yes
19	AGE_OF_ONSET_3	string	varchar(5)	yes
20	AGE_OF_ONSET_4	string	varchar(5)	yes
21	AGE_OF_ONSET_5	string	varchar(5)	yes
22	AGE_OF_ONSET_6	string	varchar(5)	yes
23	AGE_OF_ONSET_7	string	varchar(5)	yes
24	AGE_OF_ONSET_8	string	varchar(5)	yes
25	AGE_OF_ONSET_9	string	varchar(5)	yes
26	CURRENT_USAGE	string	varchar(max)	yes
27	PAST_SUBSTANCE_TREATMENT	string	varchar(3)	yes
28	SUBSTANCE_TREATMENT_DESCRIBE	string	varchar(max)	yes
29	FAMILY_SUBSTANCE_ABUSE	string	varchar(3)	yes
30	RELATIVES	string	varchar(max)	yes
31	GENETIC	string	varchar(max)	yes
32	SUBSTANCE_USED	string	varchar(max)	yes
33	TREATED_UNTREATED	string	varchar(max)	yes
34	BLACKOUT_MEMORY_LOSS	boolean	bit	yes
35	MOOD_SWINGS	boolean	bit	yes
36	TEMPER_OUTBURSTS	boolean	bit	yes
37	HALLUCINATIONS	boolean	bit	yes
38	AGGRESSIVE_BEHAVIOR	boolean	bit	yes
39	ISOLATION	boolean	bit	yes
40	SLURRED_SPEECH	boolean	bit	yes
41	STAGGERING	boolean	bit	yes
42	SWEATING	boolean	bit	yes
43	NAUSEA_VOMITING	boolean	bit	yes
44	CRAMPS	boolean	bit	yes
45	TREMORS	boolean	bit	yes
46	WEIGHT_LOSS	boolean	bit	yes
47	TOLERANCE_CHANGE	boolean	bit	yes
48	OBSESSIVE_RUMINATION_ABOUT_DRUGS	boolean	bit	yes
49	COMPULSIVE_RITUAL_USAGE	boolean	bit	yes
50	CHANGES_IN_SEXUAL_PERFORMANCE	boolean	bit	yes
51	MARITAL_LOSS	boolean	bit	yes
52	ABSENT_LATENESS	boolean	bit	yes
53	JOB_LOSS	boolean	bit	yes
54	FINANCIAL_LOSS	boolean	bit	yes
55	HEALTH_PROBLEMS	boolean	bit	yes
56	LEGAL_PROBLEMS	boolean	bit	yes
57	CAR_ACCIDENTS	boolean	bit	yes
58	DWI	boolean	bit	yes
59	NEGLECT_OF_SCHOOL	boolean	bit	yes
60	SUSPENSION	boolean	bit	yes
61	PARENTAL_PROBLEMS	boolean	bit	yes
62	LOSS_OF_FRIENDS	boolean	bit	yes
63	DECREASE_IN_EXTRACURRICULAR	boolean	bit	yes
64	Q1	string	varchar(3)	yes
65	Q2	string	varchar(3)	yes
66	Q3A	string	varchar(3)	yes
67	Q3B	string	varchar(3)	yes
68	Q3C	string	varchar(3)	yes
69	Q4	string	varchar(3)	yes
70	Q5	string	varchar(3)	yes
71	Q6	string	varchar(3)	yes
72	Q7	string	varchar(3)	yes
73	Q8	string	varchar(3)	yes
74	INTAKE_THERAPIST_1	string	varchar(37)	yes
75	INTAKE_THERAPIST_2	string	varchar(37)	yes
76	SUBSTANCE_USED_3	string	varchar(30)	yes
77	FREQUENCY_3	string	varchar(25)	yes
78	INTAKE_DATE	datetime	datetime	yes
79	LENGTH_OF_SESSION	string	varchar(20)	yes
80	NEW	boolean	bit	yes
81	READMISSION	boolean	bit	yes
82	REFERRAL_SOURCE	string	varchar(60)	yes
83	MARITAL_STATUS	string	varchar(17)	yes
84	OCCUPATION	string	varchar(60)	yes
85	PATIENT_HAVE_CHILDERN	string	varchar(3)	yes
86	NUMBER_OF_CHILDREN	string	varchar(2)	yes
87	AGES_OF_CHILDERN	string	varchar(40)	yes
88	WHO_ACCOMPANIED_PATIENT	string	varchar(max)	yes
89	INVITED_ATTENDED_INTAKE	string	varchar(3)	yes
90	INVITED_ATTENDED_INTAKE_WHY_NO	string	varchar(max)	yes
91	HISTORY_PRESENTING_PROBLEM	string	varchar(max)	yes
92	HOUSING_ARRANGEMENTS	string	varchar(max)	yes
93	DAILY_LIVING_SKILLS	string	varchar(max)	yes
94	PERSONAL_PHYSICIAN	string	varchar(50)	yes
95	SIGNIFICANT_DIAGNOSIS	string	varchar(50)	yes
96	SIGNIFICANT_DIAGNOSIS_NA	boolean	bit	yes
97	PRESCRIBED_MEDICATION	string	varchar(3)	yes
98	LIST_OF_MEDICATIONS	string	varchar(max)	yes
99	LAST_PHYSICAL_EXAM	datetime	datetime	yes
100	USE_NICOTINE	string	varchar(3)	yes
101	HOW_MUCH_NICOTINE	string	varchar(30)	yes
102	YEAR_USING_NICOTINE	string	varchar(10)	yes
103	ADDITIONAL_MEDICAL_PROBLEMS	string	varchar(max)	yes
104	SUBSTANCE_USED_1	string	varchar(31)	yes
105	SUBSTANCE_USED_2	string	varchar(31)	yes
106	SUBSTANCE_USED_4	string	varchar(31)	yes
107	SUBSTANCE_USED_5	string	varchar(31)	yes
108	SUBSTANCE_USED_6	string	varchar(31)	yes
109	SUBSTANCE_USED_7	string	varchar(31)	yes
110	SUBSTANCE_USED_8	string	varchar(31)	yes
111	SUBSTANCE_USED_9	string	varchar(31)	yes
112	ROUTE_1	string	varchar(10)	yes
113	ROUTE_2	string	varchar(10)	yes
114	REINTAKE	boolean	bit	yes
115	LOCATION	string	varchar(10)	yes
116	LAST_PHYSICALS	string	varchar(20)	yes