EMR_ENCOUNTERS_PSYCHOSOCIAL_HISTORY_05 · 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	CHEMICAL_GOAL	string	varchar(100)	yes
3	CHEMCIAL_NA	boolean	bit	yes
4	CHEMICAL_DEFERRED	boolean	bit	yes
5	CHEMICAL_OBJECTIVE_1	string	varchar(100)	yes
6	CHEMICAL_OBJECTIVE_2	string	varchar(100)	yes
7	CHEMICAL_TARGET_DATE_1	datetime	datetime	yes
8	CHEMICAL_TARGET_DATE_2	datetime	datetime	yes
9	CHEMICAL_THERAPIST_1	string	varchar(40)	yes
10	CHEMICAL_THERAPIST_2	string	varchar(40)	yes
11	CHEMICAL_ACTIVITY_1	string	varchar(100)	yes
12	CHEMICAL_ACTIVITY_2	string	varchar(100)	yes
13	PHYSICAL_NA	boolean	bit	yes
14	PHYSICAL_DEFERRED	boolean	bit	yes
15	PHYSICAL_GOAL	string	varchar(100)	yes
16	PHYSICAL_OBJECTIVE_1	string	varchar(100)	yes
17	PHYSICAL_OBJECTIVE_2	string	varchar(100)	yes
18	PHYSICAL_TARGET_DATE_1	datetime	datetime	yes
19	PHYSICAL_TARGET_DATE_2	datetime	datetime	yes
20	PHYSICAL_ACTIVITY_1	string	varchar(100)	yes
21	PHYSICAL_ACTIVITY_2	string	varchar(100)	yes
22	PHYSICAL_THERAPIST_1	string	varchar(60)	yes
23	PHYSICAL_THERAPIST_2	string	varchar(60)	yes
24	MENTAL_NA	boolean	bit	yes
25	MENTAL_DEFERRED	boolean	bit	yes
26	FAMILY_NA	boolean	bit	yes
27	FAMILY_DEFERRED	boolean	bit	yes
28	SOCIAL_NA	boolean	bit	yes
29	SOCIAL_DEFERRED	boolean	bit	yes
30	EDUCATIONAL_NA	boolean	bit	yes
31	EDUCATION_DEFERRED	boolean	bit	yes
32	LEGAL_NA	boolean	bit	yes
33	LEGAL_DEFERRED	boolean	bit	yes
34	GAMBLING_NA	boolean	bit	yes
35	GAMBLING_DEFERRED	boolean	bit	yes
36	MENTAL_GOAL	string	varchar(100)	yes
37	MENTAL_OBJECTIVE_1	string	varchar(100)	yes
38	MENTAL_OBJECTIVE_2	string	varchar(100)	yes
39	MENTAL_TARGET_DATE_1	datetime	datetime	yes
40	MENTAL_TARGET_DATE_2	datetime	datetime	yes
41	MENTAL_THERAPIST_1	string	varchar(50)	yes
42	MENTAL_THERAPIST_2	string	varchar(50)	yes
43	MENTAL_ACITIVITY_1	string	varchar(100)	yes
44	MENTAL_ACITIVITY_2	string	varchar(100)	yes
45	GOAL_FAMILY	string	varchar(100)	yes
46	FAMILY_OBJECTIVE_1	string	varchar(100)	yes
47	FAMILY_OBJECTIVE_2	string	varchar(100)	yes
48	FAMILY_TARGET_DATE_1	datetime	datetime	yes
49	FAMILY_TARGET_DATE_2	datetime	datetime	yes
50	ACTIVITY_FAMILY_1	string	varchar(100)	yes
51	ACTIVITY_FAMILY_2	string	varchar(100)	yes
52	FAMILY_THERAPIST_1	string	varchar(50)	yes
53	FAMILY_THERAPIST_2	string	varchar(50)	yes
54	SOCIAL_GOAL	string	varchar(100)	yes
55	SOCIAL_OBJECTIVE_1	string	varchar(100)	yes
56	SOCIAL_OBJECTIVE_2	string	varchar(100)	yes
57	SOCIAL_TARGET_DATE_1	datetime	datetime	yes
58	SOCIAL_TARGET_DATE_2	datetime	datetime	yes
59	SOCIAL_ACTIVITY_1	string	varchar(100)	yes
60	SOCIAL_ACTIVITY_2	string	varchar(100)	yes
61	SOCIAL_THERAPIST_1	string	varchar(50)	yes
62	SOCIAL_THERAPIST_2	string	varchar(50)	yes
63	EDUCATION_GOAL	string	varchar(100)	yes
64	EDUCATION_OBJECTIVE_1	string	varchar(100)	yes
65	EDUCATION_OBJECTIVE_2	string	varchar(100)	yes
66	EDUCATIONAL_TARGET_DATE_1	datetime	datetime	yes
67	EDUCATIONAL_TARGET_DATE_2	datetime	datetime	yes
68	ACITIVITY_EDUCATION_1	string	varchar(100)	yes
69	ACITIVITY_EDUCATION_2	string	varchar(100)	yes
70	EDUCATION_THERAPIST_1	string	varchar(50)	yes
71	EDUCATION_THERAPIST_2	string	varchar(50)	yes
72	LEGAL_GOAL	string	varchar(75)	yes
73	LEGAL_OBJECTIVE_1	string	varchar(75)	yes
74	LEGAL_OBJECTIVE_2	string	varchar(75)	yes
75	LEGAL_TARGET_DATE_1	datetime	datetime	yes
76	LEGAL_TARGET_DATE_2	datetime	datetime	yes
77	LEGAL_ACTIVITY_1	string	varchar(75)	yes
78	LEGAL_ACTIVITY_2	string	varchar(75)	yes
79	LEGAL_THERAPIST_1	string	varchar(50)	yes
80	LEGAL_THERAPIST_2	string	varchar(50)	yes
81	GAMBLING_GOAL	string	varchar(75)	yes
82	GAMBLING_OBJECTIVE_1	string	varchar(75)	yes
83	GAMBLING_OBJECTIVE_2	string	varchar(75)	yes
84	GAMBLING_ACTIVITY_1	string	varchar(75)	yes
85	GAMBLING_ACTIVITY_2	string	varchar(75)	yes
86	GAMBLING_THERAPIST_1	string	varchar(75)	yes
87	GAMBLING_THERAPIST_2	string	varchar(75)	yes
88	GAMBLING_TARGET_DATE_1	datetime	datetime	yes
89	GAMBLING_TARGET_DATE_2	datetime	datetime	yes
90	IC	string	varchar(30)	yes
91	GROUP_1	string	varchar(20)	yes
92	GROUP_2	string	varchar(20)	yes
93	GROUP_3	string	varchar(20)	yes
94	GROUP_4	string	varchar(20)	yes
95	FAMILY	string	varchar(30)	yes
96	PSYCH_MGT	string	varchar(30)	yes
97	OTHER_SERVICE	string	varchar(50)	yes
98	DRUG_SCREENING	string	varchar(30)	yes
99	LENGTH_OF_SESSION	string	varchar(15)	yes
100	PHONE	boolean	bit	yes
101	PSYCHIATRIC	string	varchar(40)	yes
102	PSYCHIATRIC_OTHER	boolean	bit	yes
103	NO_SHOW	boolean	bit	yes
104	CHEMICAL_ABUSE	boolean	bit	yes
105	PHY_HEALTH	boolean	bit	yes
106	MENTAL_HEALTH	boolean	bit	yes
107	EDU_VOC_EMP	boolean	bit	yes
108	SOCIAL_LEISURE	boolean	bit	yes
109	FAMILY_CHECK	boolean	bit	yes
110	LEGAL	boolean	bit	yes
111	GAMBLING	boolean	bit	yes
112	GOALS_OTHER_1	boolean	bit	yes
113	GOALS_OTHER_2	boolean	bit	yes
114	GOALS_OTHER_1_TXT	string	varchar(30)	yes
115	GOALS_OTHER_2_TXT	string	varchar(30)	yes