TKDispatchLog
Name: Timekeeping Dispatch Log
Type: Log
Modules: OPS-Employee Profile, OPS-Dispatch, OPS-Workforce Discipline
Description: Contains dispatch log entries.
| Field | Documentation |
|---|---|
| LogId | Unique identifier for a dispatch log entry. |
| LDate | Date the log was generated. |
| DivisionId | Division identifier from MasterDivisions.DivisionId. References the associated division. |
| LogTypeId | Log type (0 = Dispatch Orders, 1 = Accidents, 2 = Work Incidents, 3 = Employee Incidents, 4 = Cancel Service, 5 = Vehicle Change Out, 6 = Cancel Trips, 7 = Log Type Count). |
| LogSourceId | Identifies the log source in conjuction with LogTypeId (e.g., If LogTypeId is Vehicle Change Out, then LogSourceId may be an identifier from OpsVehicleChangeOut.VehicleChangeOutId). |
| CallSource | Source that generated the log (A = Alarm, R = Radio, T = Telephone, S = Supervisor, I = ITS, O = Other). |
| DelayFromTime | Start time of the missed trip, if the LogTypeId is 4 or 5. Value is in seconds from midnight. |
| DelayToTime | End time of the missed trip, if the LogTypeId is 4 or 5. Value is in seconds from midnight. |
| DelayTime | Total time in seconds of the missed trip, if the LogTypeId is 4 or 5. |
| LineDelayFromTime | Start time of the missed service, if the LogTypeId is 4 or 5. Value is in seconds from midnight. |
| LineDelayToTime | End time of the missed service, if the LogTypeId is 4 or 5. Value is in seconds from midnight. |
| LineDelayTime | Total time in seconds of the missed service, if the LogTypeId is 4 or 5. |
| MissedTripCount | If LogTypeId is 5, this field contains the total number of missed trips. |
| UserName | User who was signed in at the time of the log entry. |
| DispatchLogTime | Time the log was generated. Value is in seconds from midnight. |
| PieceNum | Sequential number of the associated piece of work. |