Termination date
When terminating an employee using the Emp_Termination_Date field, the import process checks an employee's status before setting the employee's termination date.
If the employee's status is inactive:
- If the termination date (termination_date) is configured, then the employee's termination date is set to termination_date and the employee's home team assignment is updated to TERMINATED TEAM with a date range of termination_date to 01/01/3000.
- If the termination date is empty, then there is no change to the employee record.
If the employee's status is active:
- If the termination date (termination_date) is configured and less than the default termination date of 01/01/3000, then the employee's termination date is set to termination_date and the employee's home team assignment is updated to TERMINATED TEAM.
- If the termination date is empty or 01/01/3000, then there is no change to the employee record.
Rehiring fixed-term employees
When rehiring a previously terminated employee whose employment is temporary and their future termination date is known, you can use one CSV file to get the correct team assignments. In the CSV file, specify the employee's new contract information including their hire date, team assignment, and termination date.
For example, assume these team assignments are currently configured for EMP1:
| TEAM | Start Date | End Date | Home Team |
|---|---|---|---|
| UNASSIGNED TEAM | 01/01/1900 | 09/30/2020 | Enabled |
| IT | 10/01/2020 | 11/30/2020 | Enabled |
| TERMINATED TEAM | 12/01/2020 | 01/01/3000 | Enabled |
EMP1 is then rehired on a second contract on the TEAM1 team. The contract starts on January 1, 2021 and ends on March 31, 2021.
In this scenario, the CSV file would include this data among others:
| Ovr_Start_Date | Ovr_End_Date | Emp_Name | Emp_Hire_Date | Emp_Termination_Date | Empt_Hierarchy |
|---|---|---|---|---|---|
| 01/01/2021 | 01/01/3000 | EMP1 | 01/01/2021 | 04/01/2021 | TEAM1 |
With this data, EMP1's hire date is updated to January 1, 2021 and their termination date is updated to April 1, 2021.
After the Employee Import, these team assignments are applied:
| TEAM | Start Date | End Date | Home Team |
|---|---|---|---|
| UNASSIGNED TEAM | 01/01/1900 | 09/30/2020 | Enabled |
| IT | 10/01/2020 | 11/30/2020 | Enabled |
| TERMINATED TEAM | 12/01/2020 | 12/31/2020 | Enabled |
| TEAM1 | 01/01/2021 | 03/31/2021 | Enabled |
| TERMINATED TEAM | 04/01/2021 | 01/01/3000 | Enabled |