OpsRoster
Name: OPS Roster
Type: Application
Modules: OPS-Bidding, OPS-Web (Bidding)
Description: Contains roster information as converted from Fixed Route/Blockbuster.
| Field | Documentation |
|---|---|
| ScenarioId | Scenario identifier from OpsRosterScenarios.ScenarioId. References the associated roster scenario. |
| RosterId | Roster identifier from MasterRoster.RosterId. References the associated roster. |
| WeekNum | Week number. |
| Sequence | Priority number used for ordering data query records. |
| Day | Identifies the day of the week that the roster is valid (e.g., 1 = Sunday, 2 = Monday). |
| DivisionId | Division identifier from Divisions.DivisionId. References the division the department belongs to. |
| WorkType | Work type identifier from WorkSubtypes.Worktype. References the associated work type. |
| SourceId | References the associated employee absence identifier from TKAbsences.AbsenceId or incident identifier from OPSIncidents.IncidentId. |
| PieceNum | Sequential number of the piece on this run. |
| WorkName | Work name. |
| RunId | Run identifier from MasterRun.RunId. References the associated run. |
| RunNum | Run number identifier from MasterRun.RunNum. References the associated run number. |
| HolidayDate | Date of the holiday. |
| ServiceGroupId | Service group identifier from MasterServiceGroup.ServiceGroupId. |