BidEmployees

Name: Bid - Employees

Type: Application

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

Description: Contains the employees that are participating in each bid.

Field Documentation
BidId Bid identifier from BidBid.BidId. References the associated bid.
EmployeeId Employee identifier from Employees.EmployeeId. References the associated employee.
DivisionId Division identifier from Divisions.DivisionId. References the associated division.
NewDivisionId New division identifier of the employee who bids outside the division. From Divisions.DivisionId.
Sequence Priority number used for ordering data query records.
BidRqDeadlineDate Deadline date for submitting bidding changes.
BidRqDeadlineTime Deadline time for submitting bidding changes. Value is in seconds from midnight.
BidRqFromDate Start date bidding changes can be submitted.
BidRqFromTime Start time bidding changes can be submitted. Value is in seconds from midnight.
BidRqToDate End date for bidding changes to be submitted.
BidRqToTime End time for bidding changes to be submitted. Value is in seconds from midnight.
OldSequence Priority number used for ordering data query records of the previous do over bid.
OldBidRqFromDate Start date when bidding changes of the previous do over bid can be submitted.
OldBidRqFromTime Start time when bidding changes of the previous do over bid can be submitted. Value is in seconds from midnight.
OldBidRqToDate End date for bidding changes of the previous do over bid to be submitted.
OldBidRqToTime End time for bidding changes of the previous do over bid to be submitted. Value is in seconds from midnight.
OldBidUnitName Bid Unit Name of the previous do over bid.
PreviousBidUnitName This is used for the Automatic Holiday Bidding process only. During the processing of Automatic Holiday bids, the employee's previous BidUnitName is preserved in this column. If the Holiday bid is deleted or rolled-back, this value is used to reinstate the employee's original bid unit.
PreviousDayOffFlag This is used for the Automatic Holiday Bidding process only. During the processing of Automatic Holiday bids, this flag is set to preserve the employee's day off status. If the Holiday bid is deleted or rolled-back, this value is used to reinstate the employee's original days off.