OutTrip
Name: Out Trip Type: Application
Modules: Mdt Server
Description: Contains all messages to be sent to vehicles, conditions and constraints of each, and their current status.
| Field | Documentation |
|---|---|
| EvStrId | Internal numeric identifier of the live run that the event is on (from the EventStrings table). |
| MsgId | Numeric identifier of the message. |
| MsgType | Hard-coded, numeric value of the message type (e.g., AVL, Command, Trip). |
| MdtId | Numeric identifier of the MDT device assigned to the run. |
| EvId | Numeric identifier of the event (from the Events table). |
| IncidentId | Numeric identifier of the incident or complaint that occurred during the event. |
| TripStatus | Hard-coded, numeric value for the current trip's status (e.g., TripChanged, Arrived, Performed). |
| MsgDate | Date the message in the record will be or has been sent. |
| MsgTime | Time the last entry was made to the record. Value is in seconds from midnight. |
| DueTime | Time the message must be sent to the vehicle. Value is in seconds from midnight. |
| DeliveryTime | Time the message was actually delivered to the vehicle. Value is in seconds from midnight. |
| MsgStatus | Hard-coded, numeric value for the status of the message (e.g., Sent, Pending). |
| SchId | Numeric identifier of the schedule date of the booking (from the Schedules table). |
| EvOrder | Order in which the event will be performed on the manifest. |
| BookingId | Numeric identifier of the booking (from the Booking table). |
| Priority | Flag that indicates whether the message to be sent out has high priority. High priority messages are sent first. |
| Comments | Comments about the record. |
| MachineName | Name of the device that sent or received the message. |
| IsEventOld | Flag that indicates the record is no longer valid because it has been superceded by another record or event. |
| IncdEvent | Numeric identifier of the incident that supercedes the record (e.g., cancelling a trip adds a new record, the original record for the trip pick-up is flagged as old, and the new record's incident ID is used). If there is no overwriting incident, the original incident ID is used. |
| EvStatus | Hard-coded values for the event class (e.g., Bulk, Break, Pullin). |