PassAgentLog
Name: Pass Agent Log
Type: Ancillary
Modules: Reporting
Description: Stores the external calls, automatic calls - timer to the TP6 server.
| Field | Documentation |
|---|---|
| PassAgentLogId | Numeric identifier of the PASS Agent log entry. |
| JobId | Numeric identifier of the job (from the JobTypes table). |
| Name | Name of the job that was logged. |
| BatchName | Name of the batch operation used. |
| StartDate | Start date of the batch operation. |
| StartTime | Start time of the batch operation. Value is in seconds from midnight. |
| EndDate | End date of the batch operation. |
| EndTime | End time of the batch operation. Value is in seconds from midnight. |
| Duration | Number of seconds the batch operation took to complete. |
| SchId | Numeric identifier of the booking schedule date (from the Schedules table). |
| ParamSet | Name of the parameter set used by the batch operation. |
| ViolSet | Name of the violation set used by the batch operation. |
| UserName | Name of the user or agent that started the batch operation. |
| BatchAttemptedTripCount | Total number of trips that were attempted to be scheduled by the batch operation. |
| BatchScheduledTripCount | Total number of trips that were successfully scheduled by the batch operation. |
| PassengerCount | Total number of passengers whose trips were scheduled by the batch operation. |
| TripCount | Total number of trips that were scheduled during the batch operation. |
| UnscheduledCount | Total number of trips that remain unscheduled during the batch operation. |
| CancelledCount | Total number of trips that were cancelled during the batch operation. |
| NoshowedCount | Total number of trips that were counted as NoShow during the batch operation. |
| RunTime | Total run time of all runs in seconds. |
| RevenueRunTime | Total time from all runs in seconds that revenue is being generated. |
| NonRevenueRunTime | Total time from all runs in seconds that no revenue is being generated (e.g., refueling). |
| RunDistance | Total distance in meters to be traveled by all runs. |
| RevenueRunDistance | Total distance in meters from all runs where revenue is being generated. |
| NonRevenueRunDistance | Total distance in meters from all runs where revenue is not being generated (e.g., driving to a gas station). |
| RunSlackTime | Total amount of slack time (the difference between the travel time and actual travel time between events) from all runs in seconds. |
| TripsPerRevenueHour | Average number of trips that generate revenue per hour. |
| PassengersPerHour | Average number of passengers transported per hour. |
| PassengersPerRevenueHour | Average number of passengers that generate revenue per hour. |
| PassengersPerDistance | Average number of passengers transported per kilometer. |
| PassengersPerRevenueDistance | Average number of passengers that generate revenue transported per kilometer. |
| HoursToRevenueHours | Ratio of hours used for trips to hours that generate revenue during trips. |
| RunServiceTime | Total time in seconds that the runs are in service. |
| Version_Text | Version of SchedServer used to generate a particular solution (used for testing). |
| jobInstanceId | Internal use only. |
| jobType | Description-type name of job (used for display purposes). |
| jobResult | Status of the job (0 = incomplete, 1 = complete, 2 = canceled, 3 = failed). |