The PtMS Mobile database specifications detail the format of the exchange of information between the PtMS for Windows SQL database and the Mobile Units system residing in the vehicles. A SQL database called "ptmsmobile" is installed on the PtMS file server.

A description of the PtMS Mobile database tables is listed below:

The Mobile_GPS table will only be receiving data from the Mobile units. PtMS Mobile applications software will use this data to display active vehicle movement for the dispatcher using the Streets mapping software GPS functions. Dispatchers will be able to view vehicle movement for selected or all vehicles as needed.

The Mobile_ToMDT table will be updated by the PtMS for Windows Scheduling and Dispatching software. Next day schedule records will be loaded to this table starting at a time set by the user in the PtMS Mobile application software parameter table. Once this time is reached all schedule record and any changes in scheduler records for the next day will be sent to this table. Each time a change occurs in a PtMS schedule record in PtMS, a new record will be added to Mobile_ToMDT table with the changed field information. All changes to schedule records occurring during the day of service (i.e. today) will be sent to this table.

The Mobile_FromMDT table will contain records with data updates received from the MDTs. Fields that are updated by the MDT are preceded by "MDT" in the field name column. Data received by the MDT will be used to update the PtMS Schedule records for dispatching. It will then be posted into the PtMS TripTransactions table and VehicleServicesSummary table for reporting purposes. Updates to the PtMS Dispatching module will allow dispatchers to monitor change in trip status, arrival times, departure times, etc as they are occurring and received from the MDTs.

The Mobile_Comm table will contain dispatch messages sent to the vehicle/MDT by the dispatcher and messages received from the dispatchers. The PtMS Dispatch application will have provide the dispatcher with the user interface to both send messages to the vehicle/MDT and view messages received from the vehicle/MDT.