OPSOpBidWork

Name: OPS Op Bid Work

Type: Application

Modules: OPS-Bidding (Operational), OPS-Web (Bidding Operational)

Description: Contains operational bid work.

Field Documentation
OpBidWorkId The identification of the work that can be bid.
OpBidId Operational Bid Identifier.
PeriodId References the period in the BidPeriods table.
HolidayId The holiday identification if this work is holiday work.
DivisionId The division that the work belongs to.
WeekTemplate The week template that 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 The name of the Run, Roster, Work, EB, or Holding Down employee.
PieceNum The number to identify the work in the set of Extra work.
ScenarioId The Run scenario identifier applicable for FX-Run and Roster.
PrimaryFlag If true, 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.
ModBy User who last modified the record.
ModDate The date the record was last modified.
ModTime The time the record was last modified.
ModAction Last action performed on the record.