EMR_ENCOUNTERS_NYSCRI_VOC_EDU_EMPLOY · 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.

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	COMMENT_EDU	string	varchar(4000)	yes
3	COMMENT_EMPLOY	string	varchar(4000)	yes
4	COMMENT_VOC	string	varchar(4000)	yes
5	EDUCATIONAL	string	varchar(4000)	yes
6	EMPLOYMENT	string	varchar(4000)	yes
7	EMPLOYMENT_MONTH_1	integer	smallint	yes
8	EMPLOYMENT_MONTH_2	integer	smallint	yes
9	EMPLOYMENT_MONTH_3	integer	smallint	yes
10	EMPLOYMENT_MONTH_4	integer	smallint	yes
11	EMPLOYMENT_STATUS_2	string	varchar(175)	yes
12	EMPLOYMENT_YEAR_1	integer	smallint	yes
13	EMPLOYMENT_YEAR_3	integer	smallint	yes
14	EMPLOYMENT_YEAR_4	integer	smallint	yes
15	EMPLOYMENT_YEAR2	integer	smallint	yes
16	HIGHEST_GRADE_COMPLETED	string	varchar(32)	yes
17	NA_EMPLOYMENT_HISTORY	boolean	bit	yes
18	REASON_FOR_LEAVING_1	string	varchar(50)	yes
19	REASON_FOR_LEAVING_2	string	varchar(50)	yes
20	REASON_FOR_LEAVING_3	string	varchar(50)	yes
21	REASON_FOR_LEAVING_4	string	varchar(50)	yes
22	TYPE_OF_JOB_1	string	varchar(50)	yes
23	TYPE_OF_JOB_2	string	varchar(50)	yes
24	TYPE_OF_JOB_3	string	varchar(50)	yes
25	TYPE_OF_JOB_4	string	varchar(50)	yes
26	VOCATIONAL	string	varchar(4000)	yes
27	APPROXIMATE_LITERACY_LEVEL	string	varchar(4000)	yes