InAvl
Name: In AVL
Type: Application
Modules: MDT
Description: Dynamic table that holds the whereabouts of vehicles. Updated by MDT Server when messages received from vehicles.
| Field | Documentation |
|---|---|
| MdtId | Numeric identifier of the MDT device assigned to a vehicle. |
| Lat | Latitude coordinate of the device location. |
| Lon | Longitude coordinate of the device location. |
| Direction | Direction in which the device is traveling. |
| MsgDate | Date the AVL message was received from the MDT device. |
| MsgTime | Time the AVL message was received from the MDT device. Value is in seconds from midnight. |
| Speed | Speed that the device was traveling when the message was received from the MDT device. Value is in kilometers per hour (km/h). |
| EvStrId | Event string ID of the run associated with the vehicle that sent the AVL message. |
| CreDate | Date the AVL message was created. |
| CreTime | Time the AVL message was created. Value is in seconds from midnight. |
| NextETA | Amount of time before the next event, based on the MDT location information. |
| NextEvId | Identification number of the next event (e.g., pick-up, drop-off, break). |
| ETATimeStamp | Time the ETA AVL message was received from the MDT device. |
| BookingId | Numeric Identifier of the booking that was scheduled to the current run associated with the vehicle. |
| Id | The unique id of the InAvl rows. |