Team Import Interface field specification
This table lists the field-column specifications of the Team Import Interface. Fields with the asterisk symbol (*) are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | Wbt_String* | Varchar2 | 1000 | Team hash string. See Team string (column 1). |
| 2 | Wbt_Action* | Varchar2 | 40 | Team action: Add, Delete, or Add Location. |
| 3 | Wbrole_Name* | Varchar2 | 40 | User role for team. See Roles (column 3). |
| 4 | Wbu_Name* | Number | 22 | Workforce Management user name for team user-role assignment purposes. |
| 5 | Wbut_Action* | Team user-role action: Add, Delete, or Update. | ||
| 6 | Wbut_Start_Date* | Varchar2 | yyyymmdd | Start date of user-role team privilege. Default is 19000101. |
| 7 | Wbut_End_Date* | Varchar2 | yyyymmdd | End date of user-role team privilege. Default is 30000101. |
| 8 | Wbt_Desc | Varchar2 | 100 | Optional description for the specified team (leaf team in Wbt_String). If this field is not supplied, the leaf team name in Wbt_String is used as the description. |
| 9 | Wbt_Label | Varchar2 | 8 | Optional label for the specified team (leaf team in Wbt_String). |
| 10 | Wbt_DayStartTime | Varchar2 | 00:00 | Optional team-specific day start time for MVS teams. This value is specified in 24-hour format. |
| 11 | WBT_UDF1 | Varchar2 | 40 | Optional field for Child/Lef Teams UDFs. |
| 12 | WBT_UDF2 | Varchar2 | 40 | Optional field for Child/Lef Teams UDFs. |
| 13 | WBT_UDF3 | Varchar2 | 40 | Optional field for Child/Lef Teams UDFs. |
| 14 | WBT_UDF4 | Varchar2 | 40 | Optional field for Child/Lef Teams UDFs. |
| 15 | WBT_UDF5 | Varchar2 | 40 | Optional field for Child/Lef Teams UDFs. |
| 16 | WBT_FLAGS | Varchar2 | 1000 | Optional field to use up to five single-character flags for general use. Each flag is separated by a tilde (~). For example, Y~N~Y~N~Y which is translated to Flag1 = Y, Flag2 = N, Flag3 = Y, Flag4 = N, and Flag5 = Y. |
| 17 | WBT_CODE | Varchar2 | 20 | Optional field used to specify Team Code values for each team in the hierarchy. The number of values must match the number of teams defined in WBT_STRING. |
| 18 | Wbt_Hours_Of_Operation | Varchar2 | 40 | Optional field for specifying the Hours of Operation for each team in the hierarchy. Each value must correspond to a valid entry in the HOURS_OF_OPERATION reference table and align with the number of teams defined in WBT_STRING. |
| 19 | Wbt_Sub_Team_Type | Varchar2 | 40 | Optional field for specifying the Sub Team Type assigned to each team in the hierarchy. The number of values must correspond to the number of teams defined in WBT_STRING. |