EMR_ENCOUNTERS_INITIAL_TREATMENT_PLAN_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	REFERRED	boolean	bit	yes
3	WHERE_REFERRED	string	varchar(20)	yes
4	REFUSED_REF	string	varchar(3)	yes
5	CHEMICAL_DEFER	string	varchar(20)	yes
6	CHEMICAL_DESCRIPTION	string	varchar(max)	yes
7	PHYSICAL_DEFER	string	varchar(20)	yes
8	PHYSICAL_DESCRIPTION	string	varchar(max)	yes
9	MENTAL_DEFER	string	varchar(20)	yes
10	MENTAL_DESCRIPTION	string	varchar(max)	yes
11	FAMILY_DEFER	string	varchar(20)	yes
12	FAMILY_DESCRIPTION	string	varchar(max)	yes
13	SOCIAL_DEFER	string	varchar(20)	yes
14	SOCIAL_DESCRIPTION	string	varchar(max)	yes
15	EDUCATION_DEFER	string	varchar(20)	yes
16	EDUCATION_DESCRIPTION	string	varchar(max)	yes
17	LEGAL_DEFER	string	varchar(20)	yes
18	LEGAL_DESCRIPTION	string	varchar(max)	yes
19	GAMBLING_DEFER	string	varchar(20)	yes
20	GAMBLING_DESCRIPTION	string	varchar(max)	yes
21	CHEMICAL_GOAL	string	varchar(150)	yes
22	CHEMICAL_NA	boolean	bit	yes
23	CHEMICAL_DEFERRED	boolean	bit	yes
24	GOAL_OTHER	string	varchar(100)	yes
25	CHEMICAL_OBJECTIVE	string	varchar(150)	yes
26	CHEMICAL_OBJECTIVE_OTHERS	string	varchar(100)	yes
27	CHEMICAL_TARGET	datetime	datetime	yes
28	INTEGRATED_ACTIVITIES	string	varchar(140)	yes
29	CHEMICAL_THERAPIST	string	varchar(140)	yes
30	CHEMICAL_GOAL_OTHER	string	varchar(100)	yes
31	CHEMICAL_OBJECTIVE_1	string	varchar(140)	yes
32	CHEMICAL_ACTIVITIES	string	varchar(140)	yes
33	CHEMICAL_THERAPIST_1	string	varchar(140)	yes
34	CHEMICAL_ACTIVITIES_1	string	varchar(100)	yes
35	CHEMICAL_OBJECTIVE_OTHER_1	string	varchar(100)	yes
36	PHYSICAL_GOAL_1	string	varchar(140)	yes
37	PHYSICAL_OBJECTIVE_1	string	varchar(140)	yes
38	PHYSICAL_OBJECTIVE_2	string	varchar(140)	yes
39	PHYSICAL_ACTIVITIES_1	string	varchar(140)	yes
40	PHYSICAL_ACTIVITIES_2	string	varchar(140)	yes
41	PHYSICAL_THERAPIST_1	string	varchar(140)	yes
42	PHYSICAL_THERAPIST_2	string	varchar(140)	yes
43	PHYSICAL_DATE_1	datetime	datetime	yes
44	PHYSICAL_DATE_2	datetime	datetime	yes
45	PHYISCAL_GOAL_OTHER	string	varchar(100)	yes
46	PHYSICAL_OBJECTIVE_OTHER_1	string	varchar(100)	yes
47	PHYSICAL_OBJECTIVE_OTHER_2	string	varchar(100)	yes
48	PHYSICAL_ACTIVITIES_OTHER_1	string	varchar(100)	yes
49	PHYSICAL_ACTIVITIES_OTHER_2	string	varchar(100)	yes
50	MENTAL_GOAL	string	varchar(140)	yes
51	MENTAL_OBJECTIVE_1	string	varchar(140)	yes
52	MENTAL_OBJECTIVE_2	string	varchar(140)	yes
53	MENTAL_ACTIVITIES_1	string	varchar(140)	yes
54	MENTAL_ACTIVITIES_2	string	varchar(140)	yes
55	MENTAL_THERAPIEST_1	string	varchar(140)	yes
56	MENTAL_THERAPIEST_2	string	varchar(140)	yes
57	MENTAL_GOAL_OTHER	string	varchar(100)	yes
58	MENTAL_OBJECTIVE_OTHER_1	string	varchar(100)	yes
59	MENTAL_OBJECTIVE_OTHER_2	string	varchar(100)	yes
60	MENTAL_ACTIVITIES_OTHER_1	string	varchar(100)	yes
61	MENTAL_ACTIVITIES_OTHER_2	string	varchar(100)	yes
62	MENTAL_DATE_1	datetime	datetime	yes
63	MENTAL_DATE_2	datetime	datetime	yes
64	FAMILY_GOAL	string	varchar(140)	yes
65	FAMILY_OBJECTIVE_1	string	varchar(140)	yes
66	FAMILY_OBJECTIVE_2	string	varchar(140)	yes
67	FAMILY_ACTIVITY_1	string	varchar(140)	yes
68	FAMILY_ACTIVITY_2	string	varchar(140)	yes
69	FAMILY_THERAPIST_1	string	varchar(140)	yes
70	FAMILY_THERAPIST_2	string	varchar(140)	yes
71	FAMILY_DATE_1	datetime	datetime	yes
72	FAMILY_DATE_2	datetime	datetime	yes
73	FAMILY_GOAL_OTHER	string	varchar(100)	yes
74	FAMILY_OBJECTIVE_OTHER_1	string	varchar(100)	yes
75	FAMILY_OBJECTIVE_OTHER_2	string	varchar(100)	yes
76	FAMILY_ACTIVITY_OTHER_1	string	varchar(100)	yes
77	FAMILY_ACTIVITY_OTHER_2	string	varchar(100)	yes
78	USE_TOBACCO	string	varchar(3)	yes
79	SOCIAL_GOAL	string	varchar(140)	yes
80	SOCIAL_OBJECTIVE_1	string	varchar(140)	yes
81	SOCIAL_OBJECTIVE_2	string	varchar(140)	yes
82	SOCIAL_ACTIVITY_1	string	varchar(140)	yes
83	SOCIAL_ACTIVITY_2	string	varchar(140)	yes
84	SOCIAL_THERAPIST_1	string	varchar(140)	yes
85	SOCIAL_THERAPIST_2	string	varchar(140)	yes
86	SOCIAL_DATE_1	datetime	datetime	yes
87	SOCIAL_DATE_2	datetime	datetime	yes
88	SOCIAL_GOAL_OTHER	string	varchar(100)	yes
89	SOCIAL_OBJECTIVE_OTHER_1	string	varchar(100)	yes
90	SOCIAL_OBJECTIVE_OTHER_2	string	varchar(100)	yes
91	SOCIAL_ACTIVITY_OTHER_1	string	varchar(100)	yes
92	SOCIAL_ACTIVITY_OTHER_2	string	varchar(100)	yes
93	CHEMICAL_DATE_1	datetime	datetime	yes
94	EDUCATIONAL_GOAL	string	varchar(140)	yes
95	EDUCATIONAL_OBJECTIVE_1	string	varchar(140)	yes
96	EDUCATIONAL_OBJECTIVE_2	string	varchar(140)	yes
97	EDUCATIONAL_ACTIVITY_1	string	varchar(140)	yes
98	EDUCATIONAL_ACTIVITY_2	string	varchar(140)	yes
99	EDUCATIONAL_DATE_1	datetime	datetime	yes
100	EDUCATIONAL_DATE_2	datetime	datetime	yes
101	EDUCATIONAL_THERAPIST_1	string	varchar(100)	yes
102	EDUCATIONAL_THERAPIST_2	string	varchar(100)	yes
103	EDUCATIONAL_GOAL_OTHER	string	varchar(100)	yes
104	EDUCATIONAL_OBJECTIVE_OTHER_1	string	varchar(100)	yes
105	EDUCATIONAL_OBJECTIVE_OTHER_2	string	varchar(100)	yes
106	EDUCATIONAL_ACTIVITY_OTHER_1	string	varchar(100)	yes
107	EDUCATIONAL_ACTIVITY_OTHER_2	string	varchar(100)	yes
108	LEGAL_GOAL	string	varchar(140)	yes
109	LEGAL_OBJECTIVE_1	string	varchar(140)	yes
110	LEGAL_OBJECTIVE_2	string	varchar(140)	yes
111	LEGAL_ACTIVITY_1	string	varchar(140)	yes
112	LEGAL_ACTIVITY_2	string	varchar(140)	yes
113	LEGAL_THERAPY_1	string	varchar(100)	yes
114	LEGAL_THERAPY_2	string	varchar(100)	yes
115	LEGAL_DATE_1	datetime	datetime	yes
116	LEGAL_DATE_2	datetime	datetime	yes
117	LEGAL_GOAL_OTHER	string	varchar(100)	yes
118	LEGAL_OBJECTIVE_OTHER_1	string	varchar(100)	yes
119	LEGAL_OBJECTIVE_OTHER_2	string	varchar(100)	yes
120	LEGAL_ACTIVITY_OTHER_1	string	varchar(100)	yes
121	LEGAL_ACTIVITY_OTHER_2	string	varchar(100)	yes
122	GAMBLING_GOAL	string	varchar(140)	yes
123	GAMBLING_OBJECTIVE_1	string	varchar(140)	yes
124	GAMBLING_OBJECTIVE_2	string	varchar(140)	yes
125	GAMBLING_ACTIVITY_1	string	varchar(140)	yes
126	GAMBLING_ACTIVITY_2	string	varchar(140)	yes
127	GAMBLING_DATE_1	datetime	datetime	yes
128	GAMBLING_DATE_2	datetime	datetime	yes
129	GAMBLING_THERAPIST_1	string	varchar(100)	yes
130	GAMBLING_THERAPIST_2	string	varchar(100)	yes
131	GAMBLING_OBJECTIVE_OTHER_1	string	varchar(100)	yes
132	GAMBLING_OBJECTIVE_OTHER_2	string	varchar(100)	yes
133	GAMBLING_ACTIVITY_OTHER_1	string	varchar(100)	yes
134	GAMBLING_ACTIVITY_OTHER_2	string	varchar(100)	yes
135	GAMBLING_GOAL_OTHER	string	varchar(100)	yes
136	OTHER_DEFER	string	varchar(30)	yes
137	OTHER_GOAL	string	varchar(100)	yes
138	OTHER_OBJECTIVE_1	string	varchar(100)	yes
139	OTHER_OBJECTIVE_2	string	varchar(100)	yes
140	OTHER_ACTIVITY_1	string	varchar(100)	yes
141	OTHER_ACTIVITY_2	string	varchar(100)	yes
142	OTHER_DATE_1	datetime	datetime	yes
143	OTHER_DATE_2	datetime	datetime	yes
144	OTHER_THERAPIST_1	string	varchar(50)	yes
145	OTHER_THERAPIST_2	string	varchar(50)	yes
146	OTHER_DESCRIPTION	string	varchar(max)	yes
147	ADMISSION_DATE	datetime	datetime	yes
148	ITP_4TH_REVIEW	string	varchar(25)	yes
149	ADDITIONAL_SERVICES	string	varchar(max)	yes
150	DATE_OF_REFERRAL	datetime	datetime	yes
151	RESULT_OF_REFERRAL	string	varchar(max)	yes