MdtManifest
Name: MDT Manifest
Type: Application
Modules: Mdt
Description: Contains the information for trips, events to be sent to the vehicles, and their status.
| Field | Documentation |
|---|---|
| Sequence | Transmitter vendor-specific number of the position on the manifest of the event. Same idea as the EvOrder. |
| EvStrId | Internal numeric identifier of the live run that the event is on (from the EventStrings table). |
| BookingId | Numeric identifier of the trip booking associated with the trip. |
| MsgId | Numeric identifier of the message to be sent to the vehicle. |
| MdtId | Numeric identifier of the MDT device to receive the messages. |
| EvOrder | Numeric value that controls where and what postion in the run itinerary the event is. |
| SchId | Numeric identifier of the schedule date of the booking (from the Schedules table). |
| EvId | Numeric identifier of the event (from the Events table). |
| OldMsgId | Numeric identifier of the message that was sent for this event in case it needs to be resent. |
| TripStatus | Hard-coded value for the status of the event or trip (e.g., Arrived, New Trip Message, Supervisor Message). |
| MsgStatus | Hard-coded values for the status of a message that was sent or to be sent to a vehicle (e.g., Sent to Transmitter, Ignore, Pending). |
| MsgDate | Date the message was sent to the vehicle. |
| MsgTime | Time the message was sent to the vehicle. Value is in seconds from midnight. |
| Lon | Longitude coordinate of the trip's event. |
| Lat | Latitude coordinate of the trip's event. |
| IncidentId | Numeric identifier of the incident or the complaint that occurred during the event. |
| IsEventOld | Flag that indicates whether the event in the manifest should be ignored, even though it was already sent, cancelled, etc.. |
| LateTrip | Flag that indicates whether the event was late for Late Trip Analysis. |
| EvStatus | Hard-coded value for the status of the event or trip (e.g., Arrived, New Trip Message, Supervisor Message). |