OPSBidHistoryWork
Name: OPS Bid History Work
Type: Application
Modules: OPS-Bidding, OPS-Web (Bidding)
Description: Stores the history of an employee's bid work.
| Field | Documentation |
|---|---|
| BidHistoryId | Bid History identifier. |
| FromDate | The start date of the work assignment. |
| ToDate | The end date of the work assignment. |
| WeekTemplate | Indicates the active day(s) in a week. |
| WorkType | Work type identifier from WorkSubtypes.Worktype. References the associated work type. |
| SourceId | Run identifier from MasterRuns.RunId. |
| HolidayId | Holiday identifier from Holidays.HolidayId. References the associated holiday. |
| WorkName | The name of the work. |
| Num | The number of Extra Work vehicles assigned to the bid line. |
| RosterId | Roster identifier from MasterRoster.RosterId. References the associated roster. |
| RosterNum | The number of the associated roster. |
| ServiceGroupId | Service group identifier from ServiceGroup.ServiceGroupId. References the associated service group. |
| PieceNum | The sequential number of the associated piece of work. |
| DivisionId | Division identifier from MasterDivisions.DivisionId. References the associated division. |
| RosterName | The 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. |
| BidLineId | Bid line identifier from BidLine.BidLineId. References the associated bid line. |