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} to 1/1/3000. This automatically removes the employee from hierarchy visibility for terminated dates.