ITSMessageData
Name: ITS Message Data
Type: Application
Description: Stores message data sent and received by mobile units. Event message data is server-generated as a result of vehicle status (i.e. Off-route).
| Field | Documentation |
|---|---|
| CalendarDate | Message datestamp. |
| MsgType | Message type (e.g., 100=VDCadApcData). Values for MsgType are defined ITSMsgDefinition. |
| MsgId | Message identifier for the message. This is for acknowledgement (i.e., ACKing). |
| MsgTime | Message time stamp. Value is in seconds from midnight. |
| VehicleId | Mobile unit ID (MdtId) of the message's source or destination. |
| DstUnitId | Destination mobile unit ID. (MdtId) used for dispatching vehicle messages. |
| BlockId | Block identifier from FXBlocks.BlockId. Regarding fixed-route messages containing schedule data (e.g. VDCadTpc). |
| DriverId | Driver identifier from Employee.BadgeNum (for VDCadLogin) or Employees.DriverId (for MMS data) or CmnEmployees. DriverId (for CMN data). Regarding fixed-route messages containing schedule data (e.g. VDCadTpc) |
| LineId | Line identifier from MasterLine.LineId. Regarding fixed-route messages containing schedule data (e.g. VDCadTpc). |
| RunId | Run identifier from MasterRun.RunId. Regarding fixed-route messages containing schedule data (e.g. VDCadTpc). |
| ServiceId | Service Identifier from Service.ServiceId. Regarding fixed-route messages containing schedule data (e.g. VDCadTpc). |
| SignId | Sign-up period identifier from SignUpPeriods.SignId. Regarding fixed-route messages containing schedule data (e.g. VDCadTpc). |
| StopId | Stop identifier from Stops.StopId. Regarding fixed-route messages containing schedule data (e.g. VDCadTpc). |
| TripId | Trip identifier from Trips.TripId. Regarding fixed-route messages containing schedule data (e.g. VDCadTpc). |
| ActualArrive | Timestamp of the vehicle entering the arrival zone. Value is in seconds from midnight..Regarding fixed-route VDCadTpc/VDCadStopData messages. |
| ActualDepart | Timestamp of the vehicle leaving departure zone. Value is in seconds from midnight. Regarding fixed-route VDCadTpc/VDCadStopData messages. |
| PassOn | APC (Automated Passenger Count) reported boardings at the stop. Regarding fixed-route VDCadApcData. |
| PassOff | APC (Automated Passenger Count) reported alightings at the Stop. Regarding fixed-route VDCadApcData. |
| Lat | GPS recorded latitude coordinate of the mobile device. |
| Lon | GPS recorded longitude coordinate of the mobile device. |
| Odometer | Distance travelled in meters; calculated by using the initial odometer reading at startup or setting at login. |
| Adherence | Adherence to schedule (if logged into a valid block). This is measured in seconds. Negative values indicate the time is behind schedule, positive values indicate the time is ahead of schedule. |
| CompassDirection | Last known calculated direction at time of message (i.e. N, NE, E, SE, S, SW, W, NW). |
| Speed | Last known calculated speed at time of message. Value is in kilometers per hour (km/h). |
| Flags | Bit-wise value (offRoute = -x01; deadHead = 0x02; GPS-generated = 0x04). |
| Flag1 | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information - VDVehicleStarted: unitType (Fixed-route = 100000; Paratransit = 110000); VDCallComplete: voiceMsgId (identifier of initial DVSTVC); VDCadRobustLocation: AltitudeMeters; VDCadResponse: responseId; VDCommReport: lastSendTime; VDCadApcData: Initialload; DVCadAnnunciator: annunceId |
| Flag2 | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information - VDVehicleStarted: routeVersion (fx signId); VDCallComplete: timeout (from original DVSTVC); VDCannedMsg: category; VDCommReport: rcvTime; VDCadApcData: stopNum; VDCadTpcEvent: stopNum; VDCadWheelChair: stopNum... |
| Flag3 | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information (e.g. VDCadApcData: sequence (trip sequence)) |
| Flag4 | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information (e.g. VDCadApcData: currentOn) |
| Flag5 | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information (e.g. VDCadTpcEvent: eventActivity) |
| Flag6 | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information (e.g. VDCadApcData: patternId) |
| Flag7 | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information (e.g. VDCadApcData: directionId) |
| flag8 | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information (e.g. VDCadApcData: nodeId) |
| FromLat | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information (e.g. VDCadTpcEvent: gps of actual crossing) |
| FromLon | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information (e.g. VDCadTpcEvent: gps of actual crossing) |
| IncidentReportId | Internal use only |
| DispatcherId | Internal use only |
| EventMsgText | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information. |
| MsgText | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information |
| MsgText2 | Msg Type specific. See ITSPopulateDefaults.sql for more detailed information |
| PlaybackText | Complete XML message string |