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 | Bid unit of this request. |
| OpBidWorkId | References the work inside the OPSOpBidWork table. |
| HolidayId | Holiday identification if this work is on a holiday. |
| DivisionId | Division that the work belongs to. |
| WeekTemplate | 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 selected, 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 | Date the record was last modified. |
| ModTime | Time the record was last modified. |
| ModAction | Last action performed on the record. |