OPSWorkRefusalLog

Name: OPS Work Refusal Log

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.