EMR_ENCOUNTERS_NYSCRI_PSYCHOPHARMACOLOGY · 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	ATTAINMENT_OF_HIGHER_LEVEL	boolean	bit	yes
3	ATTAINMENT_OF_HIGHER_LEVEL_DESC	string	varchar(4000)	yes
4	COA_PROGRAM	string	varchar(25)	yes
5	IAP_1	boolean	bit	yes
6	IAP_1_A	string	varchar(1)	yes
7	IAP_1_B	string	varchar(1)	yes
8	IAP_1_C	string	varchar(1)	yes
9	IAP_1_D	string	varchar(1)	yes
10	IAP_1_DESC	string	varchar(100)	yes
11	IAP_1_F	string	varchar(1)	yes
12	IAP_2	boolean	bit	yes
13	IAP_2_A	string	varchar(1)	yes
14	IAP_2_B	string	varchar(1)	yes
15	IAP_2_C	string	varchar(1)	yes
16	IAP_2_D	string	varchar(1)	yes
17	IAP_2_DESC	string	varchar(100)	yes
18	IAP_2_E	string	varchar(1)	yes
19	IAP_2_F	string	varchar(1)	yes
20	IAP_3	boolean	bit	yes
21	IAP_3_A	string	varchar(1)	yes
22	IAP_3_B	string	varchar(1)	yes
23	IAP_3_C	string	varchar(1)	yes
24	IAP_3_D	string	varchar(1)	yes
25	IAP_3_DESC	string	varchar(100)	yes
26	IAP_3_E	string	varchar(1)	yes
27	IAP_3_F	string	varchar(1)	yes
28	IAP_4	boolean	bit	yes
29	IAP_4_A	string	varchar(1)	yes
30	IAP_4_B	string	varchar(1)	yes
31	IAP_4_C	string	varchar(1)	yes
32	IAP_4_D	string	varchar(1)	yes
33	IAP_4_DESC	string	varchar(100)	yes
34	IAP_4_E	string	varchar(1)	yes
35	IAP_4_F	string	varchar(1)	yes
36	IAP_ATT_DATE_1	datetime	datetime	yes
37	IAP_ATT_DATE_2	datetime	datetime	yes
38	IAP_ATT_DATE_3	datetime	datetime	yes
39	IAP_ATT_DATE_4	datetime	datetime	yes
40	IAP_DATED_1	datetime	datetime	yes
41	IAP_DATED_2	datetime	datetime	yes
42	IAP_DATED_3	datetime	datetime	yes
43	IAP_DATED_4	datetime	datetime	yes
44	IAP_DISC_DATE_1	datetime	datetime	yes
45	IAP_DISC_DATE_2	datetime	datetime	yes
46	IAP_DISC_DATE_3	datetime	datetime	yes
47	IAP_DISC_DATE_4	datetime	datetime	yes
48	IAP_GOAL_1	string	varchar(35)	yes
49	IAP_GOAL_2	string	varchar(35)	yes
50	IAP_GOAL_3	string	varchar(35)	yes
51	IAP_GOAL_4	string	varchar(35)	yes
52	IAP_I_E	string	varchar(1)	yes
53	IAP_NO_CHANGE	boolean	bit	yes
54	IAP_PAN_1	integer	int	yes
55	IAP_PAN_2	integer	int	yes
56	IAP_PAN_3	integer	int	yes
57	IAP_PAN_4	integer	int	yes
58	IAP_SUMMARY_1	string	varchar(4000)	yes
59	IAP_SUMMARY_2	string	varchar(4000)	yes
60	IAP_SUMMARY_3	string	varchar(4000)	yes
61	IAP_SUMMARY_4	string	varchar(4000)	yes
62	INDIV_HAS_PARTICIPATED	string	varchar(3)	yes
63	INDIV_PARTICIPATED_PROVIDE_REASON	string	varchar(4000)	yes
64	NEXT_REVIEW_DUE_BY	datetime	datetime	yes
65	OBJ_1_A_BIT	boolean	bit	yes
66	OBJ_1_B	boolean	bit	yes
67	OBJ_1_C	boolean	bit	yes
68	OBJ_1_D	boolean	bit	yes
69	OBJ_1_E	boolean	bit	yes
70	OBJ_1_F	boolean	bit	yes
71	OBJ_2_A	boolean	bit	yes
72	OBJ_2_B	boolean	bit	yes
73	OBJ_2_C	boolean	bit	yes
74	OBJ_2_D	boolean	bit	yes
75	OBJ_2_E	boolean	bit	yes
76	OBJ_2_F	boolean	bit	yes
77	OBJ_3_A	boolean	bit	yes
78	OBJ_3_B	boolean	bit	yes
79	OBJ_3_C	boolean	bit	yes
80	OBJ_3_D	boolean	bit	yes
81	OBJ_3_E	boolean	bit	yes
82	OBJ_3_F	boolean	bit	yes
83	OBJ_4_A	boolean	bit	yes
84	OBJ_4_B	boolean	bit	yes
85	OBJ_4_C	boolean	bit	yes
86	OBJ_4_D	boolean	bit	yes
87	OBJ_4_E	boolean	bit	yes
88	OBJ_4_F	boolean	bit	yes
89	OTHER_PARTICIPATED_LIST_NAMES	string	varchar(4000)	yes
90	OTHER_PARTICIPATED_YN	string	varchar(3)	yes
91	OTHER_TRANSITION	string	varchar(4000)	yes
92	OTHER_TRANSITIONS	boolean	bit	yes
93	REDUCTION_IN_SYMPTOMS	boolean	bit	yes
94	REDUCTION_IN_SYMPTOMS_DESC_	string	varchar(4000)	yes
95	REVIEW_REVISION	string	varchar(10)	yes
96	REVIEW_REVISION_DATE	datetime	datetime	yes
97	TREATMENT_IS_NO_LONGER_NECESSARY	boolean	bit	yes
98	TREATMENT_IS_NO_LONGER_NECESSARY_DESC	string	varchar(4000)	yes
99	COORDINATION	boolean	bit	yes
100	DATED_1	datetime	datetime	yes
101	DATED_2	datetime	datetime	yes
102	DATED_3	datetime	datetime	yes
103	DATED_4	datetime	datetime	yes
104	DESCRIPTION_OF_OUTSIDE_SERVICE	string	varchar(4000)	yes
105	DESIRED_OUTCOME	string	varchar(4000)	yes
106	DURATION_1	string	varchar(10)	yes
107	DURATION_2	string	varchar(10)	yes
108	DURATION_3	string	varchar(10)	yes
109	DURATION_4	string	varchar(10)	yes
110	DURATION_5	string	varchar(10)	yes
111	DURATION_6	string	varchar(10)	yes
112	EXPALINED_RATIONALE	string	varchar(3)	yes
113	FORM_1	string	varchar(15)	yes
114	FORM_2	string	varchar(15)	yes
115	FORM_3	string	varchar(15)	yes
116	FORM_4	string	varchar(15)	yes
117	FORM_OTHER_1	string	varchar(40)	yes
118	FORM_OTHER_2	string	varchar(40)	yes
119	FORM_OTHER_3	string	varchar(40)	yes
120	FORM_OTHER_4	string	varchar(40)	yes
121	FREQ_1	string	varchar(10)	yes
122	FREQ_2	string	varchar(10)	yes
123	FREQ_3	string	varchar(10)	yes
124	FREQ_4	string	varchar(10)	yes
125	FREQ_5	string	varchar(10)	yes
126	GOAL_1	boolean	bit	yes
127	GOAL_2	boolean	bit	yes
128	GOAL_3	boolean	bit	yes
129	GOAL_4	boolean	bit	yes
130	GOAL_4_DESC	string	varchar(100)	yes
131	IAP_REVIEW_DATED	datetime	datetime	yes
132	INDIV_REFUSED_ANY_PART	string	varchar(4000)	yes
133	INDIVIDUAL_STRENGTH	string	varchar(4000)	yes
134	INJECTIONS	boolean	bit	yes
135	MEDICATION_EDUCATION	boolean	bit	yes
136	MEDICATION_MANAGEMENT	boolean	bit	yes
137	NEUROLOGICAL_CONSULT	boolean	bit	yes
138	NEUROPSYCH_TESTING	boolean	bit	yes
139	NUTRITIONAL_DIETICIAN	boolean	bit	yes
140	OBJ_1	string	varchar(1)	yes
141	OBJ_2	string	varchar(1)	yes
142	OBJ_3	string	varchar(1)	yes
143	OBJ_4	string	varchar(1)	yes
144	OBJ_OTHER_1	string	varchar(100)	yes
145	OBJ_OTHER_2	string	varchar(100)	yes
146	OBJ_OTHER_3	string	varchar(100)	yes
147	OBJ_OTHER_4	string	varchar(100)	yes
148	OTEHR_PROVIDER_2	string	varchar(20)	yes
149	OTHER_DURATION_1	string	varchar(20)	yes
150	OTHER_DURATION_2	string	varchar(20)	yes
151	OTHER_DURATION_3	string	varchar(20)	yes
152	OTHER_DURATION_4	string	varchar(20)	yes
153	OTHER_DURATION_5	string	varchar(20)	yes
154	OTHER_DURATION_6	string	varchar(20)	yes
155	OTHER_FREQ_1	string	varchar(20)	yes
156	OTHER_FREQ_2	string	varchar(20)	yes
157	OTHER_FREQ_3	string	varchar(20)	yes
158	OTHER_FREQ_4	string	varchar(20)	yes
159	OTHER_FREQ_5	string	varchar(20)	yes
160	OTHER_FREQ_6	string	varchar(20)	yes
161	OTHER_PART_NO	string	varchar(5)	yes
162	OTHER_PROVIDER_1	string	varchar(20)	yes
163	OTHER_PROVIDER_3	string	varchar(20)	yes
164	OTHER_PROVIDER_4	string	varchar(20)	yes
165	OTHER_PROVIDER_5	string	varchar(20)	yes
166	OTHER_THERAPEUTIC	boolean	bit	yes
167	PAN_1	string	varchar(5)	yes
168	PAN_2	string	varchar(5)	yes
169	PAN_3	string	varchar(5)	yes
170	PAN_4	string	varchar(5)	yes
171	PHYSICAL_ASSESSMENT	boolean	bit	yes
172	PHYSICAL_ASSESSMENT_2	boolean	bit	yes
173	PROVIDER_1	string	varchar(5)	yes
174	PROVIDER_2	string	varchar(5)	yes
175	PROVIDER_3	string	varchar(5)	yes
176	PROVIDER_4	string	varchar(5)	yes
177	PROVIDER_5	string	varchar(5)	yes
178	PROVIDER_6	string	varchar(5)	yes
179	PSYCHOLOGICAL_TESTING___	boolean	bit	yes
180	REFERRA_OTHER_BIT	boolean	bit	yes
181	REFERRAL_NONE_REQUIRED	boolean	bit	yes
182	REFERRAL_OTHER	string	varchar(100)	yes
183	SUBSTANCE_ABUSE_ASSESSMENT	boolean	bit	yes