Schedules
Name: Schedules
Type: Ancillary, Application
Modules: Scheduling
Description: Contains all schedules and information about them.
| Field | Documentation |
|---|---|
| SchId | Numeric identifier of the schedule date of the booking. |
| LDate | Date of the schedule. |
| SchTypeId | Schedule type for the record (from the ScheduleTypes table). |
| WeekDay | Numeric value indicating what day of the week the schedule is for (e.g., 1-7 = Sunday to Saturday). |
| ScheduleState | Hard-coded, numeric value indicating the current state of the schedule (e.g., Actived, Activating, Scheduled). |
| PassengerCount | Total number of clients or passengers scheduled to take trips. |
| TripCount | Total number of trips booked for the schedule. |
| RunTime | Total number of seconds required to perform all runs in the schedule. |
| RevenueRunTime | Total number of seconds that the schedule's combined runs are generating revenue. |
| RunDistance | Total distance all the runs in the schedule in meters. |
| RevenueRunDistance | Total distance of all the runs in the schedule that are generating revenue in meters. |
| RunSlackTime | Total number of seconds that the scheduled runs are not generating revenue. |
| IsException | Flag that indicates whether the schedule should be ignored during reporting (e.g., city-wide power outage). |
| SpeedFactor | Percentage of an average speed. 100 = no speed change. |
| StreetValidityCRC | Street router validity CRC currenty being used by this object. |
| StreetValidityCRCX | Street router validity CRC currently being used by this object for times past midnight (x-time). |