OPSPublishedWork
Name: OPS Published Work
Type: Application
Modules: OPS-Dispatch
Description: Contains all published work.
| Field | Documentation |
|---|---|
| WorkId | Work identifier from TkWork.WorkId. References the associated work. |
| PieceNum | Sequential number of the associated piece of work. |
| SchId | Schedule identifier from Schedules.SchId. References the associated schedule. |
| EmployeeId | Employee identifier from Employees.EmployeeId. References the associated employee. |
| SignOnTime | Sign-on time. Value is in seconds from midnight. |
| FromTime | Start time of the work. Value is in seconds from midnight. |
| ToTime | End time of the work. Value is in seconds from midnight. |
| SignOffTime | Sign-off time. Value is in seconds from midnight. |
| StartTravel | Elapsed travel time in seconds associated with the beginning of the piece. |
| StartWait | Elapsed wait time in seconds associated with the beginning of the piece. |
| EndTravel | Elapsed travel time in seconds associated with the end of the piece. |
| EndWait | Elapsed wait time in seconds associated with the end of the piece. |
| EvStrId | Event string identifier from EventStrings.EvStrId. References the associated event string. |
| AssignTypeId | Custom assignment type identifier from OpsCustomAssignmentTypes.AssignTypeId. References the associated custom assignment type. |
| AssignListId | Indicates the specific ExtraBoard or Volunteer list from which the assignment was made. |
| MakeupTime | Total makeup time in seconds. |
| ShiftLayover | Total shift layover time in seconds. |