Schedule Bid Simple Rotation field specifications
This table lists the field-column specifications in the Schedule Bid Simple Rotation import interface. Fields with the asterisk (*) symbol are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | SCHEDULE_BID_NAME* | Varchar2 | 40 | The name of the schedule bid to which the simple rotation is linked.
The schedule bid must exist, or the row returns an error. |
| 2 | SIMPLE_ROTATION_NAME* | Varchar2 | 40 | The name of the simple rotation to be associated with the schedule bid.
The simple rotation must exist for the team, or the row returns an error. |
| 3 | JOB_NAME* | Varchar2 | 40 | The name of the job to assign to the simple rotation within the schedule bid.
The job must exist for the team, or the row returns an error. |
| 4 | POSITIONS_NEEDED* | Integer | 40 | The total number of employees needed for this simple rotation and job combination.
This field must be a positive whole number greater than 0. |
| 5 | FLAG1 | Char | 1 | One-character field for five general purpose flags. |
| 6 | FLAG2 | Char | 1 | One-character field for five general purpose flags. |
| 7 | FLAG3 | Char | 1 | One-character field for five general purpose flags. |
| 8 | FLAG4 | Char | 1 | One-character field for five general purpose flags. |
| 9 | FLAG5 | Char | 1 | One-character field for five general purpose flags. |
| 10 | UDF1 | Varchar2 | 40 | User defined field for general use. |
| 11 | UDF2 | Varchar2 | 40 | User defined field for general use. |
| 12 | UDF3 | Varchar2 | 40 | User defined field for general use. |
| 13 | UDF4 | Varchar2 | 40 | User defined field for general use. |
| 14 | UDF5 | Varchar2 | 40 | User defined field for general use. |