EMPLOYEE

EMPLOYEE Table Schema

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

EMPLOYEE Variable	Source Variable	Note
employee_id	N/A	(Auto-generated by a computer program)
hired_datetime	hiredt
termination_datetime	termdt
retired_datetime	effdtdt	Use the date value if only work_state equals to "Retire"
retirement_eligibility_flag	Elig	The source variable originated from the Retirement_Eligibility table