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. |
| ReportTime | Time for which an operator is paid to report to work before pulling the vehicle out of the garage. |
| PrepTime | Total prep time (in seconds) for the run. |
| FinishTime | Total finish time (in seconds) for the run. |
| ClearTime | Time for which an operator is paid to clear work after pulling the vehicle into the garage. |
| StartStandBy | Time at which standby is started. |
| EndStandBy | Time at which standby is ended. |
| AdjustedFlag | Selected if work piece(s) are updated using the Edit Time function. |
| SplitNum | Sequential number of the associated split. |