OPSWkRosterWorkDetail
Name: OPS Weekly Roster Work Detail
Type: Application
Modules: OPS-Bidding
Description: Contains detailed roster work information.
| Field | Documentation |
|---|---|
| RotaId | Rotation identifier from Rota.RotaId. References associated rotation. |
| RosterId | Roster identifier from MasterRoster.RosterId. References the associated roster. |
| Day | Number representing the day of the week (e.g., 0=Sunday, 1=Monday). |
| Sequence | Priority number used for ordering data query records. |
| WorkName | Name of the work. |
| DivisionId | Division identifier from MasterDivisions.DivisionId. References the associated division. |
| WorkType | Work type identifier from WorkSubtypes.Worktype. References the associated work type. |
| SourceId | Based on WorkType, this field can refer to a run from Run.RunId, an ExtraWork from TkExtraWork.WorkId, or a PassRun from ParaRuns.RunId. |
| PieceNum | Sequential number of the associated piece of work. |
| ServiceGroupId | Service group identifier from ServiceGroup.ServiceGroupId. References the associated service group. |
| ExcComboId | Exception combination identifier from ExceptionCombinations.ExcComboId. References the associated exception combination. |
| IsDayOff | If true, the day is off. |
| OriginalEmployeeId | Employee identifier from OPSDailyRelief.OriginalEmployeeId. References the employee who was relieved of the associated work. |
| BidUnitName | Bid unit identifier from BidUnits.BidUnitName. References the associated bid unit. |
| HolidayId | Holiday identifier from Holidays.HolidayId. References the associated holiday. |
| WorkSubtype | Work subtype identifier from WorkSubtypes.WorkSubtype. References the associated work subtype. |
| RunVersionId | Run versioning identifier that is used with RunId to uniquely identify a run in OPSMasterRun and OPSRun; generally sourced from the FX ExcComboId. |