The Motive Analytics data model organizes key reporting fields into categories. Each data field includes a description of its purpose and how it can be used to analyze fleet performance and compliance.
Compliance
| Data Field | Description |
| Log Waiting Hours | The total recorded hours a driver spent waiting, typically at a stop or terminal, before resuming activity. |
| Logs | The total count of recorded driver logs. |
| Form and Manner Errors | A detailed record of compliance-related errors in driver logs, such as missing signatures or incorrect entries. |
| Log Driving Hours | The total recorded hours a driver spent in driving status according to their log records. |
| Log Violation Rate | The percentage of logs containing violations, calculated as violations divided by count of selected logs. |
| Hour of Service Violation End Time | The recorded timestamp indicates when a driver's Hours of Service (HOS) violation ended. For date and time, include the keyword "detailed" in your data search. |
| Hours of Service Violation Duration (hours) | The total duration, in hours, of a driver's Hours of Service (HOS) violation. |
| Log Off Duty Hours | The total recorded hours a driver spent in off-duty status according to their log records. |
| Hours of Service Violations | The count of instances where a driver exceeded legally permitted driving hours or failed to meet required rest periods, as defined by Hours of Service regulations. |
| Hour of Service Violation Start Time | The recorded timestamp indicates when a driver's Hours of Service (HOS) violation began. For date and time, include the keyword "detailed" in your data search. |
| Logs with Form and Manner Errors | The total number of logs containing at least one form and manner error. |
| Log Start Time | The recorded timestamp indicates when a driver’s log period began. For date and time, include the keyword "detailed" in your data search. |
| Log On Duty Hours | The total recorded hours a driver spent in on-duty status, excluding driving, according to their log records. |
| Log Sleeper Hours | The total recorded hours a driver spent in sleeper berth status according to their log records. |
| Log Note | Note entered on the driver's log by a fleet user. This column does not include any coaching summary notes, only on individual driver's logs. |
| Log Cycle | The designated cycle of driving and rest periods a driver follows, based on regulatory requirements. |
| Form and Manner Error Type | A detailed description of errors related to form and manner compliance. |
| Log Violations | The number of violations present in the log. |
| Hours of Service Violation Type | A detailed description of errors related to Hours of Service compliance. |
| Log Violations List | A detailed array of all log violations present in each log. |
Fuel
| Data Field | Description |
| Idling Events | The number of times a vehicle remained stationary with the engine running for an extended period, contributing to fuel consumption and emissions. |
| Idling Event End Time | The recorded timestamp indicates when an idling event ended. For date and time, include the keyword "detailed" in your data search. |
| Idling Fuel Consumed per Vehicle | The amount of fuel consumed per vehicle during idling events within a selected timeframe. |
| Idling Duration (formatted) | The total duration of idling events, displayed in a readable time format. |
| Idling Duration per Vehicle (minutes) | The average idling duration per vehicle, measured in minutes. |
| Idling Event Start Time | The recorded timestamp indicates when an idling event began. For date and time, include the keyword "detailed" in your data search. |
| Idling Duration (minutes) | The total duration of idling events, measured in minutes. |
| Idling Fuel Consumed | The total amount of fuel consumed during idling events, measured in gallons or liters depending on your account preferences. |
| PTO Idling (in minutes) | Duration in minutes the vehicle's power take-off (PTO) was engaged while the engine was idling. |
| Non PTO Idling (in minutes) | Duration in minutes the vehicle's engine was idling without the power take-off (PTO) being engaged. |
| Idling without PTO percentage | The percentage of total idle time that occurred without PTO engagement. Formula: (Non-PTO Idling Hours / Total Idle Hours) * 100 |
| Idling City | The city where the idling event occurred. |
| Idling State | The geographical state where the idling event occurred. |
| Idling Event Latitude | The latitude of a vehicle's location when the idling event occurred. |
| Idling Event Longitude | The longitude of a vehicle's location when the idling event occurred. |
General
| Data Field | Description |
| Unique Vehicles | The total count of distinct vehicles associated with the recorded data set. |
| Date | The universal date for the recorded event or activity. For date and time, include the keyword "detailed" in your data search. All times are localized to your timezone. Default to this unless minute or second level precision is needed. |
| Explicit User Group Member | Indicates whether the user was explicitly assigned to this group (otherwise we consider a user to be a member of all of the parent groups they were assigned to, even if they were not explicitly assigned to those parent groups) |
| Explicit Vehicle Group Member | Indicates whether the vehicle was explicitly assigned to this group (otherwise we consider a vehicle to be a member of all of the parent groups they were assigned to, even if they were not explicitly assigned to those parent groups) |
| User Group Depth | The number of levels down in the hierarchy that the User Group Name is located. For example, in the User Group Path "North America -> California -> Los Angeles", the User Group Name, Los Angeles, is at a User Group Depth of 3. |
| User Group Path | A flattened view of the group hierarchy between the highest-level User Parent Group Name and the lowest-level User Group Name. For example: "North America -> California -> Los Angeles". |
| User Parent Group Name | The name of the parent group that's one hierarchical level above the selected User Group Name. For example, User Group Name is Los Angeles and Parent Group Name is California. |
| Vehicle Group Depth | The number of levels down in the hierarchy that the Vehicle Group Name is located. For example, in the Vehicle Group Path "North America -> California -> Los Angeles", the Vehicle Group Name, Los Angeles, is at a Vehicle Group Depth of 3. |
| Vehicle Parent Group Name | The name of the parent group that's one hierarchical level above the selected Vehicle Group Name. For example, Vehicle Group Name is Los Angeles and Parent Group Name is California. |
| Vehicle Group Path | A flattened view of the group hierarchy between the highest-level Vehicle Parent Group Name and the lowest-level Vehicle Group Name. For example: "North America -> California -> Los Angeles". |
| Vehicle Year | The year in which the vehicle was manufactured. |
| Vehicle Gateway ID | The unique identifier assigned to each Vehicle Gateway device. |
| User Email Address | The email address associated with the user. |
| User ID | The unique identifier assigned to each Motive user. |
| Weight Class | The classification of a vehicle based on its weight. |
| Fleet Account Name | The name of the company. |
| Fleet Account Id | The unique identifier assigned to each Motive customer account. |
| User Full Name | The full name of the user as displayed in Motive. This includes both `driver` and `dispatcher` users. To filter by role, use the User Role column. |
| User Role | The role the user is assigned to either `dispatcher` or `driver`. |
| Vehicle ID | The unique identifier assigned to each vehicle. |
| Vehicle Make | The manufacturer of the vehicle. |
| Vehicle Model | The model of the vehicle. |
| Vehicle License Plate Number | The unique combination of letters and numbers that identifies a vehicle. |
| Vehicle Fuel Type | The type of fuel used by the vehicle, such as gasoline, diesel, electric, or hybrid. |
| Vehicle Gateway Status | The status of the Vehicle Gateway, indicating its current condition, such as allocated, in transit, or inactive. |
| Dashcam Connection Status | The status of the dashcam connection, indicating whether it is connected or disconnected. |
| Vehicle Group Name | The name of the group to which the vehicle belongs. Each vehicle assigned to a sub-group is also a member of the parent groups within the group hierarchy. If you want to only view vehicles that have been assigned to a specific sub-group, include the keyword "is explicit group member" in your data search. |
| User Group Name | The name of the group to which the user belongs. Each user assigned to a sub-group is also a member of the parent groups within the group hierarchy. If you want to only view users that have been assigned to a specific sub-group, include the keyword "is explicit group member" in your data search. |
| Safety Event Coached By User Name | The name of the user who provided coaching to the driver involved in the safety event. |
| User Status | The current status of the user. One of either 'active' or 'deactivated' |
Maintenance
| Data Field | Description |
| Fault Code Last Observed At | The date and time when the fault code was last detected. |
| Fault Code First Observed At | The date and time when the fault code was first detected. |
| Fault Code Network | Common protocols/networks over which DTC codes are communicated. |
| Fault Code | A unique identifier for a specific vehicle issue detected by the Motive device |
| Fault Code Description | A brief explanation of the issue indicated by the fault code. |
| Fault Code Status | Indicating the current state of the fault code, as open or closed. |
| Fault Code Type | A classification indicating if the fault code is intermittent or constant. |
| FMI Code | A numeric identifier providing additional details about the fault type. |
| FMI Description | A description explaining the nature of the issue associated with the FMI code. |
| Fault Code Source | The component or system that reported the fault code. |
Safety
| Data Field | Description |
| Speeding Events | The total count of instances where a vehicle exceeded the posted speed limit beyond the defined threshold. |
| Safety Event Start Time | The recorded timestamp indicates when a safety event began. |
| Speeding Event Minimum Speed Limit | The lowest posted speed limit recorded for a specific location or segment of a trip. |
| Speed Threshold | The defined speed value used to determine when a speeding event is triggered. |
| Percent Coached Safety Events | The percentage of coachable safety events that have been addressed through coaching, indicating coaching completion rate. |
| Speeding Event Maximum Speed Over Limit | The highest recorded speed above the posted limit during a speeding event. |
| Safety Score Compute Week | The specific week in which a safety score was calculated. |
| Safety Events per 1,000 mi (or km) | The number of recorded safety events normalized per 1,000 miles (or kilometers) traveled, providing a standardized risk measure. |
| Speeding Event Average Speed Over Limit | The average amount by which a vehicle exceeded the posted speed limit during a speeding event. |
| Speeding Event Maximum Speed Limit | The highest posted speed limit recorded for a specific location or segment of a trip. |
| Safety Events | The total count of recorded safety-related incidents. |
| Coached Safety Events | The count of safety-related incidents where coaching has been completed. |
| Safety Event Duration (seconds) | The total duration of a recorded safety event, measured in seconds. |
| Safety Event Driver Review Timestamp | The timestamp indicates when a driver reviewed a recorded safety event. |
| High Risk Safety Events | The count of severe safety incidents classified as high or critical risk, requiring immediate attention and intervention. |
| Coachable Safety Events | The count of safety-related incidents that have been identified as opportunities for coaching to improve driver performance. |
| Safety Event Max Speed | Maximum speed of the vehicle during the safety event. |
| Safety Event Avg Speed | Average speed of the vehicle during the safety event. |
| Safety Event Speed Limit | The speed limit at the location of the safety event. |
| Safety Event Note | Note entered on the safety event by a fleet user. This column does not include any coaching summary notes, only on individual safety events. |
| Safety Event Time To Coach (minutes) | The time elapsed, measured in minutes, between when a coachable safety event occurred and when coaching was conducted. |
| Safety Score Date Range | The date range for the safety score calculation, segmented into four-week periods. |
| Speeding Event End Latitude | The latitude where the vehicle was located at the end of the speeding event. |
| Fleet Safety Score | The overall safety performance score for a fleet, reflecting a combination of various driving behaviors and safety metrics. |
| Driver Safety Score | The overall safety performance score for a driver, reflecting a combination of various driving behaviors and safety metrics. |
| Safety Event Coached At | The date at which the safety event was coached. For date and time, include the keyword "detailed" in your data search. All time fields are localized to your time zone. |
| Speeding Event End Longitude | The longitude of a vehicle's location at the end of the speeding event. |
| Speeding Event Start Latitude | The latitude where the vehicle was located at the start of the speeding event. |
| Speeding Event Start Longitude | The longitude where the vehicle was located at the start of the speeding event. |
| Speeding Event Disputed Status | The status of a speeding event, indicating whether it has been disputed or remains uncontested. |
| Safety Event City | The city where the safety event occurred. |
| Safety Event State | The geographical state where the event occurred. |
| Safety Event Coaching Status | The current status of coaching for a safety event, indicating whether the user has been coached for this event. |
| Safety Event Type | The type of behavior that triggered the safety event. |
| Safety Event Latitude | The latitude of a vehicle's location when the safety event occurred. |
| Safety Event Longitude | The longitude of a vehicle's location when the safety event occurred. |
| Safety Event Risk Level | The severity level of the safety event. |
Telematics
| Data Field | Description |
| Geofence Detention Start Time | The recorded timestamp indicates when a vehicle's detention within a geofence began. For date and time, include the keyword "detailed" in your data search. |
| Geofence Visits | The count of times the geofence has been visited by a vehicle or asset. |
| Average Trip Speed | The average trip speed in miles per hour (MPH) or kilometers per hour (KPH) depending on your user preference settings. |
| Trips | The total count of recorded trips taken by a vehicle or driver during a select period of time. |
| Trip End Time | The recorded timestamp indicating when a trip ended. For date and time, include the keyword "detailed" in your data search. All time fields are localized to your time zone. |
| Geofence Detention End Time | The recorded timestamp indicates when a vehicle's detention within a geofence ended. For date and time, include the keyword "detailed" in your data search. |
| Unidentified Trips | The count of trips with no assigned driver, typically due to missing or unverified log data. |
| Trip Duration (formatted) | The total duration of a trip, displayed in a readable time format. |
| Trip Start Time | The recorded timestamp indicates when a trip began. For date and time, include the keyword "detailed" in your data search. All time fields are localized to your time zone. |
| Geofence Detention Distance Traveled | The total distance a vehicle moved within a geofence. |
| Geofence Detention Duration (formatted) | The total duration of vehicle detention within a geofence, displayed in a readable time format. |
| Trip Duration (minutes) | The total duration of a trip, measured in minutes. |
| Trip Distance | The trip distance is in miles or kilometers depending on your user preference settings. |
| Geofence Detention Duration (minutes) | The total duration of vehicle detention within a geofence, measured in minutes. |
| Active Days | The total number of days the vehicle's engine was on, either while moving or idling. Note: Requires Fleet Vehicle ID or Vehicle ID to be specified in the query. |
| Trip Annotation Status | Indicates the annotation status of the trip. Can be 'annotated', 'pending annotation', or 'not annotated.' |
| Trip End Address | The end address of the trip. |
| Trip Start Address | The start address of the trip. |
| Trip End Lat | The latitude where the vehicle was located at the end of the trip. |
| Trip Start Lat | The latitude where the vehicle was located at the start of the trip. |
| Trip Start City | The city where the vehicle was located at the start of the trip. |
| Trip Start State | The geographical state where the vehicle was located at the start of the trip |
| Trip End City | The city where the vehicle was located at the end of the trip |
| Trip End State | The geographical state where the vehicle was located at the end of the trip |
| Geofence Detention Engine Hours | The engine hours recorded by the vehicle inside the geofence boundary. |
| Geofence Address | The physical address linked to the geofence, determined by the center point of its boundary. |
| Geofence Description | The description of the geofence. |
| Geofence Category | The assigned category used to classify and organize each geofence. |
| Geofence Name | The name of the geofence. |
| Geofence Status | The current status of the geofence, such as activated or deactivated. |
| Trip Status | The status of the trip, such as driving or completed. |
| Trip Type | The type of trip, such as driving, yard move, or personal conveyance. |
| Trip Start Lon | The longitude where the vehicle was located at the start of the trip. |
| Trip End Lon | The longitude where the vehicle was located at the end of the trip. |
Was this article helpful?
Share this with others