EventsOld

Name: Events old

Type: Application

Modules: Scheduling, Mdt

Description: Contains the scheduling results from the schedule server as they were first created. Compare to Events to track user changes and messaging sent to the driver of the run. Used by the dispatching, dispatch center.

Field Documentation
SchId Numeric identifier of the schedule date of the booking (from the Schedules table).
IncidentId Numeric identifier of the EventsOld incident or complaint that occurred during the event.
EvId ID number of the Event (from the Events table).
EvChildOrder Order of the event that the record pertains to (e.g., 0 = pickup, 1 = dropoff).
EvParent Numeric identifier of the group of events. Pick-ups and drop-offs have their own EvID but share the EvParent ID to link them together.
EvClass String that indicates the event type (e.g., Pullout, Break).
EvStrId Internal numeric identifier of the live run that the event is on (from the EventStrings table).
ReqTime Requested event time (e.g., requested time of a pick-up). Value is in seconds from midnight.
ReqEarly Earliest requested time that the trip event can be performed. Value is in seconds from midnight.
ReqLate Latest requested time that an event can be scheduled. Value is in seconds from midnight.
SchTime Time for which the event is or was actually scheduled. Value is in seconds from midnight.
SchEarly Actual earliest time when the trip event can be performed. Calculated by the Schedule Server. Value is in seconds from midnight.
SchLate Actual latest time when the trip event can be performed. Calculated by the Schedule Server. Value is in seconds from midnight.
EstTime Estimated time when the trip event will be performed. Calculated by the Schedule Server. Value is in seconds from midnight.
ETA Estimated arrival time of the trip event. Calculated by the Schedule Server. Value is in seconds from midnight.
ETD Estimated departure time of the trip event. Calculated by the Schedule Server. Value is in seconds from midnight.
OrigEstTime Original estimated time the trip event will be performed. Calculated by Schedule Server.
OrigETA Original estimated time of arrvial of the trip event. Calculated by Schedule Server.
OrigETD Original estimated time of departure of the trip event. Calculated by Schedule Server.
DwellTime Estimated time in seconds between the event arrival and departure. Calculated by the Schedule Server.
DwellLocked Deprecated.
DistMeters Distance to the next event (e.g., Break or Pick-up) in meters.
DistLocked Internal use only.
TravelTime Time required to travel between the current event and the next one in seconds.
TravelLocked Internal use only.
ClientId Numeric identifier of the client that the event is for (from the Clients table).
BookingId Numeric identifier of the booking (from the Bookings table).
LegId Numeric identifier of the leg (pickup or dropoff) (from the BookingLegs table).
Activity Flag that indicates what the event is for (0 = Pick-ups, 1 = Drop-offs).
LineDirId Hard-coded value for the direction of the line that the event is on (0 = outbound, 1 = inbound).
StopNum Stop number (from the Linestop table).
StopId Numeric identifier of the stop (from the Stops table).
SendStatus Numeric value that indicates the message status of the event (e.g., Sent, Pending).
SendFailure Numeric value for the reason that the message failed to be delivered (e.g., Timeout).
SentTime Time the message about the event was sent to the vehicle. Value is in seconds from midnight.
SchedStatus Numeric value that indicates the schedule status of the event (e.g., Unscheduled, Activated).
AddrName Building name of the event address (e.g., Sears Tower).
SiteName Site name of the event address (e.g., Downsview Park).
AddrType Alphanumeric identifier of the address type (from the AddressTypes table).
StreetNum Deprecated. (Numeric value of the event address.)
StreetNo Alphanumeric value of the event address.
OnStreet Street name of the event address.
AtStreet Cross-street or intersection closest to the event address.
Unit Unit number of the event address.
City City of the event address.
State State of the event address.
ZipCode Zip code or postal code of the event address.
AddressSummary UK use only.
MultimodalSignage Signage information for a multimodal stop (Line Abbr, Line Name, Line Dir Name).
MultimodalStopName Name of the multimodal stop.
MultimodalStopTime Scheduled stop time of the multimodal stop.
MultimodalStopNum Stop number of the multimodal stop.
MultimodalTripId Trip identification number of the multimodal trip.
MultimodalStopId Stop identification number of the multimodal stop.
RTPProductId Transportation network company string that identifies the trip within the TNC system.
RTPRideId Trip identification number from the transportation network company.
RTPMaxProviderCost Transportation network company's maximum estimated cost for the client's trip.
RTPMinProviderCost Transportation network company's minimum estimated cost for the client's trip.
RTPActualProviderCost Transportation network company's actual cost for the client's trip (provided after the trip).
RTPArrival Transportation network company's estimated arrival time.
RTPDuration Transportation network company's estimated trip time.
ZoneCode UK use only.
MapPage Page number of the event address (e.g., Page 12 of Perlys Maps).
Phone Phone number of the event address.
Lon Longtitude coordinate of event address.
Lat Latitude coordinate of the event address.
GeoStatus Numeric value of the geocoding status of the event longitude and latitude.
CellArea Map cell number from the map database (from the CellNo. field in the mapGRID table).
Violations String of hard-coded values for violations currently occurring for the event. Inserted by the Schedule Server.
PassOff Number of passengers (based on passenger type) exiting the vehicle at the event.
PassOn Number of passengers (based on passenger type) boarding the vehicle for the event.
SpaceOff Number of spaces freed up by the event.
SpaceOn Number of space required by the event.
EstTimeLock Flag for the Schedule Server that indicates the EstTime for the event cannot be changed when scheduling the event. Value is in seconds from midnight.
TimeStampNextETA Time that the ETA of the event that will immediately follow the AVL break was received from the MDT.
JoinLegId Deprecated.
TripId Numeric identifier of an itineray if the event is part of an itinerary booking.
EvOrder Internal use only.
ActualArriveTime Actual arrival time of the vehicle when performing the event. Value is in seconds from midnight.
ActualDepartTime Actual departure time of the vehicle when the event was performed. Value is in seconds from midnight.
IncidentCause Numeric identifier of the cause of the incident (from the Complaints module).
ActualLat Actual latitude coordinate recorded at the event location.
ActualLon Actual longitude coordinate recorded at the event location.
FxSequence Order of events for FX trips.
EstSlackTime Time not used between events (wait time) in seconds, excluding travel time (e.g., if if the next event is 20 minutes later but takes 10 minutes to get there, the slack would be 10 minutes/600 seconds).
ProviderCost Dollar amount of the fare for the trip that is covered by the provider.
FerryLineId Numeric identifier of the ferry line (from FerryLine.FerryLineId).
GarageId Numeric identifier of the garage of the vehicle performing the event (from the Garages table).
OldIncidentId Numeric identifier of another EventsOld record related to the same trip, booking, etc..
OldSendStatus Status of the sent message before the incident was recorded.
BlockId Numeric identifier of the FX block from the FxBlocks table.