Employee HCM - Dates

The Dates entity provides age, employment length, termination length, and benefits date for an employee.

Data Granularity

Provides one row per employee per selected time period.

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns
Age DATES_DAYS_EMPL_AGE Number No
Benefits Date DATES_EMPL_DATE_BENEFITS Date No
Current Year Hire Date DATES_EMPL_DATE_CURRENT_HIRED Date No
Current Year Started Date DATES_EMPL_DATE_CURRENT_STARTED Date No
Date Deceased DATES_EMPL_DATE_DECEASED Date No
Date Re-Hired DATES_EMPL_DATE_REHIRED Date No
Date Retired DATES_EMPL_DATE_RETIRED Date No
Date Review DATES_EMPL_DATE_REVIEW Date No
Date Started DATES_EMPL_DATE_STARTED Date No
Date Terminated DATES_EMPL_DATE_TERMINATED Date No
Days Employed DATES_DAYS_EMPLOYED Number No
Days Of Service DATES_YEARS_OF_SERVIC Number No
Employment Length (Days) If the employee's current status is terminated then The Employment Length is calculated based on the terminated date minus the hire date. If the employee's current status is not terminated, then the Employment Length is calculated as the current date minus the hire date. If there is a rehire event present for employee ever then the Employment Length is calculated as the current date minus the rehire date. Otherwise its value is 0 (zero). DATES_EMPL_EMPLOYMENT_LENGTH Number No
Employment Length (Days) DATES_EMPLOYMENT_LENGTH Number No
Frozen Benefit Date DATES_EMPL_DATE_FROZEN_BENEFIT Date No
Frozen Benefit Month DATES_EMPL_DATE_FROZEN_BENEFIT_MONTH String No
Hired Month DATES_EMPL_DATE_HIRED_MONTH String No
PEO Hired Month DATES_EMPL_DATE_PEO_HIRED_MONTH String No
Re-Hired Month DATES_EMPL_DATE_REHIRED_MONTH String No
Rehired Employment Length (Days) DATES_EMPLOYMENT_LENGTH_REHIRED Number No
Started Month DATES_EMPL_DATE_STARTED_MONTH String No
Terminated Month DATES_EMPL_DATE_TERMINATED_MONTH String No
Termination Length (Days) If the employee's current status is terminated then Termination Length is calculated based on the current date minus the termination date. Otherwise, it's value is 0 (zero). DATES_TERMINATION_LENGTH Number No
Years of Service (Days) If there is a rehire event present for employee and the employee's current state is terminated, then Years of Service is calculated as: [(latest termination date minus the rehire date) plus (the previous termination date minus the hire date)]. If there is a rehire event present for the employee and the employee's current state is not terminated, then Years of Service is calculated as: [(the current date minus the rehire date) plus (the termination date minus the hire date)]. If there is no rehire event present for the employee and the employee's current state is terminated then Years of Service calculated as the termination date minus the hire date. If there is no rehire event present for the employee and the employee's current state is not terminated, then Years of Service is calculated as the current date minus the hire date. DATES_EMPL_YEARS_OF_SERVICE Number No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many