OPSOpBidWork
Name: OPS Op Bid Work
Type: Application
Modules: OPS-Bidding (Operational), OPS-Web (Bidding Operational)
Description: Contains operational bid work.
| Field | Documentation |
|---|---|
| OpBidWorkId | Identification of the work that can be bid. |
| OpBidId | Operational Bid Identifier. |
| PeriodId | References the period in the BidPeriods table. |
| HolidayId | Holiday identification if this work is holiday work. |
| DivisionId | Division to whicht the work belongs. |
| WeekTemplate | Week template availability for the work is available for. |
| BidWorkType | Indicates the type of work (0 = FXRun, 1 = Roster, 2 = ExtraWork, 4 = HoldDown). |
| SourceId | Based on the BidWorkType, this identifier could be RunId, RosterId, WorkId, QuotaId (for EB), EmployeeId (for Hold Down Bid). |
| SourceName | Work source name for the bid (name of the Run, Roster, Work, EB, or Holding Down employee). |
| PieceNum | Number used to identify the work in the set of Extra work. |
| ScenarioId | Run scenario identifier applicable for FX-Run and Roster. |
| PrimaryFlag | If seleted, the work is Primary Work. |
| PrimaryOpWorkId | Reference OpBidWorkId. If populated, it will reference Primary Work that must always be bid together with this work. |
| NumWeeks | For a Hold-down operational bid, the number of weeks that the work is available for hold-down. |
| EmployeeId | Unique identifier of the employee who picked the vacation relief package. |
| AvailableWeek | Week the work is available. If empty, the availability of the work is not restricted to one week. |
| 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. |