EMR_ENCOUNTERS_INDIVIDUALIZED_TREATMENT_RECOVERY

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	VOCATIONAL_SUMMARY	string	varchar(max)	yes
3	VOCATIONAL_GOAL	string	varchar(max)	yes
4	SOCIAL_SUMMARY	string	varchar(max)	yes
5	SOCIAL_GOAL	string	varchar(max)	yes
6	FAMILY_SUMMARY	string	varchar(max)	yes
7	FAMILY_GOAL	string	varchar(max)	yes
8	LEGAL_SUMMARY	string	varchar(max)	yes
9	LEGAL_GOAL	string	varchar(max)	yes
10	GAMBLING_SUMMARY	string	varchar(max)	yes
11	GAMBLING_GOAL	string	varchar(max)	yes
12	INDIVIDUAL_1	string	varchar(50)	yes
13	GROUP_1	string	varchar(50)	yes
14	GROUP_2	string	varchar(50)	yes
15	GROUP_3	string	varchar(50)	yes
16	GROUP_4	string	varchar(50)	yes
17	OIP	string	varchar(50)	yes
18	NUMBER_PER_WEEK_INDIVIDUAL	string	varchar(5)	yes
19	NUMBER_PER_WEEK_GROUP_1	string	varchar(5)	yes
20	NUMBER_PER_WEEK_GROUP_2	string	varchar(5)	yes
21	NUMBER_PER_WEEK_GROUP_3	string	varchar(5)	yes
22	NUMBER_PER_WEEK_GROUP_4	string	varchar(5)	yes
23	NUMBER_PER_WEEK_IOP	string	varchar(5)	yes
24	CHEMICAL_SUMMARY	string	varchar(max)	yes
25	CHEMICAL_GOALS	string	varchar(max)	yes
26	PHYSICAL_SUMMARY	string	varchar(max)	yes
27	PHYSICAL_GOAL	string	varchar(max)	yes
28	MENTAL_SUMMARY	string	varchar(max)	yes
29	MENTAL_GOAL	string	varchar(max)	yes
30	NEXT_REVIEW_DATE	datetime	datetime	yes
31	INDIVIDUAL_THERAPIST	string	varchar(33)	yes
32	NEXT_REVIEW_PULL	datetime	datetime	yes
33	OTHER_SUMMARY	string	varchar(max)	yes
34	OTHER_GOAL	string	varchar(max)	yes
35	GROUP_NAME_1	string	varchar(50)	yes
36	GROUP_NAME_2	string	varchar(50)	yes
37	GROUP_NAME_3	string	varchar(50)	yes
38	GROUP_NAME_4	string	varchar(50)	yes
39	REVIEWING_INDIVIDUAL_1	string	varchar(50)	yes
40	REVIEWING_INDIVIDUAL_2	string	varchar(50)	yes
41	REVIEWING_INDIVIDUAL_3	string	varchar(50)	yes
42	REVIEWING_INDIVIDUAL_4	string	varchar(50)	yes
43	REVIEWING_INDIVIDUAL_5	string	varchar(50)	yes
44	REVIEWING_INDIVIDUAL_6	string	varchar(50)	yes
45	REVIEWING_INDIVIDUAL_7	string	varchar(50)	yes
46	REVIEWING_INDIVIDUAL_8	string	varchar(50)	yes
47	ATTESTS_PARTICIPATION	string	varchar(3)	yes
48	BRIEF_NARRATIVE	string	varchar(max)	yes
49	CONSULTED_GUARDIAN	string	varchar(3)	yes
50	AXIS1_1	string	varchar(50)	yes
51	AXIS1_2	string	varchar(50)	yes
52	NEW_OR_UPDATED_INFO	string	varchar(max)	yes