User Delegate field specifications
This table lists the field-column specifications in the User Delegate import interface. Fields with the asterisk (*) symbol are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | WBU_ID* | Number | 22 | The User ID from the WORKBRAIN_USER table. |
| 2 | WBUDT_ID* | Number | 22 | The Delegate Type ID from the WB_USER_DELEGATE_TYPE table. This is the type of delegation being assigned. |
| 3 | WBUD_REF_WBU_ID | Number | 22 | The User ID for the delegated user from the WORKBRAIN_USER table. |
| 4 | WBUD_REF_WBROLE_ID | Number | 22 | This is the Role ID for the delegated role from the WORKBRAIN_ROLE table. |
| 5 | WBUD_START_DATE* | Date | yyyyMMdd | The effective start date. Note: The default for a blank
value is the current date.
|
| 6 | WBUD_END_DATE* | Date | yyyyMMdd | The effective end date. Note: The default for a blank value
is 01/01/3000.
|