OPSMissedTrips
Name: OPS Missed Trips
Type: Application
Modules: OPS-Dispatch, OPS-Workforce Management
Description: Contains missed trips.
| Field | Documentation |
|---|---|
| WorkId | Work identifier from TkWork.WorkId. References the associated work. |
| PieceNum | Sequential number of a piece of work. |
| TripId | Trip identifier from Trips.TripId. References the associated trip. |
| LDate | Date when the trip was missed. |
| WorkType | Work type identifier from WorkSubtypes.Worktype. References the associated work type. |
| BlockId | Block identifier from Blocks.BlockId. References the associated block. |
| WorkName | Name of the work. |
| FromTime | Start time of the trip that was missed. Value is in seconds from midnight. |
| ToTime | End time of the trip that was missed. Value is in seconds from midnight. |
| ReasonId | Reason identifier from OpsDispatchReason.ReasonId. References the associated cancelled work reason. |
| Description | Explanation of why the trip was missed. |
| LogId | Log record identifier from TKDispatchLog.LogId. References the associated dispatch log entry. |
| OPSTripId | OPS trip ID. |
| TransactionDate | TBD |
| TransactionTime | TBD |
| PartialTrip | If true, indicates that a trip cancelation is for only a portion of a trip |
| WorkSourceId | Original reference work ID (needed in case of a subsequent change to the work item - split, cancel, merge). |