BidLineWork
Name: Bid - Line Work
Type: Application
Modules: OPS-Bidding, OPS-Dispatch, OPS-Timekeeping
Description: Contains all long-term work assignments.
| Field | Documentation |
|---|---|
| BidLineId | Bid line identifier from BidLine.BidLineId. References the associated bid line. |
| FromDate | Start date of the work assignment. |
| ToDate | End date of the work assignment. |
| WeekTemplate | 7-character string indicating what days of the week on which the bid line is valid (e.g., 0011001 means Monday, Tuesday, and Friday). |
| WorkType | Work type identifier from WorkSubtypes.Worktype. References the associated work type. |
| QuotaListId | Bid quota list identifier from BidQuotaList.BidQuotaListId. References the associated bid quota list. |
| SourceId | Run identifier from MasterRuns.RunId. |
| HolidayId | Holiday identifier from Holidays.HolidayId. References the associated holiday. |
| WorkName | Name of the work. |
| Num | Number of Extra Work vehicles assigned to the bid line. |
| PassNumber | Bid pass number. |
| RosterId | Roster identifier from MasterRoster.RosterId. References the associated roster. |
| RosterNum | Number of the associated roster. |
| ServiceGroupId | Service group identifier from ServiceGroup.ServiceGroupId. References the associated service group. |
| PieceNum | Sequential number of the associated piece of work. |
| DivisionId | Division identifier from MasterDivisions.DivisionId. References the associated division. |
| RosterName | Name of the associated bid roster. |
| ScenarioId | Roster scenario identifier from OpsRosterScenarios.ScenarioId. References the associated roster scenario. |
| WorkSubtype | Work subtype identifier from WorkSubtypes.WorkSubtype. References the associated work subtype. |
| 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. |
| ModAction | Last action performed on the record. |