OPSBidWork
Name: OPS Bid Work
Type: Application
Modules: OPS-Bidding, OPS-Web (Bidding)
Description: Stores work that is available to be bid on.
| Field | Documentation |
|---|---|
| BidWorkId | Unique identifier of available work in a bid. |
| BidId | Unique identifier of the bid associated with the work. |
| PeriodId | BidPeriod identifier (from the BidPeriods table). |
| HolidayId | Unique identifier for holiday work. |
| DivisionId | Division where the work takes place. |
| WeekTemplate | Week template for the work availability. |
| BidWorkType | Work type base on logic in Unbid Work Inquiry service (0 = Run , 1 = Roster, 2 = Extraboard, 3 = Vacation Relief). |
| SourceId | Source identifier based on BidWorkType (RosterId, RunId, QuotaId (for Extraboard)). |
| SourceName | Source name. |
| WorkType | Type of work for the bid. |
| PieceNum | Identifier of the piece of work within the work for the bid. |
| ScenarioId | Unique identifier of the roster scenario. |
| AvailableWeek | Week the work is available. If empty, the availability of the work is not restricted to one week. |
| EmployeeId | Employee who picked the vacation relief package. |
| BidQuotaId | Unique identifier of the bid quota associated with the work (from the BidDayoffQuota table). |
| Remaining | Remaining number of work that can be bid on. |
| OffdayCombo | Days of the week that the quota is valid. |
| ModBy | User who last modified the record. |
| ModDate | Date the record was last modified. |
| ModTime | Time the record was last modified. |
| ModAction | Last action performed on the record. |