EMPLOYEE - AmericanManufacturingCohort/HR-CDM-Data-Transformation GitHub Wiki

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

AMC Human Resources Common Data Model (HR-CDM) Data Transformation Pipeline (Last revision: 22 January 2019)

⚠️ **GitHub.com Fallback** ⚠️