EMR_ENCOUNTERS_OCC_DETAILS · 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	EMPLOYMENT_STATUS	string	varchar(max)	yes
3	MEANS_OF_SUPPORT	string	varchar(max)	yes
4	SPECIAL_TRAINING	string	varchar(max)	yes
5	CURRENT_EMPLOYER	string	varchar(max)	yes
6	EMPLOYER_PHONE	string	varchar(max)	yes
7	EMPLOYER_ADDRESS	string	varchar(max)	yes
8	POSITION	string	varchar(max)	yes
9	POSITION_DATES	string	varchar(max)	yes
10	JOB_SATISFACTION	string	varchar(max)	yes
11	JOB_PERFORMANCE	string	varchar(max)	yes
12	FUTURE_ASPIRATIONS	string	varchar(max)	yes
13	PREVIOUS_EMPLOYMENT	string	varchar(max)	yes
14	OCC_DET_REVIEWED	boolean	bit	yes