EMR_ENCOUNTERS_NYSCRI_PERSONAL_INFORMATION · 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_OUTSIDE_TO	string	varchar(75)	yes
3	SIGNIFICANT_OTHER_SEEKING_TREATMENT_DESCRIBE	string	varchar(500)	yes
4	SPECIAL_NEEDS_MEDICAID_TRANSPORTATION	string	varchar(3)	yes
5	INDIV_LIVING_ADDRESS_1	string	varchar(55)	yes
6	REFERRED_OUTSIDE_AGENCY	string	varchar(3)	yes
7	INTAKE_AM_PM	string	varchar(10)	yes
8	REFERRED_OUTSIDE_REASON	string	varchar(max)	yes
9	INDIV_LIVING_STATE	string	varchar(2)	yes
10	INIDV_LIVING_ZIP	string	varchar(10)	yes
11	INTAKE_TIME	string	varchar(5)	yes
12	PHONE_NUMBER_CALLING_FROM	string	varchar(14)	yes
13	SPECIAL_NEEDS_LANGUATE_INTERPRETER	string	varchar(3)	yes
14	SPECIAL_NEEDS_LITERACY_SKILLS	string	varchar(3)	yes
15	WHY_SEEKING_SERVICE	string	varchar(max)	yes
16	INTAKE_DATE	datetime	datetime	yes
17	REASON_FOR_REFERRAL	string	varchar(max)	yes
18	SPECIAL_NEEDS_WHEEL_CHAIR	string	varchar(3)	yes
19	PROGRAM_STATUS_CODE	string	varchar(40)	yes
20	INDIV_LIVING_COUNTY	string	varchar(35)	yes
21	INDIV_MAILING_APT	string	varchar(5)	yes
22	INDIV_MAILING_COUNTY	string	varchar(35)	yes
23	OK_LEAVE_MESSAGE_1	string	varchar(3)	yes
24	SPECIAL_NEEDS_TDD_TTY_DEVICE	string	varchar(3)	yes
25	PROGRAM_ASSIGNED_INTAKE_SPECIFY	string	varchar(75)	yes
26	SPECIAL_NEEDS_REPORTD_YN	string	varchar(3)	yes
27	INDIVIDUAL_IS_HOMELESS	boolean	bit	yes
28	OK_LEAVE_MESSAGE_2	string	varchar(3)	yes
29	DANGEROUS_SITUATION	string	varchar(3)	yes
30	SPECIAL_NEEDS_SIGN_LANGUAGE_INTERPRETER	string	varchar(3)	yes
31	DETERMINATION_NOT_APPLICABLE	boolean	bit	yes
32	SPECIAL_NEEDS_ASSISTIVE_LISTENING_DEVICE	string	varchar(3)	yes
33	INDIV_LIVING_CITY	string	varchar(35)	yes
34	INDIV_MAILING_ADDRESS_1	string	varchar(55)	yes
35	INDIV_MAILING_STATE	string	varchar(2)	yes
36	PRIMARY_TELEPHONE	string	varchar(14)	yes
37	ASSIGNED_WORKER_NAME	string	varchar(50)	yes
38	INIDV_MAILING_ZIP	string	varchar(10)	yes
39	SECONDARY_TELEPHONE	string	varchar(14)	yes
40	SPECIAL_NEEDS_OTHER	string	varchar(50)	yes
41	INDIV_LIVING_APT	string	varchar(5)	yes
42	INDIV_MAILING_CITY	string	varchar(35)	yes
43	CALL_OR_WALK_IN	string	varchar(7)	yes
44	NAME_NUMBER_LEGAL_GUARDIAN	string	varchar(100)	yes
45	REFERRAL_SOURCE	string	varchar(5)	yes
46	OTHER_REFERRAL_SOURCE_NAME	string	varchar(65)	yes
47	SIGNIFICANT_OTHER_SEEKING_TREATMENT_	string	varchar(3)	yes
48	ACTIVE_CASE_CHILD_PROTECTIVE	string	varchar(3)	yes
49	TOTAL_NUMBER_CHILDREN	integer	int	yes
50	VETERAN_STATUS	string	varchar(3)	yes
51	CJ_CONSENT_DATE	datetime	datetime	yes
52	CJ_CONSENT_REVOKE_DATE	datetime	datetime	yes
53	PROVIDER_CLIENT_ID	string	varchar(12)	yes
54	MARITAL_STATUS	string	varchar(17)	yes
55	OTHER_PRIMARY_LANGUAGE	string	varchar(30)	yes
56	RACE	string	varchar(34)	yes
57	HISPANIC_ORIGIN	string	varchar(24)	yes
58	UNKNOWN_SEX	boolean	bit	yes
59	INIDV_RECEIVED_SERVICES_WHEN	string	varchar(100)	yes
60	INDIV_RECEIVED_SERVICES_HERE	string	varchar(3)	yes
61	PROVIDER_NUMBER	string	varchar(20)	yes
62	PRIMARY_LANGUAGE	string	varchar(13)	yes
63	PROGRAM_NUMBER	string	varchar(15)	yes
64	SPECIAL_PROJECT	string	varchar(100)	yes
65	SEX	string	varchar(1)	yes
66	LAST_NAME_CURRENT_2_LETTERS	string	varchar(2)	yes
67	TOTAL_NUMBER_CHILDREN_FOSTER_CARE	integer	int	yes
68	AGE	integer	int	yes
69	KNOWN_AS	string	varchar(50)	yes
70	MOTHER_FIRST_NAME	string	varchar(30)	yes
71	MOTHER_MAIDEN_NAME	string	varchar(30)	yes
72	OTHER_RACE	string	varchar(30)	yes
73	TOTAL_NUMBER_CHILDREN_LIVING_WITH_INDIV	integer	int	yes
74	LAST_NAME_BIRTH_2_LETTERS	string	varchar(2)	yes
75	PREFERRED_LANGUAGE	string	varchar(13)	yes
76	MILITARY_STATUS	string	varchar(46)	yes
77	OTHER_PREFERRED_LANGUAGE	string	varchar(30)	yes
78	RACE_COMMENTS	string	varchar(max)	yes
79	NYSID	string	varchar(11)	yes
80	LAST_4_SSNO	string	varchar(4)	yes
81	OMH3	boolean	bit	yes
82	OMH10	boolean	bit	yes
83	OMH11	boolean	bit	yes
84	PLACE_OF_RESIDENCE5	boolean	bit	yes
85	PLACE_OF_RESIDENCE7	boolean	bit	yes
86	PLACE_OF_RESIDENCE8	boolean	bit	yes
87	OMH4	boolean	bit	yes
88	PLACE_OF_RESIDENCE4	boolean	bit	yes
89	PLACE_OF_RESIDENCE10	boolean	bit	yes
90	OMH5	boolean	bit	yes
91	OMH8	boolean	bit	yes
92	OMH12	boolean	bit	yes
93	NON_RELATE	string	varchar(50)	yes
94	OMH7	boolean	bit	yes
95	OMH9	boolean	bit	yes
96	OMH13	boolean	bit	yes
97	OTHER_RESIDENCE	string	varchar(80)	yes
98	PLACE_OF_RESIDENCE2	boolean	bit	yes
99	SPOUSE	string	varchar(50)	yes
100	OMH6	boolean	bit	yes
101	PLACE_OF_RESIDENCE1	boolean	bit	yes
102	PLACE_OF_RESIDENCE6	boolean	bit	yes
103	ALONE	string	varchar(50)	yes
104	OMH1	boolean	bit	yes
105	PLACE_OF_RESIDENCE3	boolean	bit	yes
106	OMH2	boolean	bit	yes
107	PLACE_OF_RESIDENCE9	boolean	bit	yes
108	SELF_FAMILY_OTHER	string	varchar(34)	yes
109	PREVENTION_SERVICES	string	varchar(37)	yes
110	IF_YES_BY_WHOM	string	varchar(60)	yes
111	HEALTH_CARE_SERVICES	string	varchar(34)	yes
112	EMP_ED_SPECIAL_SERVICES	string	varchar(48)	yes
113	OTHER_SOURCE	boolean	bit	yes
114	IF_YES_EXPLAIN	string	varchar(max)	yes
115	CRIMINAL_JUSTICE_SERVICES	string	varchar(39)	yes
116	SOCIAL_SERVICES	string	varchar(75)	yes
117	OTHER_SOURCE_DESC	string	varchar(max)	yes
118	MEETS_CRITERIA	string	varchar(3)	yes
119	MANDATED	string	varchar(3)	yes
120	CD_TREATMENT	string	varchar(50)	yes
121	TELEPHONE2	string	varchar(50)	yes
122	ADDRESS2	string	varchar(50)	yes
123	ZIP2	string	varchar(50)	yes
124	CITY1	string	varchar(50)	yes
125	LEG_GUARDI	string	varchar(50)	yes
126	EMERG_TELEPHONE	string	varchar(50)	yes
127	NAME1	string	varchar(50)	yes
128	YES_NO2	string	varchar(50)	yes
129	NOT_AVAIL2	string	varchar(50)	yes
130	CITY2	string	varchar(50)	yes
131	RELATIONSHIP	string	varchar(50)	yes
132	LEG_GUARDI2	string	varchar(50)	yes
133	NAME2	string	varchar(50)	yes
134	ADDRESS1	string	varchar(50)	yes
135	ADDRESS1B	string	varchar(50)	yes
136	ZIP1	string	varchar(50)	yes
137	TELEPHONE1	string	varchar(50)	yes
138	CASE_MANAG	string	varchar(50)	yes
139	NOT_AVAIL1	string	varchar(50)	yes
140	STATE2	string	varchar(50)	yes
141	YES_NO1	string	varchar(50)	yes
142	FAM_MEM2	string	varchar(50)	yes
143	FAM_MEMBER	string	varchar(50)	yes
144	ADDRESS2B	string	varchar(50)	yes
145	STATE1	string	varchar(50)	yes
146	EMERG_ADDRESS	string	varchar(50)	yes
147	TREATMENT_WHERE	string	varchar(50)	yes
148	EMERGENCY_NAME	string	varchar(50)	yes
149	ADDTNL	string	varchar(50)	yes
150	POLICYHOLDER_NAME	string	varchar(50)	yes
151	MENTAL_COPAY	string	varchar(50)	yes
152	ANNUAL_BENEFIT	string	varchar(50)	yes
153	INSURANCE_TELEPHONE	string	varchar(50)	yes
154	CHILD_HEALTH	string	varchar(50)	yes
155	YES_NO4	string	varchar(50)	yes
156	MEDICARE_NUM	string	varchar(50)	yes
157	CASEWORKER_NAME	string	varchar(50)	yes
158	MEDICAID_SPEND	string	varchar(50)	yes
159	POLICYHOLDER_COMP_NAME	string	varchar(50)	yes
160	NO_INS	string	varchar(50)	yes
161	BENEFIT_USED	string	varchar(50)	yes
162	POLICYHOLDER_EMPLOYER	string	varchar(50)	yes
163	GROUP_NUM	string	varchar(50)	yes
164	EFFECTIVE_DAT	string	varchar(50)	yes
165	MEDICAID_NUM	string	varchar(50)	yes
166	YES_NO5	string	varchar(50)	yes
167	POLICYHOLDER_ID	string	varchar(50)	yes
168	FAM_HEALTH_PLSU	string	varchar(50)	yes
169	DEDUCT_INFO	string	varchar(50)	yes
170	INDIVIDUAL	string	varchar(50)	yes
171	CD_COPAY	string	varchar(50)	yes
172	GROUP_SESS	string	varchar(50)	yes
173	YES_NO3	string	varchar(50)	yes
174	POLICYHOLDER_DOB	string	varchar(50)	yes
175	MEDICATION	string	varchar(50)	yes
176	YES_NO6	string	varchar(50)	yes
177	YES_NO7	string	varchar(50)	yes
178	MEDICAID_SEQUENCE	string	varchar(50)	yes
179	POLICY_NUM	string	varchar(50)	yes
180	PLAN_TYPE	string	varchar(50)	yes
181	AUTH_NUM	string	varchar(50)	yes
182	VISITS_AUTHOR	string	varchar(50)	yes
183	SEC_POLICY_NUM	string	varchar(50)	yes
184	OTHER	string	varchar(50)	yes
185	SAFETY	string	varchar(50)	yes
186	FAMILY	string	varchar(50)	yes
187	SUPPLEMENTAL	string	varchar(50)	yes
188	INCOME_MONTH	string	varchar(50)	yes
189	SEC_POLICYHOLDER_DOB	string	varchar(50)	yes
190	PERSON	string	varchar(50)	yes
191	SEC_COMP_NAME	string	varchar(50)	yes
192	VETERAN_CASH	string	varchar(50)	yes
193	SEC_INS_TELEPHONE	string	varchar(50)	yes
194	SEC_POLICYHOLDER_NAME	string	varchar(50)	yes
195	ALIMONY	string	varchar(50)	yes
196	SEC_POLICYHOLDER_ID	string	varchar(50)	yes
197	SOC_SECURITY	string	varchar(50)	yes
198	SOC_SECURITY_DISABIL	string	varchar(50)	yes
199	TEMP	string	varchar(50)	yes
200	OTHER_SOURCE_OF_INCOME	string	varchar(60)	yes
201	SEC_POLICYHOLDER_EMPLOYER	string	varchar(50)	yes
202	NUM_DEPEND	string	varchar(50)	yes
203	WAGES	string	varchar(50)	yes
204	SEC_GROUP_NUM	string	varchar(50)	yes
205	NOT_AVAIL_3RD	string	varchar(50)	yes
206	VETERAN	string	varchar(50)	yes
207	VETERAN_DISABILITY	string	varchar(50)	yes
208	NONE	string	varchar(50)	yes
209	IF_PREGNANT	string	varchar(3)	yes
210	SUBSTANCE_USER	string	varchar(3)	yes
211	CPS	string	varchar(3)	yes
212	INDIVIDUAL_COMPLETING_FORM	string	varchar(200)	yes