Employee Temporary Team Import example

For example, assume these temporary team assignments are currently configured:

Employee	Temporary Team	Start Date	End Date	Ext_Code
Emp1	Team2	01/01/2021	03/31/2021
Emp1	Team3	01/01/2021	08/31/2021	123
Emp2	Team1	02/01/2021	06/30/2021
Emp3	Team1	06/01/2021	12/31/2021
Emp4	Team1	01/01/2021	02/28/2021
Emp4	Team1	06/01/2021	08/31/2021
Emp4	Team2	01/01/2021	04/30/2021
Emp5	Team2	03/01/2021	7/31/2021

As a system administrator, you create a CSV file containing the following data:

Record #	EMP_NAME	WBT_NAME	START_DATE	END_DATE	ACTION	EXT_CODE
1	Emp1	Team1	03/01/2021	05/31/2021	ADD	111
2	Emp1	Team3	03/01/2021	06/30/2021	UPDATE	123
3	Emp2	Team1	05/01/2021	07/01/2021	ADD
4	Emp3	Team1	07/01/2021	11/30/2021	UPDATE
5	Emp4	Team1	02/01/2021	07/31/2021	UPDATE
6	Emp4	Team2	01/01/2021	04/30/2021	DELETE
7	Emp5	Team2	01/01/2021	12/31/2021	DELETE

After the import is finished, these temporary team assignments are applied:

Employee	Temporary Team	Start Date	End Date	Ext_Code	Notes
Emp1	Team1	03/01/2021	05/31/2021	111	Added based on import file
Emp1	Team2	01/01/2021	03/31/2021		Existing temporary team assignment
Emp1	Team3	03/01/2021	06/30/2021	123	Updated start and end dates based on EXT_CODE in import file
Emp2	Team1	02/01/2021	07/01/2021		Dates adjusted for existing team assignment to earliest possible start date and latest possible end date between existing and import data
Emp3	Team1	07/01/2021	11/30/2021		Updated start and end dates based on import file
Emp4	Team1	02/01/2021	07/31/2021		Combined 2 temporary team assignments into 1 temporary team assignment
Emp5	Team2	03/01/2021	07/31/2021		No action taken as the start and end dates in the import file do not match the existing team assignment