Workload Requirements field specifications
This table lists the field-column specifications in the Workload Requirements import interface. Fields with the asterisk (*) symbol are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | WBT_ID* | Number | 22 | The team ID from the WORKBRAIN_TEAM table. |
| 2 | JOB_ID* | Number | 22 | The job ID from the JOB table. |
| 3 | WRKLS_ID* | Number | 22 | The workload source ID from the ES_WORKLOAD_SOURCE table. |
| 4 | DP_ID* | Number | 22 | The day part ID from the DAY_PART table. |
| 5 | WLR_REQ* | Number | 22 | Required workload in minutes. |
| 6 | WLR_DATE* | Date | yyyyMMdd | Date for the required workload. |
| 7 | WLR_LAST_UPDATED* | Date | yyyyMMdd | Last updated date for the required workload. |
| 8 | WLR_FLAG1 | Varchar2 | 1 | One-character flag for general use.
A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag positions indicates the flag is to be blanked. |
| 9 | WLR_FLAG2 | Varchar2 | 1 | One-character flag for general use. |
| 10 | WLR_FLAG3 | Varchar2 | 1 | One-character flag for general use. |
| 11 | WLR_FLAG4 | Varchar2 | 1 | One-character flag for general use. |
| 12 | WLR_FLAG5 | Varchar2 | 1 | One-character flag for general use. |
| 13 | WLR_UDF1 | Varchar2 | 40 | User defined field. |
| 14 | WLR_UDF2 | Varchar2 | 40 | User defined field. |
| 15 | WLR_UDF3 | Varchar2 | 40 | User defined field. |
| 16 | WLR_UDF4 | Varchar2 | 40 | User defined field. |
| 17 | WLR_UDF5 | Varchar2 | 40 | User defined field. |