OPSWorkRefusalLog
Name: OPS Work Refusal Log
Type: Log
Modules: OPS-Bidding
Description: Contains information about work refused by an employee.
| Field | Documentation |
|---|---|
| RefusalId | Refusal identifier from OPSWorkRefusalLog.RefusalId. References the associated refusal. |
| Sequence | Priority number used for ordering data query records. |
| LDate | Date the record was created. |
| DivisionId | Division identifier from Divisions.DivisionId. References the division the department belongs to. |
| EmployeeId | Employee identifier from Employees.EmployeeId that refused the work. |
| AssignTypeId | Indicates the work assignment type. |
| AssignListId | Indicates the specific ExtraBoard or Volunteer list from which the assignment was made. |
| WorkType | Refused work type. |
| WorkId | Refused work ID. |
| PieceNum | Sequential number of the refused piece of work. |
| SchId | Refused schedule ID. |
| EvStrId | Refused EvStrId. |
| WorkName | Name of the associated work that was refused. |
| SignOnTime | Work's Sign On Time. Value is in seconds from midnight. |
| SignOffTime | Work's Sign Off Time Value is in seconds from midnight. |
| FromTime | Start time for consists. Value is in seconds from midnight. |
| ToTime | End time for consists. Value is in seconds from midnight. |
| StartTravel | Starting travel time of the work in seconds. |
| EndTravel | Ending travel time of the work in seconds. |
| StartWait | Starting wait time of the work in seconds. |
| EndWait | Ending wait time of the work in seconds. |
| OfferDate | Date the work was offered. |
| OfferTime | Time the work was offered. Value is in seconds from midnight. |
| ReportTime | Total report time in seconds. |
| ClearTime | Total clear time in seconds. |
| MakeupTime | Total makeup time in seconds. |
| ShiftLayover | Total shift layover time in seconds. |
| InActive | Flag that indicates whether the record will be excluded from costing for refusal hours. |
| EmployeeDivisionId | Employee's division for the work. |
| ModBy | User who last modified the record. |
| ModDate | Date the record was last modified. |
| ModTime | Time the record was last modified. Value is in seconds from midnight. |
| ModAction | Last action performed on the record. |