How do we calculate Leavers?
We look at ALL the ee’s LC Status records, then compare each record with the one previous (and one case to the next) to it - in order not to miss any changes done within a period.
Per record, we look at an ee in the selected time range and make sure the ee is not employed (LC Status = Terminated, Hired and check if this ee existed in the previous record:
- Didn’t exist - N/A will not be counted as Termination
- Employee Existed in the prev record
- In case LC Status = Employed / Leave / Garden leave / Parental leave (in the prev record) then current record counts as termination
- In case the ee’s LC Status = Terminated, Hired (in the prev record) then the ee is not a leaver
**Back-to-back**: The only exception is if the employee has a record (in the selected time range) that is not in the headcount (LC Status = terminated) and then exactly one day after that employee is employed (LC Status = Employed / Leave / Garden leave / Parental leave), in this case the employee is not counted as a Leaver.
Examples:
- Simple case
Date range: 1.1.2022 - 31.12.2022
| Effective Date | LifeCycle status | EE id | |
| 1.3.2022 | Employed | 123 | |
| 1.6.2022 | Terminated | 123 | |
| 1.9.2022 | Employed | 123 |
In 2022 we’ll count the employee 123 as terminated once: in 1.6.2022 (new LC record which is NOT in headcount (LC = Terminated, Hired, and previous record with LC = Employed / Leave / Garden leave / Parental leave.
Note:
*On a yearly view the employee will be presented only once in the grid, with its recent LC status (employed, start date: 1.9.2022) . Customers will be able to see both records on a monthly view.
*In cases the employee joined, terminated then joined again at the same month only the most recent LC record will be presented in the grid
- Back-to-back
Date range: 1.1.2022 - 31.12.2022
| Effective Date | LifeCycle status | EE id | |
| 1.3.2022 | Employed | 123 | |
| 1.6.2022 | Terminated | 123 | |
| 2.6.2022 | Employed | 123 |
In 2022 we’ll NOT count the employee 123 as leaver: we’ll ignore the record from 2.6.2022
(since the employee joined the next day after he was terminated)
- Multiple leaves:
Date range: 1.1.2022 - 31.12.2022
| Effective Date | LifeCycle status | EE id | |
| 1.3.2022 | Employed | 123 | |
| 1.6.2022 | Terminated | 123 | |
| 1.9.2022 | Employed | 123 | |
| 1.11.2022 | Terminated | 123 |
In 2022 we’ll count the employee 123 as terminated twice:
- once in 1.6.2022 since new LC record is not in headcount (LC = terminated), previous LC status from the 1.3.2022 is Employed and,
- In 1.11.2022 we count the record as termination since new LC record which is not in headcount, previous LC status from the 1.9.2022 is Employed