Rota
Name: Rotation
Type: Ancillary
Description: Contains user-defined rotations.
| Field | Documentation |
|---|---|
| RotaId | Unique identifier for a rotation. |
| RotaAbbr | Abbreviation for the rotation. |
| RotaDescription | Description of the rotation. |
| DivisionGroup | Group of divisions for which this record applies. |
| RotaDays | Total number of days in the rotation. |
| BidId | Bid identifier from BidBid.BidId. References the associated bid. |
| BidUnitName | Bid unit identifier from BidUnits.BidUnitName. References the associated bid unit. |
| SupervisoryGroupId | Unique identifier for the supervisory group. |
| FromDate | Start date of the validity period. |
| ToDate | End date of the validity period. |
| DoneFlag | If true, the rota has been rolled out to the daily bidding tables. |
| ModBy | User who last modified the record. |
| ModDate | Date the record was last modified. |
| ModTime | Time the record was last modified. Value is in seconds from midnight. |
| Locked | If true, the rota has been rolled out. |
| LockedDate | Date the rota was rolled out. |
| LockedIdentityName | Identity of the user who rolled out the rota. |
| LockedTime | Time the rota was rolled out. Value is in seconds from midnight. |
| SuppressRotation | If true, the rota rotation will be suppressed. |
| ModAction | Last action performed on the record. |