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