MdtMessageLog

Description: Contains all messages sent and received from vehicles and to vehicles from and to the Mdt Server.

Field	Documentation
MdtId	Numeric identifier of the MDT device on the vehicle.
EmployeeId	Numeric identifier of the employee (driver) from the employees table to whom the vehicle or MDT device was assigned.
CoEmployeeId	Numeric identifier of the employee (co-driver, assistant, etc) from the employees table who has also been assigned to the vehicle or MDT device.
Comments	Comments generated by the system about the message (e.g., Vehicle ACK for EvID:123, A renew request from the driver, etc.).
LoginName	Username of the employee who logged into the MDT device.
TimeLogged	Time when the message was received. Value is in seconds from midnight.
DateLogged	Date when the message was received.
WorkDescription	For internal use.
SchId	Numeric identifier of the schedule date of the booking from Schedules table.
EvId	Numeric identifier of the event that the message is about from the Events table.
IncidentId	Numeric identifier of the incident or complaint that occurred during the event.
EvStrId	Internal numeric identifier of the live run that the event is on from the EventStrings table.
EvStrName	Name of the run from the EventStrings table.
CommentText	For internal use.
StopId	Numeric identifier of the stop from the Stops table at which the event occurs.
Channel	Radio Channel used for Requests to Talk between Dispatch and Driver