Teams (Column 68)
The Employee Team field (column 68) is handled in one of these ways, depending on the format of the input value and on the setting of WORKBRAIN_TEAM/WBT_NAME in the HR Refresh Reference Settings page:
- If the field has a single input value such as Team A, Team A is assigned to the employee as their home team. If the HR Refresh Reference Settings has WORKBRAIN_TEAM/WBT_NAME set to Insert and Team A did not exist, a new team record is created in the WORKBRAIN_TEAM table.
- If the field input value
was in the format
~Team A~Team B
, the employee is assigned Team B and, assuming WORKBRAIN_TEAM/WBT_NAME in HR Refresh Reference Settings is set to Insert, Team A and Team B is created in the WORKBRAIN_TEAM table with Team A being a parent of Team B. - If the field input value was
in the format
~~Team1~Team2~…~Team N
, the employee is assigned Team N and, assuming WORKBRAIN_TEAM/WBT_NAME in HR Refresh Reference Settings is set to Insert, the team hierarchy defined in the input value is created in the WORKBRAIN_TEAM table. - If the field input value was in the format Team A Temp, the employee is assigned as a temporary member of Team A. If Insert and Team A did not exist in WORKBRAIN_TEAM/WBT_NAME of the HR Refresh Reference Settings section, a new team record is created in the WORKBRAIN_TEAM table.
- As of 4.1, terminated
employees (those employees assigned a termination date other than
1/1/3000
) is put into a TERMINATED TEAM with a date range of{termination date}
to1/1/3000
. This automatically removes the employee from hierarchy visibility for terminated dates.