| Change in FTE |
A count of employees that changed their FTE |
Effective From Date |
| Change in HR Organization Unit |
A count of employees that changed their HR Organization Unit |
Effective From Date |
| Change in Job |
A count of employees that changed their Job code |
Effective From Date |
| Change in Position |
A count of employees that changed their Position |
Effective From Date |
| Change in Supervisor |
A count of employees that changed the supervisor code they directly report to |
Effective From Date |
| Distinct Employee Count |
Distinct number of Employee IDs of employees in a By Snapshot
Month. This measure is used to eliminate the duplication of counts for employees with
multiple work assignments. It includes employees that were terminated during the
month. |
By Snapshot Month |
| Employee Count |
A 1 for every employee and work assignment without a termination
date as of the last day of the month |
By Snapshot Month |
| Employee Turnover Count |
A 1 for every employee and work assignment (active at
termination) with a termination date within the by snapshot month for each
assignment |
By Snapshot Month |
| FTE |
This measure includes those employees who were terminated and
rehired in the same month. |
By Snapshot Month |
| Internal Hire |
Change in Job Code, Position Code, HR Unit, Direct Report
Supervisor or an additional Work Assignment = 1 |
Effective Date |
| Internal Separation |
Change in Job Code, Position Code, HR Unit, Direct Report
Supervisor or an additional Work Assignment = 1 |
End Date |
| LOS |
Average Length of Service = (By Snapshot Month-Start Date) in
Years |
By Snapshot Month |
| Adjusted LOS |
Average Length of Service based on the Adjusted Start
Date |
By Snapshot Month |
| Seniority LOS |
Average Length of Service based on Seniority Date |
By Snapshot Month |
| New Hire |
Distinct Count Employee Key on Start Date when Start Date
<> Termination Date |
Effective Date |
| Non Starter |
Distinct Count Employee Key on Start Date when Start Date =
Termination Date |
Effective Date |
| Rehire |
A Rehire action’s Effective From Date. |
Effective Date |
| Retirement |
Distinct Count Employee Key on Retirement date. Not necessarily
terminated. |
Effective Date |
| Starter |
Sum of New Hire + Rehire |
Effective Date |
| Termination |
Distinct Count Employee Key on Termination Date when Termination
Date <> Start Date |
Effective Date |
| Time in Job |
(By Snapshot Month – Job Start Date) in Years |
By Snapshot Month |
| Monthly Turnover Rate |
(Employee Turnover Count / Employee Count) * 100 |
By Snapshot Month |
| Annual Turnover Rate |
(Employee Turnover Count / ( Employee Count /
Months))*100 |
By Snapshot Month |
| Annual Retention Rate |
(([SnapShot_Month: Sum: Employee Count] WHERE ([Work Assignment
Monthly Snapshot.LOS] > 0.9999)) / [YAGO SnapShot_Month: Sum: Employee Count])
*100 |
By Snapshot Month |
| Monthly Retention Rate |
((SnapShot_Month: # DistinctEmployee Key WHERE [Work
AssignmentMonthly Snapshot.LOS] > 0.0833 AND [Work Assignment MonthlySnapshot.Employee
Count]=1) /(MAGO SnapShot_Month: # Dis-tinct Employee KeyWHERE [Work Assign-ment
Monthly Snapshot.LOS] >0.0 AND [Work AssignmentMonthly Snapshot.EmployeeCount]=1))
*100 |
By Snapshot Month |
| Annualized Turnover |
Projects turnover for the current Year on a Year/Month basis,
based on current year’s actual turnover to date. |
To be used with current year’s Year/Month |