EMPLOYMENT_RECORD

EMPLOYMENT_RECORD Table Schema

The table below presents the data mappings for the EMPLOYMENT_RECORD table where the source variables refer to the column names in the base data set.

EMPLOYMENT_RECORD Variable	Source Variable	Note
employment_record_id	N/A	(Auto-generated by a computer program)
employee_id	eessno
hr_event_id	N/A	Foreign key to the HR_EVENT table
year_of_record	effdtdt	Extract the year
month_of_record	effdtdt	Extract the month
day_of_record	effdtdt	Extract the day
record_date	effdtdt
work_site_id	N/A	Foreign key to the WORK_SITE table
job_concept_id	--
work_state	--	(See "Work State Resolution" section)
employment_type_concept_id	--
job_source_value	jobtitle
job_source_concept_id	jobcode
employment_status_source_value	empstat_label	The source variable originated from the Empstats_Mapping table
employment_status_source_ concept_id	empstats
employment_type_source__value	emptype_label	The source variable originated from the Emptype_Mapping table
employment_type_source_concept_id	emptype
business_unit_source_value	buname
business_unit_source_concept_id	bucode
department_source_value	deptname
department_source_concept_id	deptcode
annual_salary	annual