EMR_ENCOUNTERS_NYSCRI_ASSESSED_NEEDS · 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	ASSESSED_NEED_1	string	varchar(90)	yes
3	ASSESSED_NEED_1_A	boolean	bit	yes
4	ASSESSED_NEED_1_D	boolean	bit	yes
5	ASSESSED_NEED_1_ID	boolean	bit	yes
6	ASSESSED_NEED_1_NA	boolean	bit	yes
7	ASSESSED_NEED_1_R	boolean	bit	yes
8	ASSESSED_NEED_2	string	varchar(90)	yes
9	ASSESSED_NEED_2_A	boolean	bit	yes
10	ASSESSED_NEED_2_D	boolean	bit	yes
11	ASSESSED_NEED_2_ID	boolean	bit	yes
12	ASSESSED_NEED_2_NA	boolean	bit	yes
13	ASSESSED_NEED_2_R	boolean	bit	yes
14	ASSESSED_NEED_3	string	varchar(90)	yes
15	ASSESSED_NEED_3_A	boolean	bit	yes
16	ASSESSED_NEED_3_D	boolean	bit	yes
17	ASSESSED_NEED_3_ID	boolean	bit	yes
18	ASSESSED_NEED_3_NA	boolean	bit	yes
19	ASSESSED_NEED_3_R	boolean	bit	yes
20	ASSESSED_NEED_4	string	varchar(90)	yes
21	ASSESSED_NEED_4_A	boolean	bit	yes
22	ASSESSED_NEED_4_D	boolean	bit	yes
23	ASSESSED_NEED_4_ID	boolean	bit	yes
24	ASSESSED_NEED_4_NA	boolean	bit	yes
25	ASSESSED_NEED_4_R	boolean	bit	yes
26	ASSESSED_NEED_5	string	varchar(90)	yes
27	ASSESSED_NEED_5_A	boolean	bit	yes
28	ASSESSED_NEED_5_D	boolean	bit	yes
29	ASSESSED_NEED_5_ID	boolean	bit	yes
30	ASSESSED_NEED_5_NA	boolean	bit	yes
31	ASSESSED_NEED_5_R	boolean	bit	yes
32	ASSESSED_NEED_6	string	varchar(90)	yes
33	ASSESSED_NEED_6_A	boolean	bit	yes
34	ASSESSED_NEED_6_D	boolean	bit	yes
35	ASSESSED_NEED_6_ID	boolean	bit	yes
36	ASSESSED_NEED_6_NA	boolean	bit	yes
37	ASSESSED_NEED_6_R	boolean	bit	yes
38	ASSESSED_NEED_7	string	varchar(90)	yes
39	ASSESSED_NEED_7_A	boolean	bit	yes
40	ASSESSED_NEED_7_D	boolean	bit	yes
41	ASSESSED_NEED_7_ID	boolean	bit	yes
42	ASSESSED_NEED_7_NA	boolean	bit	yes
43	ASSESSED_NEED_7_R	boolean	bit	yes
44	ASSESSED_NEED_8	string	varchar(90)	yes
45	ASSESSED_NEED_8_A	boolean	bit	yes
46	ASSESSED_NEED_8_D	boolean	bit	yes
47	ASSESSED_NEED_8_IFD	boolean	bit	yes
48	ASSESSED_NEED_8_NA	boolean	bit	yes
49	ASSESSED_NEED_8_R	boolean	bit	yes
50	ASSESSED_NEED_9	string	varchar(90)	yes
51	ASSESSED_NEED_9_A	boolean	bit	yes
52	ASSESSED_NEED_9_D	boolean	bit	yes
53	ASSESSED_NEED_9_IFD	boolean	bit	yes
54	ASSESSED_NEED_9_NA	boolean	bit	yes
55	ASSESSED_NEED_9_R	boolean	bit	yes
56	INDIVIDUAL_DECLINED_1	string	varchar(max)	yes
57	INDIVIDUAL_DECLINED_2	string	varchar(max)	yes
58	INDIVIDUAL_DECLINED_3	string	varchar(max)	yes
59	INDIVIDUAL_DECLINED_4	string	varchar(max)	yes
60	INDIVIDUAL_DECLINED_5	string	varchar(max)	yes
61	INDIVIDUAL_DECLINED_6	string	varchar(max)	yes
62	INDIVIDUAL_DECLINED_7	string	varchar(max)	yes
63	INDIVIDUAL_DECLINED_8	string	varchar(max)	yes
64	NONE	boolean	bit	yes
65	SERVICE_PREFERENCE	string	varchar(max)	yes
66	NONE_INDICATED	boolean	bit	yes
67	PSYCHIATRIC	boolean	bit	yes
68	PSYCHOLOGICAL	boolean	bit	yes
69	NEUROLOGICAL	boolean	bit	yes
70	MEDICAL	boolean	bit	yes
71	EDUCATIONAL	boolean	bit	yes
72	EMPLOYMENT	boolean	bit	yes
73	VISUAL	boolean	bit	yes
74	AUDITORY	boolean	bit	yes
75	NUTRITIONAL	boolean	bit	yes
76	EVALUATIONS_OTHER	boolean	bit	yes
77	EVALUATIONS_OTHER_TXT	string	varchar(30)	yes
78	INDIVIDUAL_SERVED	string	varchar(max)	yes
79	CONTINUE_ASSESSMENT	boolean	bit	yes
80	ADMIT	boolean	bit	yes
81	NOT_NOT_ADMIT	boolean	bit	yes
82	INDIVIDUAL_DECLINED_SERVICES	boolean	bit	yes
83	DIPOSITION_OTHER	boolean	bit	yes
84	ADMIT_NOTES	string	varchar(max)	yes
85	DESCRIBE_IAP	string	varchar(max)	yes
86	DO_NOT_ADMIT_REFERRAL	string	varchar(max)	yes
87	INDIVIDUAL_DECLINED_DETAILS	string	varchar(max)	yes
88	DISPOSITION_OTHER_DETAILS	string	varchar(max)	yes
89	LEVEL_OF_CARE	string	varchar(max)	yes
90	NO_CHANGE	boolean	bit	yes
91	AOD_ASSESSMENT	string	varchar(3)	yes
92	INDIVIDUAL_SERVED_RESPONSE_TO_RECOMM	string	varchar(max)	yes
93	NO_ADDITIONAL_RECOMMENDATIONS_CLINICALLY_INDICATED	boolean	bit	yes
94	OTHER_FURTHER_EVAL_SPECIFY	string	varchar(50)	yes
95	SERVICE_PREFERENCES	string	varchar(max)	yes
96	VOCATIONAL	string	varchar(3)	yes
97	NO_ADDITIONAL_RECOMMANDATIONS	boolean	bit	yes
98	CLINICAL_RATIONALE	string	varchar(max)	yes
99	ASSESSED_NEED_1_FG	boolean	bit	yes
100	ASSESSED_NEED_2_FG	boolean	bit	yes
101	ASSESSED_NEED_3_FG	boolean	bit	yes
102	ASSESSED_NEED_4_FG	boolean	bit	yes
103	ASSESSED_NEED_5_FG	boolean	bit	yes
104	ASSESSED_NEED_6_FG	boolean	bit	yes
105	NINE	string	varchar(max)	yes