OPSOpBidRequests
Name: OPS Op Bid Requests
Type: Application
Modules: OPS-Bidding (Operational), OPS-Web (Bidding Operational)
Description: Contains operational bid requests.
| Field | Documentation |
|---|---|
| OpBidId | Operational Bid Identifier. |
| EmployeeId | The identification number of the employee in this request. |
| GroupId | The request group identifier. |
| Sequence | The sequence number of the request within the group. |
| PeriodId | The Period Identifier within the bid. |
| BidUnitName | The bid unit of this request. |
| OpBidWorkId | References the work inside the OPSOpBidWork table. |
| HolidayId | The holiday identification if this work is on a holiday. |
| DivisionId | The division that the work belongs to. |
| WeekTemplate | The week template that the employee requested the work for. |
| BidWorkType | Indicates the type of work. 0=FXRun 1=Roster 2=ExtraWork 3=ExtraBoard 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 name. |
| PieceNum | The number to identify which work in the set of Extra work. |
| ScenarioId | Scenario identifier from OpsRosterScenarios.ScenarioId. References the associated roster scenario. |
| OptionalFlag | If true, the work is optional. |
| ProcessMessage | The system-generated post-processing message. |
| RequestStatus | The status of the bid request ( 0 = not processed 1 = successfully bid, 3 = rejected). |
| NumWeeks | For a hold-down operational bid, the number of weeks requested for the held-down work. |
| 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. |