Simple Rotation Import field specifications
These tables list the field-column specifications of the Simple Rotation Import Interface. Fields with the asterisk symbol (*) are required.
For rotation row import:
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1/A | Type* | This field determines whether the import is for ROTATION or SHIFT. Specify ROTATION for rotation row import.
If a rotation row is processed during import and the rotation does not exist, a rotation is created with the specified name, description, team, and start date. |
||
| 2/B | Rotation Name* | Varchar2 | 40 | The name of the simple rotation. |
| 3/C | Rotation Description | Varchar2 | 100 | The description of the simple rotation. |
| 4/D | Team Name* | Varchar2 | 40 | The name of the team associated with the rotation. This field is not case-sensitive. You cannot change the team name for an existing rotation. |
| 5/E | Rotation Start Date | Date | yyMMdd | The start date for the rotation. You cannot change the start date for an existing rotation. If left blank, the default value is 1900-01-01. |
| 6/F-10/J | Rotation Flag 1-5 | Char | 1 | Five optional rotation flags. |
| 11/K-15/O | Rotation UDF 1-5 | Varchar2 | 40 | Five optional rotation user-defined fields. |
For shift row:
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1/A | Type* | This field determines whether the import is for ROTATION or SHIFT. Specify SHIFT for shift row import. | ||
| 2/B | Rotation Name* | Varchar2 | 40 | The name of the simple rotation associated with the shift. This field is not case-sensitive. The simple rotation name must exist in the application or in a preceding rotation row. |
| 3/C | Day Number* | Varchar2 | 100 | The position of the shift within the rotation cycle. Specify the value using a positive integer. Duplicate day numbers within the same rotation are supported with the last occurrence taking effect. Gaps in the sequence are allowed. |
| 4/D | Shift Label | Varchar2 | 40 | The display label of the shift. This is resolved during import by case-sensitive match against shifts configured for the rotation's team that are active on the rotation start date. If the label does not match a shift on the team, the row is rejected. If the matched shift is not active on the rotation date, the row is rejected. |
| 5/E-9/I | Shift Flag 1...5 | Char | 1 | Five optional shift flags. |
| 10/J-14/N | Shift UDF 1...5 | Varchar2 | 40 | Five optional shift user-defined fields. |