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