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. |