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 the 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. It only includes notes 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. |
| Total Distance | Total distance traveled in the selected Distance Unit (km or mi) for motion-type fuel events. It converts from kilometers to miles using the 0.621371 factor when needed. |
| Driving Fuel | Total fuel consumed in the selected Fuel Volume Unit (l or gal) during motion-type fuel events Converts liters to gallons using the 0.264172 factor when needed |
| Total Fuel | Total fuel consumed in gallons across motion and idle events Converts liters to gallons using the 0.264172 factor |
| Idled Fuel | Estimated fuel consumed (gallons) during idle events, converted from approx. fuel liters (nulls defaulted to 0) using factor 0.264172 L to gal |
| Average Fuel Economy | Average miles per gallon, calculated as total distance miles divided by total fuel gallons Returns null when fuel is zero |
| Moving Fuel Economy | Miles per gallon during motion only, calculated as total distance miles divided by motion fuel consumed gallons Returns null when motion fuel is zero |
| Expected Fuel Economy | Average MPG for all vehicles sharing the same make, model, year, and fleet account REQUIRED: Vehicle Make, Vehicle Model, and Vehicle Year must be included as dimensions in the answer - without them the peer group collapses to fleet-level average Returns null when total fuel is zero |
| Fuel Economy Difference | Difference between actual average fuel economy and the expected fuel economy A negative value indicates the vehicle is underperforming its target; a positive value indicates it is exceeding expectations |
| Estimated Fuel Wasted | Fuel wasted beyond the expected consumption threshold, displayed in liters or gallons based on the Fuel Volume Unit parameter |
| Inefficiency Cost ($) | Estimated USD cost of fuel wasted due to a vehicle performing below its MMY fleet benchmark MPG Calculated as fuel wasted gallons multiplied by avg fuel price per gallon Returns 0 when the vehicle meets or exceeds benchmark; returns null when expected MPG is zero Requires Vehicle Make, Vehicle Model, and Vehicle Year as dimensions for correct MMY-level benchmarking |
| Utilization (%) | Percentage of engine-on time spent driving or productively idling Calculated as (driving + productive) / (driving + idling) * 100 Returns null when total engine-on time is zero |
| Over RPM (%) | Percentage of driving time spent over the recommended RPM threshold Returns null when driving time is zero |
| Cruise Distance (%) | Percentage of total distance miles driven with cruise control on References Total Distance Miles formula Returns null when total distance is zero |
| Cruise Time (%) | Percentage of driving time spent with cruise control on References Driving Time Hours formula Returns null when driving time is zero |
| Average Speed | Average speed in miles per hour during motion events, calculated as total distance miles divided by driving time hours Returns null when driving time is zero |
| Driving Time | Total time spent in motion-type fuel events in the selected Time Unit (h or min) |
| Idling Time | Total hours spent in idle-type fuel events |
| Estimated Carbon Emissions (LBS) | Estimated CO2 emissions in pounds using IPCC per-liter factors (gasoline 2.34769 kg/L, diesel 2.68927 kg/L) converted to lbs Sums fuel consumed and approx. fuel liters per row, branching by fuel type |
| Hard Braking Events per 1,000 Distance Units | Number of hard braking events per 1,000 miles traveled |
| Hard Acceleration Events per 1,000 Distance Units | Number of hard acceleration events per 1,000 miles traveled |
| Hard Cornering Events per 1,000 Distance Units | Number of hard cornering events per 1,000 miles traveled |
| Number of Open Fault Codes | Count of distinct fault codes with status open |
| Total Fuel Purchased | Total volume of fuel purchased in liters, normalized across mixed-unit transactions - gallons converted to liters using factor 0.264172; returns null when the unit is neither ltr nor gal |
| Fuel Purchase Quantity | Fuel quantity per event in liters or gallons based on the selected unit preference |
| Fuel Purchase Volume | Total fuel purchased in liters or gallons based on the Fuel Volume Unit parameter |
| Fuel Purchase Odometer | Odometer reading at fuel purchase in kilometers or miles based on the selected unit preference |
| Average Fuel Price per Unit | Average fuel cost in USD per gallon for the period, derived from event-level cost divided by total fuel liters converted to gallons Uses fleet-specific weekly price with government price as fallback |
| Fuel Cost (USD) | Estimated fuel cost in USD for the event, calculated as total fuel liters multiplied by the fleet-specific or government weekly price per liter |
| Fuel Purchase Cost | Total cost of the fuel purchase in the transaction currency (raw currency, not normalized to USD - do not sum across currencies) |
| 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 time zone Default to this unless minute or second level precision is needed |
| Fuel Purchased At | Timestamp of fuel purchase |
| Total Distance Range | Groups total distance traveled into ranges: under 100, 100-250, 250-500, and 500 or more distance units Respects the Distance Unit setting (km or mi) |
| Vehicle with Fuel Data | True when the vehicle has reported fuel consumption data in the trailing 180 days |
| Is Flagged Purchase | True when the fuel purchase has been flagged as a potential theft |
| Fuel Purchase Source | Source system or method used to record the fuel purchase |
| Fuel Event Type | Type of fuel event (motion, idle, or PTO) |
| Fuel Purchase Jurisdiction | US state or jurisdiction code where the fuel was purchased |
| Fuel Purchase Type | Type of fuel purchased (e.g., diesel, gasoline) |
| Fuel Purchase Reference ID | Reference number for the fuel purchase transaction |
| Fuel Purchase Vendor | Name of the fuel vendor or station |
| 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 ID | The unique identifier assigned to each Motive user |
| User Email Address | The email address associated with the user. |
| User Role | The role assigned to the user is either `dispatcher` or `driver` |
| User Status | The current status of the user. Either 'active' or 'deactivated' |
| 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) |
| 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 |
| User Group Path | A flattened view of the group hierarchy between the highest-level (parent) and the lowest-level User Group Name |
| 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 ID | The unique identifier assigned to each vehicle |
| Vehicle Make | The manufacturer of the vehicle |
| Vehicle Model | The model of the vehicle |
| Vehicle Year | The year in which the vehicle was manufactured |
| Vehicle Vin Year | The customer-entered year in which the vehicle was manufactured |
| Vehicle Vin Make | Vehicle make enriched with NHTSA VIN decode data On NA, uses the decoded value when the VIN substring matches the NHTSA lookup; falls back to the raw customer-entered make when the VIN is absent or unmatched Always falls back to the raw make on EU targets where VIN decoding is not available Null for imputed (unidentified) vehicles |
| Vehicle Vin Model | Vehicle model enriched with NHTSA VIN decode data On NA, uses the decoded value when the VIN substring matches the NHTSA lookup; falls back to the raw customer-entered model when the VIN is absent or unmatched Always falls back to the raw model on EU targets where VIN decoding is not available Null for imputed (unidentified) vehicles |
| Vehicle Fuel Type | Type of fuel the vehicle uses |
| Vehicle Weight Class | The weight class of the vehicle (1-8) based on the gross vehicle weight rating (GVWR), used to categorize vehicles from light-duty to heavy-duty trucks |
| Vehicle License Plate Number | The unique combination of letters and numbers that identifies a vehicle |
| Vehicle Status | Status of the vehicle |
| Is IFTA Enabled | indicates if IFTA is enabled for the vehicle |
| 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) |
| 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 |
| Vehicle Group Path | A flattened view of the group hierarchy between the highest-level (parent) and the lowest-level Vehicle Group Name |
| 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 |
| Fleet Account Name | The name of the company |
| Fleet Account Id | The unique identifier assigned to each Motive customer account |
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 time zone. 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 in. 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 assigned to the user is 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 |
Asset Alias | The name or alias of the asset |
Asset Model | The model of the asset |
Cost Amount | Cost of the maintenance service as entered by the fleet manager, in the fleet account's configured currency |
Currency | ISO 4217 currency code for the cost amount (e.g. USD, GBP, EUR) |
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 |
Driver Type | The driver type, such as 'ELD', 'Logs Not Required', or 'Electronic Logbook' |
Engine Hours | Vehicle or asset engine hours at the time of service |
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) |
Fleet Account Name | The name of the company |
Fleet Manager Name | Full name of the fleet manager who recorded the maintenance service |
Notes | Free-text notes recorded by the fleet manager at the time of service |
Odometer Kilometers | Vehicle or asset odometer reading at the time of service, in kilometers |
Reminder Service Date | Next scheduled service date, null if not yet triggered |
Reminder Service Name | Name of the reminder as configured in the fleet's schedule |
Reminder Service Type | Category of the maintenance service (e.g. Oil Change, Brakes, Tires) |
Reminder Status | Current reminder status - overdue, due_soon, or due_later |
Service Date | Date when the maintenance or service was performed |
Service Type | Service type for this maintenance reminder (e.g. Oil Change, 90 day inspection) |
Services | Service name as defined in the fleet's maintenance reminder configuration (e.g. FS Nashville LOF 22.5K) |
Status | Current reminder status computed by background job - one of overdue, due_soon, due_later, or null when no reminder is linked |
User App Version | App version (and platform) the user is using |
User Cycle Rule | The Log cycle rule description that applies to the user |
User Email Address | The email address associated to the user |
User Full Name | The full name of the user as displayed in Motive. This includes both |
User Group Depth | The number of levels down in the hierarchy that the User Group Name is located |
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 |
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 |
User ID | The unique identifier assigned to each Motive user |
User Joined At | Timestamp of when the user was created |
User Last Activity | Most recent activity timestamp across mobile and web (localized to your timezone) |
User License Number | Driver's license number prefixed with state |
User Parent Group Name | The name of the parent group that's one hierarchical level above the selected User Group Name |
User Role | The role the user is assigned to either |
User Status | The current status of the user. Either 'active' or 'deactivated' |
User Time Zone | The time zone setting for the user |
Username | Custom username configured for the fleet user at the time of user creation |
Vehicle Availability Status | Current availability status of the vehicle |
Vehicle Group Depth | The number of levels down in the hierarchy that the Vehicle Group Name is located |
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 |
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 |
Vehicle ID | The unique identifier assigned to each vehicle |
Vehicle License Plate Number | The unique combination of letters and numbers that identifies a vehicle |
Vehicle Make | The manufacturer of the vehicle |
Vehicle Model | The model of the vehicle |
Vehicle Model Year | Model year of the vehicle |
Vehicle Parent Group Name | The name of the parent group that's one hierarchical level above the selected Vehicle Group Name |
VIN | The unique Vehicle Identification Number used by the automotive industry |
Weight Class | The classification of a vehicle based on its weight |
Fleet Account Id | The unique identifier assigned to each Motive customer account |
Fleet User Member Group Ids | Array of group IDs the user is a member of, including parent groups via cascading membership |
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. |
Average Geofence Visit Duration (formatted) | The average time spent inside the geofence per visit, shown as hours, minutes, and seconds. Calculated as the mean of each visit's detention duration (total detention time divided by the number of visits) over the selected geofences and date range |
Average Geofence Visit Duration (in seconds) | The average time spent inside the geofence per visit, shown in seconds. Calculated as the mean of each visit's detention duration (total detention time divided by the number of visits) over the selected geofences and date range |
Geofence Exit Driver | The full name of the driver at the end of the detention period (exit driver). Only populated for completed detention periods |
Geofence Latitude | Latitude of the geofence, falling back to the polygon centroid when not set |
Geofence Longitude | Longitude of the geofence, falling back to the polygon centroid when not set |
Idling Duration in Geofence (in minutes) | The total idling duration during geofence detention periods, measured in minutes, excludes currently open detention periods |
Idling Fuel Consumed in Geofence | The total fuel consumed during idling within geofence detention periods (gallons or liters per account preference) |
Vehicle Currently Inside Geofence | Whether the vehicle is currently inside the geofence. It reflects data as of the last sync, so a vehicle that just exited may briefly still read true |
Vehicle Last Activity Time in Geofence | The latest time the vehicle exited the geofence. It reflects data as of the last sync, so a vehicle that just exited may briefly still read true |
Vehicle Time at Geofence Inventory (formatted) | The total time (in hours, mins and secs format) the vehicle spent inside this geofence across all visits in the selected range. In-progress visits are included, with their elapsed time counted up to the current time |
Vehicle Time at Geofence Inventory (in seconds) | The total time in seconds the vehicle spent inside this geofence across all visits in the selected range. In-progress visits are included, with their elapsed time counted up to the current time |
Face Match
| Data Field | Description |
Driver Identification Method | The method used to identify the driver for the trip |
Driver ID Feature Enablement Status | The enablement status of the driver identification feature for the trip |
Face Match Eligible Trip | The eligibility status of the trip for face match processing |
Face Match Request Status | The status of the face match request for a trip |
New Face Match Request | The creation of a new face match request for the trip |
Face Match Action Performed | The face match action performed for the trip |
Face Match Suggestion Status | The status of the face match suggestion for the trip |
Face Match Registered | The registration status of the trip in the face match system |
Face Match Failure Reason | The reason a face match attempt failed for a face match eligible trip |
Face Match Identification Familiarity | The identification of a familiar or unfamiliar driver profile for the trip |
Identification Confidence Level | The confidence level of the driver identification result |
Trip Assigned Via Face Match | The successful identification of a fleet user using face match for the trip |
Trip Assigned Via Driver App | The successful identification of a fleet user using the connected Driver App for the trip |
Face Match Profile ID | The identifier of the fleet user profile associated with the trip |
Trip Profile Status | The status of the fleet user profile associated with the trip |
Is Non-Company Driver | The classification of the identified driver as a non-company fleet user |
Face Match Location Data | The availability of location data for the face match trip |
Image Recall Pending | The pending state of the image recall process for the trip |
Camera Connection Status | The camera connection state for the trip |
Camera Obstruction Status | The camera obstruction condition for the trip |
Fleet User Profile ID | The unique identifier (primary key) for a face match profile |
Profile Status | The current status of the face match profile, for example, "Unfamiliar", "Identified", "Deleted", or "Merged" |
Profile Activity | Indicates whether the profile is active. Returns true if the profile status is not "Deleted" or "Merged"; otherwise, false |
Profile Familiarity Status | Whether the profile matches the fleet admin's "unfamiliar driver" definition. Returns "Unfamiliar" or "Familiar" |
Profile Linked To Driver | Whether the profile has been linked to a known driver |
Pseudo Profile | Whether the profile is a synthetic placeholder |
Driver ID Identified via Face Match | The driver linked to this profile. Values less than or equal to zero, or null, indicate an unfamiliar profile that has not been linked to a known driver |
Driver ID | The customer-assigned employee/badge alias of the driver linked to this profile. Null when the profile has not been linked to a known driver |
Driver Name | The full name of the driver linked to this profile. Null when the profile has not been linked to a known driver |
Profile Identified By | The full name of the fleet user who linked this profile to a driver |
Profile Identified Time | The time when this profile was linked to a driver |
Profile Created At | The time when this face match profile was created in the Face Match Profile ID service |
Non-Company Driver | Whether the driver linked to this profile is not a company employee (e.g., a contractor, vendor) |
Profile Latest Trip At | The start time of the trip behind this profile's most recent image, if applicable |
Profile Latest Vehicle ID | The fleet-assigned alias of the vehicle associated with this profile's most recent image |
Latest Vehicle ID | The identifier for the vehicle associated with this profile's most recent image |
Compliance Trip Driver Identification Method | The method used to identify the driver for the compliance trip |
Is Duplicate Driver | Whether the same driver (Fleet User) is linked to more than one Face Match Profile indicates possible profile duplication for a single driver. 'Yes' if true, else 'No' |
AI Coach
| Data Field | Description |
| AI Coached Behaviors | The list of driving behaviors highlighted in the AI recap. |
| AI Recap Review Status | The current review status of the AI recap. |
| Generated AI Recaps | The total number of AI recap videos generated. |
| Shared AI Recaps | Total AI recap videos shared via in-app or SMS notifications. |
| Reviewed AI Recaps | Total AI recap videos officially marked as reviewed by drivers. |
| Time to Review Recap (hours) | The duration (in hours) between sharing the recap and driver review. |
| AI Recap Review Rate | The percentage of generated recaps that have been reviewed. |
| AI Recap Created At | The timestamp indicating when the AI recap video was generated. |
| AI Recap Shared Time | The timestamp indicating when the recap was sent to the driver. |
| AI Recap Reviewed Time | The timestamp indicating when the driver reviewed the recap. |
Assets
Note: Assets data is currently only available in the United States and Canada.
| Data Field | Description |
| Asset Alias | The name or alias of the asset. |
| Assets Only | Use it to just filter on all the assets in a company. |
| 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 time zone. Default to this unless minute or second level precision is needed. |
| Geofence Entry Time | The timestamp indicating when the asset detention period started within a geofence. |
| Geofence Exit Time | The timestamp indicating when the asset detention period ended within a geofence. |
| Asset Length | The length of the asset in meters/ft. |
| Asset GAWR | The gross vehicle weight rating of the asset in kilograms/lbs. |
| Asset GVWR | The gross axle weight rating of the asset in kilograms/lbs. |
| Asset Motion Distance | The distance traveled by the asset while in motion, displayed in miles or kilometers based on the selected Distance Unit parameter. |
| Asset Detention Duration (minutes) | The total time in minutes an asset spent within a geofence, calculated from geofence entry to exit time (or current time if still inside). |
| Geofence Visits | The number of distinct geofence detention periods recorded for an asset i.e., how many times an asset entered and was tracked within a geofence. |
| AG Assigned At | The timestamp when an Asset Gateway was assigned to an asset, localized to the selected time zone. |
| AG Unassigned At | The timestamp when an Asset Gateway was unassigned from an asset, localized to the selected time zone. |
| Total Asset Gateways | The total count of unique Asset Gateways across all assignment states (both assigned and unassigned). |
| Assigned Gateways | The count of unique Asset Gateways that are currently assigned to an asset. |
| Current Assigned Asset | Current asset assigned to the gateway. |
| Last Assigned Asset | Last assigned asset to the gateway. |
| Asset Lifetime Distance Moved | Total distance moved till now by an asset. |
| Asset Engine Hours | The number of engine hours of the asset at the time of recording. |
| Asset Lifetime Engine Hours | The lifetime engine hours of the asset till now. |
| Asset Gateways Only | Use it to just filter on all the assets gateways in a company. |
| Total Assets | Total number of assets in a fleet. |
| Asset with Gateways | Total number of assets attached to gateways. |
| Asset without Gateways | Total number of assets not attached to gateways. |
| Asset Group Name | The name of the group to which the asset belongs. Each asset assigned to a sub-group is also a member of the parent groups within the group hierarchy. If you want to only view assets that have been assigned to a specific sub-group, include the keyword "is explicit group member" in your data search. |
| Explicit Asset Group Member | Indicates whether the asset was explicitly assigned to this group (otherwise we consider an asset 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). |
| Asset Group Depth | The number of levels down in the hierarchy that the Asset Group Name is located. For example, in the Asset Group Path "North America -> California -> Los Angeles", the Asset Group Name, Los Angeles, is at an Asset Group Depth of 3. |
| Asset Parent Group Name | The name of the parent group that's one hierarchical level above the selected Asset Group Name. For example, Asset Group Name is Los Angeles and Parent Group Name is California. |
| Asset Group Path | A flattened view of the group hierarchy between the highest-level Asset Parent Group Name and the lowest-level Asset Group Name. For example: "North America -> California -> Los Angeles". |
| Fleet Asset Member Group Ids | Array of groups the asset is a member of. Using the cascading model of group membership, where the asset is also a member of all parent groups to the groups it has been explicitly assigned to. |
| Geofence Address | Physical address of the geofence, based on centroid coordinates of the polygon. |
| Geofence Description | Description of the geofence entered by the Motive customer. |
| Geofence Category | Category name assigned to the geofence. |
| Geofence Name | Name of the geofence. |
| Geofence Status | Status of the geofence, if it is activated/deactivated. |
| Fleet Account Id | Unique identifier (primary key) for a Motive customer account. |
| Fleet Account Name | Name of the company. |
| Asset Make | The manufacturer of the asset. |
| Asset Model | The model of the asset. |
| Asset Model Year | The model year of the asset. |
| Asset Status | The current status of the asset. |
| Asset Ownership | The ownership status of the asset (Leased/Purchased). |
| Asset Subtype | The subtype of asset. |
| Asset Type | The type of asset. |
| Asset Vin | Vehicle Identification Number (VIN) of the asset. |
| Asset License | License plate information of the asset. |
| Asset Axles | The number of axles on the asset. |
| Asset Battery Percentage | The battery percentage of the asset at the time of recording. |
| Asset Motion Duration (seconds) | The duration in seconds that the asset was in motion during the recorded hour. |
| Firmware Version | The firmware version of the Asset Gateway device. |
| Asset Gateway Model | The hardware model of the Asset Gateway device. |
| Asset Gateway Name | Name of the Asset Gateway device. |
| Software Version | The current software package version of the Asset Gateway device. |
Beacon Assigned At | Beacon's latest assigned time to an asset |
Beacon Assignment Status | Current assignment status of beacon |
Beacon Dormancy Status | Beacon dormancy status |
Beacon First Ping At | First time beacon pinged |
Beacon First Ping Location | Formatted address where the first message from the beacon was recorded |
Beacon Identifier | Hardware identifier broadcast by the beacon device |
Beacon Last Ping At | Last time beacon pinged |
Beacon Last Ping Location | Formatted address where the most recent message from the beacon was recorded |
Beacon Model | The hardware model of the beacon device |
Beacon Ping Count | Total number of messages received from the beacon |
Beacon Unassigned At | Beacon's latest unassigned time from an asset |
Asset Last Drive Time | Last recorded time when asset completed a trip |
Asset Last Location | Last location of asset based on location of last trip |
Asset Trip Distance | Distance covered by asset during a trip |
Asset Trip Duration (formatted) | Time duration of the trip made by an asset |
Asset Trip Duration (secs) | Duration of the asset trip in seconds |
Asset Trip End Time | End time of asset trip |
Asset Trip Start Time | Start time of asset trip |
Asset Trips | Number of trips the asset made for the duration selected |
Next Trip Start Time | Start time of the next trip for the asset |
Trip End Address | End address of the asset trip |
Trip Start Address | Start address of the asset trip |
Trip User Full Name | Full name of the user associated with the trip, or 'Unidentified Driver' if unmatched |
Trip Vehicle Id | Display name of the vehicle paired to the asset during the trip |
Asset Currently Inside Geofence | Whether the asset is currently inside the geofence. It reflects data as of the last sync, so an asset that just exited may briefly still read true |
Asset Detention Duration (formatted) | The total time (in hours, mins and secs format) the asset spent inside this geofence across all visits in the selected range. In-progress visits are included, with their elapsed time counted up to the current time |
Asset Detention Duration (in seconds) | The total time in seconds the asset spent inside this geofence across all visits in the selected range. In-progress visits are included, with their elapsed time counted up to the current time |
Asset Last Activity Time in Geofence | The latest time the asset exited the geofence. It reflects data as of the last sync, so an asset that just exited may briefly still read true |
Asset Time at Geofence Inventory (formatted) | The formatted time (in days, hours, mins and seconds) the asset has spent at the geofence during a visit. For in-progress visits (asset still inside), the elapsed time is counted up to the current time |
Asset Time at Geofence Inventory (in seconds) | The time in seconds the asset has spent at the geofence during a visit. For in-progress visits (asset still inside), the elapsed time is counted up to the current time |
Average Geofence Visit Duration (formatted) | The average time an asset spends inside the geofence per visit, shown as hours, minutes, and seconds. Calculated as the mean of each visit's detention duration (total detention time divided by the number of visits) over the selected geofences and date range |
Average Geofence Visit Duration (in seconds) | The average time an asset spends inside the geofence per visit, shown in seconds. Calculated as the mean of each visit's detention duration (total detention time divided by the number of visits) over the selected geofences and date range |
Stationary Duration (formatted) | Stop level duration in "hrs, min, secs" format for which asset remain stationary until next trip |
Stationary Duration (secs) | Stop level duration in seconds for which asset remain stationary until next stop |
Total Stationary Duration (formatted) | Total duration in "hrs, min, secs" format for which asset remain stationary within the selected time range |
Total Stationary Duration (secs) | Total duration in seconds for which asset remain stationary within the selected time range |
Asset Gateway Last Active At | Last active time based on when asset gateway last pinged |
Asset Gateway Last Latitude | Most recent latitude reported by the asset gateway device |
Asset Gateway Last Longitude | Most recent longitude reported by the asset gateway device |
Asset Gateway Mode | Power mode of the asset gateway device |
Last Assigned Asset VIN | Vehicle Identification Number (VIN) of last assigned asset |
Average Geofence Visit Duration (in seconds) | The average time spent inside the geofence per visit, shown in seconds. Calculated as the mean of each visit's detention duration (total detention time divided by the number of visits) over the selected geofences and date range |
Geofence Exit Driver | The full name of the driver at the end of the detention period (exit driver). Only populated for completed detention periods |
Geofence Latitude | Latitude of the geofence, falling back to the polygon centroid when not set |
Geofence Longitude | Longitude of the geofence, falling back to the polygon centroid when not set |
Idling Duration in Geofence (in minutes) | The total idling duration during geofence detention periods, measured in minutes, excludes currently-open detention periods |
Idling Fuel Consumed in Geofence | The total fuel consumed during idling within geofence detention periods (gallons or liters per account preference) |
Vehicle Currently Inside Geofence | Whether the vehicle is currently inside the geofence. It reflects data as of the last sync, so a vehicle that just exited may briefly still read true |
Vehicle Last Activity Time in Geofence | The latest time the vehicle exited the geofence. It reflects data as of the last sync, so a vehicle that just exited may briefly still read true |
Vehicle Time at Geofence Inventory (formatted) | The total time (in hours, mins and secs format) the vehicle spent inside this geofence across all visits in the selected range. In-progress visits are included, with their elapsed time counted up to the current time |
Vehicle Time at Geofence Inventory (in seconds) | The total time in seconds the vehicle spent inside this geofence across all visits in the selected range. In-progress visits are included, with their elapsed time counted up to the current time |
Devices
Note: Devices data is currently only available in the United States and Canada.
| Data Field | Description |
| Date | The universal date for the recorded device status. For date and time, include the keyword "detailed" in your data search. All times are localized to your time zone. |
| Status From Time | Timestamp when the status/sub-status became active. |
| Status To Time | Timestamp when the status ended. For current record, it is current date/time. |
| User App Version | App version (and platform) the user is using. |
| User Last Activity | Most recent activity timestamp across mobile and web (localized to your time zone). |
| User License Number | Drivers license number prefixed with state. |
| Device Status | High-level device hub status. |
| Device Sub Status | Granular sub-status (e.g., "GPS Lost" under "Disconnected"). |
| Device Last Activity Time | Last timestamp when device became active. |
| Device Status Last Update Time | Timestamp when status of devices was last updated. |
| Vehicle Availability Status | Current availability status of the vehicle. |
| Device | Type of the devices based on the model. |
| Device Firmware Version | Current firmware version of the device. |
| Device Power Sources | List of power-sources attached to device. |
| Recommended Action | Recommended action based on device sub status and status. |
| Current Vehicle Battery Status | 'Low Vehicle Battery' when the connected Vehicle Gateway is healthy but inactive for more than 7 days and the vehicle's primary-source ignition voltage is below 10; otherwise NULL. |
| Is Current Status | Indicates whether this row represents the device's current (latest) status. |
| Device Type | Type of device (e.g. Vehicle Gateway, Dashcam). |
| Device Model | Hardware model of the device. |
| Device Serial Number | Serial number of the hardware device. |
| Last Recorded Vehicle Location | Nearest recorded vehicle location at or shortly before the status change. |
| Fleet Account Id | Unique identifier (primary key) for a motive customer account. |
| Fleet Account Name | Name of the company. |
| Vehicle ID | Alias assigned to the vehicle. |
| VIN | Vehicle identification number. |
| Vehicle Make | Make of the vehicle. |
| Vehicle Model | Model of the vehicle. |
| Vehicle Model Year | Model year of the vehicle. |
| License Plate Number | License plate number of the vehicle. |
| Driver Type | The driver type, such as 'ELD', 'Logs Not Required', or 'Electronic Logbook'. |
| Driver Full Name | Full name of the user. |
| User ID | Alias assigned to the user. |
| User Email Address | Email address of the user. |
| Username | Username of the user. |
| User Status | The current status of the user. One of either 'active' or 'deactivated'. |
| User Role | Role of the user. |
| User Cycle Rule | The Log cycle rule description that applies to the user. |
| User Time Zone | The time zone setting for the user. |
| User Joined At | Timestamp of when the user was created. |
| 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. |
| 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. |
| 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. |
| User Parent Group Name | The name of the parent group that's one hierarchical level above the selected User Group Name. |
| 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. |
| Vehicle Group Depth | The number of levels down in the hierarchy that the Vehicle Group Name is located. |
| Vehicle Parent Group Name | The name of the parent group that's one hierarchical level above the selected Vehicle Group Name. |
| 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. |
| Weight Class | Classification of a vehicle based on its weight. |
| Is Historical Record | True when device has history of changes in its status. |
| Geofence Name | Geofence name where device is currently present. |
Cards
Note: Cards data is currently only available in the United States.
| Data Fields | Description |
| Transaction Time | The time the transaction occurred. |
| Vehicle ID | The unique identifier assigned to each vehicle. |
| User Email Address | The email address associated with the user. |
| Transaction Amount USD | The transaction amount in US dollars. |
| Transaction Rebate USD | The rebate amount earned for the transaction in US dollars. |
| Transaction Missed Savings USD | The estimated missed savings amount in US dollars when not using a preferred merchant. |
| Transaction Gasoline Purchase Volume | The gasoline fuel quantity for the transaction, in gallons or liters. |
| Transaction Fuel Purchase USD | The total fuel purchase amount in US dollars. |
| Transaction Diesel Purchase Volume | The diesel fuel quantity for the transaction, in gallons or liters. |
| Transaction Avg Fuel Price | The average fuel price per liter in US dollars. |
| Transaction Total Fuel Purchase Volume | The total fuel volume for the transaction, in gallons or liters. |
| Transactions | The number of transactions. |
| Declined Transactions | The number of declined transactions. |
| Percent Declined Transactions | The percentage of transactions that were declined. |
| In Network Transactions | The number of in-network transactions. |
| Percent In Network Transactions | The percentage of transactions that were in-network. |
| In Network Spend USD | The total in-network spend amount in US dollars. |
| Percent In Network Spend | The percentage of total spend that was in-network. |
| Trip Distance | The distance traveled during the trip. |
| Fuel Spend per Distance (mi/km) | The fuel spend per mile or kilometer traveled. |
| Date | The universal date for the recorded event or activity. All times are localized to your time zone. For date and time, include the keyword "detailed" in your data search. |
| Transaction Posted Time | The time the transaction was posted. |
| Transaction Cleared Time | The time the transaction was cleared. |
| Card Last Four Digits | The last four digits of the card number. |
| Invoice Number | The unique number assigned to the invoice. |
| Pre-Transaction Field Name | The name of the pre-transaction metadata field. |
| Pre-Transaction Field Source | The source system of the pre-transaction metadata. |
| Pre-Transaction Field Value | The value of the pre-transaction metadata field. |
| Vehicle Fuel Type | The type of fuel used by the vehicle. |
| Vehicle Model | The model of the vehicle. |
| Vehicle Make | The make of the vehicle. |
| Vehicle VIN | The unique Vehicle Identification Number (VIN) of the vehicle. |
| Vehicle Weight Class | The weight class of the vehicle. |
| User Full Name | The full name of the user. |
| User ID | The unique identifier assigned to the user. |
| User Role | The role assigned to the card user. |
| User Credit Limit USD | The credit limit assigned to the user in US dollars. |
| User Status | The current status of the card user. |
| Transaction Status | The current status of the transaction. |
| Transaction Has Receipt | Whether a receipt is attached to the transaction. |
| Transaction Irregularity Reasons | The reasons for any irregularities on the transaction. |
| Transaction Is In Network | Whether the merchant is in the accepted network. |
| Transaction Merchant Category Code Description | The description of the merchant category code. |
| Transaction Merchant Category Code Name | The name of the merchant category code. |
| Transaction Note | The note attached to the transaction. |
| Transaction Dispute Status | The dispute status of the transaction. |
| Transaction Decline Reason | The reason for the declined transaction. |
| Card ID | The user-provided alias for the card. |
| Cardholder Type | The type of cardholder. |
| Card Display Status | The current status of the card. |
| Cardholder Name | The name of the cardholder. |
| Merchant Name | The name of the merchant. |
| Merchant State | The location of the merchant. |
| Merchant Street | The street address of the merchant. |
| Merchant Zip | The zip code of the merchant location. |
| Merchant Latitude | The latitude coordinates of the merchant location. |
| Merchant Longitude | The longitude coordinates of the merchant location. |
| Merchant City | The location of the merchant. |
| Company Current Billing Cycle | The current billing cycle for the account. |
| Company Current Credit Limit USD | The credit limit for the account in US dollars. |
| Invoice Start Time | The start time of the invoice billing period. |
| Invoice Paid In Full Date | The date the invoice was paid in full. |
| Invoice Amount USD | The total invoice amount in US dollars. |
| Invoice Opening Balance USD | The opening balance for the invoice period in US dollars. |
| Invoice Payable Amount USD | The net payable amount on the invoice in US dollars. |
| Invoice Payment Due Date | The date payment for the invoice is due. |
| Invoice Purchase Amount USD | The total purchase amount billed on the invoice in US dollars. |
| Invoice Rebate Amount USD | The total rebate amount applied to the invoice in US dollars. |
| Fleet Account ID | The unique identifier of the fleet account. |
| Invoice End Time | The end time of the invoice billing period. |
| Transaction Irregularity Status | The irregularity review status of the transaction. |
| Transaction Irregularity Type | The type of irregularity detected in the transaction. |
| Transaction Product Types | The types of products purchased in the transaction. |
| Card Type | The type of card, indicating whether it's physical or virtual. |
| 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. |
| 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. |
| 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". |
| Card Transaction ID | Unique identifier for the card transaction |
| Transaction Product Type | Category of product purchased, such as diesel, gasoline, DEF or reefer fuel. Note: this will create multiple rows per transaction if there are multiple product types |
Trips
| Data Field | Description |
| Trips | The total count of recorded trips taken by a vehicle or driver during a select period of time |
| Unidentified Trips | The count of trips with no assigned driver, typically due to missing or unverified log data |
| Interrupted Trips | The count of trips with status 'interrupted' |
| 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 Distance | The trip distance in miles or kilometers depending on your user preference settings |
| Average Trip Speed | The average trip speed in miles per hour (MPH) or kilometers per hour (KPH) depending on your user preference settings |
| Trip Duration (minutes) | The total duration of a trip, measured in minutes |
| Total Duration (Identified trips) | Total trip duration in minutes, summed across trips with an assigned driver (driver_id IS NOT NULL) |
| Total Duration (Unidentified trips) | Total trip duration in minutes, summed across trips with no assigned driver (driver_id IS NULL) |
| % Identified Time per Vehicle | Percentage of total trip time attributed to identified drivers |
| % Unidentified Time per Vehicle | Percentage of total trip time attributed to unidentified drivers |
| Trip Start Odometer | The reading of the odometer at the trip start |
| Trip End Odometer | The reading of the odometer at the trip end |
| Disconnects | The count of ELD device disconnect events |
| Disconnect Odometer | The vehicle odometer reading at the start of the disconnect, in miles or kilometers depending on your user preference settings |
| Disconnect Distance | The distance traveled during the ELD disconnect, in miles or kilometers depending on your user preference settings |
| Total Stops | The total count of stops, computed as the number of trips minus one per vehicle |
| Stop Duration (in seconds) | Seconds elapsed between the end of a trip and the start of the next trip for the same vehicle -1 indicates no following trip exists |
| Total Stop Duration (in seconds) | Represents non-motion time within each local end-day |
| Trip Duration (formatted) | The total duration of a trip, displayed in a readable time format |
| Total Drive Time (formatted) | The total time spent driving across all trips in the selected time window |
| Identified Trip Time (formatted) | The total driving time for trips assigned to an identified driver in the selected time window |
| Unidentified Trip Time (formatted) | The total driving time for trips with no identified driver in the selected time window |
| Total Idle Time (formatted) | The total non-PTO idling time recorded across all idle events in the selected window |
| Stop Duration (formatted) | Stop Duration rendered as X hrs Y mins Z secs |
| Total Stop Duration (formatted) | Total Stop Duration rendered as X hrs Y mins Z secs |
| 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 time zone Default to this unless minute or second level precision is needed |
| Trip Start Time | The recorded timestamp indicating 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 |
| 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 |
| Next Trip Start Time | The start time of the next trip for the same vehicle, NULL for the last trip in the queried window |
| Disconnect Time | The timestamp when the ELD device disconnected Localized to your time zone |
| Reconnect Time | The timestamp when the ELD device reconnected Localized to your time zone |
| 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 ID | The unique identifier assigned to each Motive user |
| User Email Address | The email address associated with the user. |
| User Role | The role the user is assigned to either `dispatcher` or `driver` |
| User Status | The current status of the user. Either 'active' or 'deactivated' |
| 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 |
| 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 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 Status | The status of the vehicle |
| 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 |
| 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 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 |
| Fleet Account Name | The name of the company |
| Fleet Account Id | The unique identifier assigned to each Motive customer account |
| ELD Mode | The mode in which the ELD operated for the duration of the trip |
| 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 Annotation Status | Indicates that the annotation status of the trip can be 'annotated', 'pending annotation', or 'not annotated' |
| Trip Notes | The most recent note entered on the trip by a fleet user |
| Trip Start Address | The start address of the trip |
| Trip End Address | The end address of the trip |
| Trip Start City | The city where the vehicle was located at the trip start |
| 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 |
| Trip Start Lat | The latitude where the vehicle was located at the start of the trip |
| Trip Start Lon | The longitude where the vehicle was located at the start of the trip |
| Trip End Lat | The latitude where the vehicle was located at the end of the trip |
| Trip End Lon | The longitude where the vehicle was located at the end of the trip |
| Stop Location | The end-of-trip city and state where the vehicle stopped before the next trip began |
| Driver Id Feature Enablement Status | The enablement status of the driver identification feature for the trip |
| Driver Identification Method | The method used to identify the driver for the trip |
| Identification Confidence Level | The confidence level of the driver identification result |
| Is Non Company Driver | The classification of the identified driver as a non-company fleet user |
| Trip Assigned Via Driver App | The successful identification of a fleet user using connected Driver App for the trip |
| Trip Assigned Via Face Match | The successful identification of a fleet user using face match for the trip |
| Face Match Action Performed | The face match action performed for the trip |
| Face Match Eligible Trip | The eligibility status of the trip for face match processing |
| Face Match Failure Reason | The reason a face match attempt failed for a face match eligible trip |
| Face Match Identification Familiarity | The identification of a familiar or unfamiliar driver profile for the trip |
| Face Match Location Data | The availability of location data for the face match trip |
| Face Match Profile ID | The identifier of the fleet user profile associated with the trip |
| Face Match Profile Status | The status of the fleet user profile associated with the trip |
| Face Match Registered | The registration status of the trip in the face match system |
| Face Match Request Status | The status of the face match request for a trip |
| Face Match Suggestion Status | The status of the face match suggestion for the trip |
| New Face Match Request | The creation of a new face match request for the trip |
| Image Recall Pending | The pending state of the image recall process for the trip |
| Camera Connection Status | The camera connection state for the trip |
| Camera Obstruction Status | The camera obstruction condition for the trip |
| Disconnect Status | Status of the disconnect event |
| ELD Shutdown Reason | The reason for the ELD device disconnect |
| Disconnect Location | The full address where the ELD device disconnected |
| Reconnect Location | The full address where the ELD device reconnected |
Dispatch
| Data Field | Description |
| Dispatch Id | Unique identifier for the dispatch |
| Dispatch Order Number | Customer-facing order number for the dispatch |
| Dispatch Status | Current status of the dispatch |
| Dispatch Vendor Type | Vendor or integration source type for the dispatch |
| Has Dispatch Route | Whether the dispatch has an associated route |
| Status Updated By | Full name of the user who last updated the dispatch status |
| Dispatcher Full Name | Resolved full name of the assigned dispatcher |
| Date | The universal date for the recorded event or activity All times are localized to your time zone For date and time, include the keyword "detailed" in your data search |
| Dispatch Created At | Timestamp when the dispatch was created |
| Dispatch Started At | Timestamp when the dispatch was started |
| Dispatch Completed At | Timestamp when the dispatch was completed |
| Dispatch Route Date | Scheduled date of the route |
| Dispatch Started At Hour | Hour level of dispatch started at date-time |
| Dispatch Completed At Hour | Hour level of dispatch completion date-time |
| Dispatch Customer Name | Name of the customer for the dispatch |
| Dispatch Address | Customer address for the dispatch |
| Dispatch Customer Email | Customer email address for the dispatch |
| Dispatch Phone Number | Customer phone number for the dispatch |
| Dispatch Fax Number | Customer fax number for the dispatch |
| Dispatch Notes | Free-text notes captured on the dispatch |
| Dispatch Route Name | Name of the route associated with the dispatch |
| Dispatch Route Notes | Free-text notes captured on the route |
| Dispatch Revenue | Revenue associated with the dispatch |
| Dispatch Planned Trip Length | Planned trip length in kilometers (loaded miles converted to km) |
| Dispatch Stop Id | Unique identifier for the dispatch stop |
| Dispatch Stop Number | Sequential stop number within the dispatch |
| Dispatch Stop Type | Type of stop (e.g., pickup, drop off) |
| Dispatch Stop Id Name | Customer-configured stop identifier from dispatch preferences |
| Dispatch Stop Id Instructions | Special instructions captured for the stop |
| Dispatch Stop Goods | Goods or cargo associated with the stop |
| Dispatch Stop Trailer | Trailer associated with the stop |
| Dispatch Stop Loading Method | Loading method used at the stop |
| Dispatch Stop Location Name | Name of the location for this stop |
| Dispatch Stop Address 1 | First line of the stop location address |
| Dispatch Stop Address 2 | Second line of the stop location address |
| Dispatch Stop City | City of the stop location |
| Dispatch Stop State | State or province of the stop location |
| Dispatch Stop Zipcode | Postal code of the stop location |
| Dispatch Stop Country | Country of the stop location |
| Dispatch Stop Location Email | Email address of the stop location |
| Dispatch Stop Location Phone Number | Phone number of the stop location |
| Dispatch Stop Location Fax Number | Fax number of the stop location |
| Dispatch Stop Arrived At | Timestamp when the vehicle arrived at the stop |
| Dispatch Stop Departed At | Timestamp when the vehicle departed the stop |
| Dispatch Stop Planned Window Start | Start of the planned arrival window for the stop |
| Dispatch Stop Planned Window End | End of the planned arrival window for the stop |
| Dispatch Stop Arrive Odometer | Odometer reading in km recorded at arrival |
| Dispatch Stop Depart Odometer | Odometer reading in km recorded at departure |
| Dispatch Stop Distance From Previous Stop | Distance in km from the previous stop's departure odometer to this stop's arrival odometer |
| Time Onsite (Minutes) | Stop duration at dispatch stop |
| Time Onsite (Formatted) | Total stop duration at dispatch stop formatted (H:M:S) |
| Dispatch Stop Estimated Transit Time (minutes) | Difference in minutes of planned window for dispatch stop |
| Dispatch Stop Actual Transit Time (minutes) | Actual stop duration during dispatch stop |
| Transit Estimate Variance (minutes) | Difference of planned transit time vs actual transit time |
| Dispatch Stop Arrival - Planned Arrival (minutes) | Difference in Dispatch Stop Actual arrival time vs planned arrival time |
| Trip Distance | Trip Distance covered |
| Trip Start Time | Start Time of the Trip |
| Trip End Time | End Time of the Trip |
| Trip Duration (sec) | Duration of the trip in seconds |
| Trip Duration Formatted | Trip Duration Formatted (H:M:S) |
| Idle Events | Number of idling events recorded |
| Idle Duration (sec) | Idling duration in seconds |
| Idling Duration (Formatted) | Idling Duration Formatted (H:M:S) |
| Idle Event Start Time | Idling Event Start Time |
| Idle Event End Time | Idling Event End Time |
| Vehicle ID | Alias assigned to the vehicle |
| Vehicle VIN | Vehicle VIN |
| Vehicle Make | Make of the vehicle |
| Vehicle Model | Model of the vehicle |
| Vehicle Year | Year of the vehicle's model |
| Vehicle Weight Class | Vehicle Weight Class |
| Vehicle License Plate Number | Number of the vehicle's license plate |
| Vehicle Status | Status of the vehicle |
| Vehicle Group Name | Vehicle Group Name |
| Is Explicit Vehicle Group Member | Boolean flag to check if group is child-most |
| Vehicle Group Depth | The number of levels down in the hierarchy that the Vehicle Group Name is located |
| 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 |
| Vehicle Parent Group Name | The name of the parent group that's one hierarchical level above the selected Vehicle Group Name |
| User Full Name | Full name of the user First name + last name |
| User ID | Alias assigned to the user |
| User Status | Status of the user |
| User Group Name | User Group Name |
| Is Explicit User Group Member | Boolean flag to check if group is child-most |
| User Group Depth | The number of levels down in the hierarchy that the User Group Name is located |
| 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 |
| User Parent Group Name | The name of the parent group that's one hierarchical level above the selected User Group Name |
| Fleet Account Name | Name of the company |
| Fleet Account Id | Unique identifier (primary key) for a Motive customer account |
IFTA
| Data Field | Description |
| Date | The date of the IFTA event, converted to the selected time zone |
| IFTA Event Hour | Hourly timestamp of the IFTA event, converted to the selected time zone |
| IFTA Event Distance Covered | Distance Covered during IFTA Event |
| IFTA Event Fuel Consumed | Fuel consumed during the IFTA Event (start minus end fuel), converted to selected unit Null when either start or end fuel is unavailable |
| Fuel Purchase Quantity | Amount of fuel purchased within the IFTA event |
| IFTA Event Start Odometer | Vehicle odometer reading at the start of the IFTA Event, converted to selected unit |
| IFTA Event End Odometer | Vehicle odometer reading at the end of the IFTA Event, converted to selected unit |
| IFTA Event Start Fuel | Total fuel quantity at the start of the IFTA Event, converted to selected unit |
| IFTA Event End Fuel | Total fuel quantity at the end of the IFTA Event, converted to selected unit |
| IFTA Event Start Latitude | Starting latitude of the earliest event for this vehicle, jurisdiction, and date |
| IFTA Event Start Longitude | Starting longitude of the earliest event for this vehicle, jurisdiction, and date |
| IFTA Event End Latitude | Ending latitude of the latest event for this vehicle, jurisdiction, and date |
| IFTA Event End Longitude | Ending longitude of the latest event for this vehicle, jurisdiction, and date |
| Jurisdiction Name | Jurisdiction display name used in reporting |
| Language | Language code for the row (e.g., en, es) |
| Fleet Vehicle Id | Unique identifier for the vehicle associated with the fuel purchase |
| Fleet Account Name | Name of the company |
| Fleet Account Id | Unique identifier (primary key) for a Motive customer account |
| Vehicle ID | The unique identifier assigned to each vehicle |
| VIN | The unique Vehicle Identification Number used by the automotive industry |
| Vehicle Make | The manufacturer of the vehicle |
| Vehicle Model | The model of the vehicle |
| Model Year | The year in which the vehicle was manufactured |
| Weight Class | The classification of a vehicle based on its weight |
| Vehicle Fuel Type | The type of fuel used by the vehicle, such as gasoline, diesel, electric, or hybrid |
| Vehicle License Plate Number | The unique combination of letters and numbers that identifies a vehicle |
| Status | Status of the vehicle |
| Is IFTA Enabled | Indicates if IFTA is enabled for the vehicle |
| 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 |
| Is 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) |
| 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 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 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 |
| IFTA Event Distance Granular | Odometer distance covered during IFTA event |
| Fuel Quantity Liters | Quantity of fuel purchased, normalized to liters |
| Jurisdiction | US state or jurisdiction code where the fuel was purchased |
| IFTA Event Start Lat | Starting GPS latitude coordinate of the IFTA event |
| IFTA Event Start Lon | Starting GPS longitude coordinate of the IFTA Event |
| IFTA Event End Lat | Ending GPS latitude coordinate of the IFTA Event |
| IFTA Event End Lon | Ending GPS longitude coordinate of the IFTA Event |
| IFTA Event Day Start Latitude SF | Starting latitude of the earliest hourly event for this vehicle, jurisdiction, and date |
| IFTA Event Day Start Longitude SF | Starting longitude of the earliest hourly event for this vehicle, jurisdiction, and date |
| IFTA Event Day End Latitude SF | Ending latitude of the latest hourly event for this vehicle, jurisdiction, and date |
| IFTA Event Day End Longitude SF | Ending longitude of the latest hourly event for this vehicle, jurisdiction, and date |
Vehicles
| Field Name | Description |
| AUX Activity Distance | Distance traveled by the vehicle during the AUX activity |
| AUX Activity Duration (minutes) | Duration of one AUX activity from its start time to its end time, shown in minutes |
| AUX Activity End Time | Timestamp when the AUX activity ended |
| AUX Activity Start Time | Timestamp when the AUX activity started |
| AUX End Geofence | name of the geofence where the aux activity ended, if any |
| AUX End Location | End location for the aux activity |
| AUX Equipment | User-friendly display name for the aux equipment type, using custom_equipment_type when available or a mapped label otherwise |
| AUX Input | The configured AUX input number that generated the activity (for example, AUX 1 / AUX 2) |
| AUX Signal | Status of the aux activity |
| AUX Start Geofence | Name of the geofence where the aux activity started, if any |
| AUX Start Location | Start location for the aux activity |
| Average Trip Speed | The average trip speed in miles per hour (MPH) or kilometers per hour (KPH) depending on your user preference settings |
| Camera Connected | Camera connected to the vehicle gateway |
| Current Cycle Wifi Status | Wifi hotspot status for the current billing cycle |
| Current Driver Full Name | Full name of the currently assigned user for the vehicle |
| Current Firmware Version | Current software package version of the vehicle gateway device |
| Dashcam Connection Event | Type of dashcam connection event (e.g., "connected", "disconnected") |
| Dashcam Connection Event Duration (hours) | Duration of a single dashcam connection-history event, expressed in hours |
| Dashcam Connection Status | The status of the dashcam connection, indicating whether it is connected or disconnected |
| Dashcam Event Created At | Timestamp when the dashcam connection event was created |
| 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 time zone. Default to this unless minute- or second-level precision is needed |
| Days Remaining in Current Cycle | Number of days left in the current Wi-Fi billing cycle |
| Engine Immobilizer Assigned At | Timestamp when the engine immobilizer was assigned |
| Engine Immobilizer IMEI | Unique IMEI number for the engine immobilizer |
| Engine Immobilizer Installation Status | Status of the engine immobilizer installation |
| Engine Immobilizer Installed At | Timestamp when the engine immobilizer was installed |
| Engine Immobilizer Last Operated At | Timestamp when the last immobilizer command was sent / operated |
| Engine Immobilizer Last Status Changed At | Timestamp when the engine immobilizer status last changed |
| Engine Immobilizer Mobility Status | Mobility status of the engine immobilizer on the vehicle |
| Engine Immobilizer Model | Model of the engine immobilizer |
| Engine Immobilizer Serial Number | Serial number of the engine immobilizer |
| Engine Immobilizer Unassigned At | Timestamp when the engine immobilizer was unassigned |
| 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) |
| 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 First Observed At | The date and time when the fault code was first detected |
| Fault Code Last Observed At | The date and time when the fault code was last detected |
| Fault Code Network | Common protocols/networks over which DTC codes are communicated |
| Fault Code Source | The component or system that reported the fault code |
| Fault Code Status | 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 |
| Fleet Account Id | The unique identifier assigned to each Motive customer account |
| Fleet Account Name | The name of the company |
| 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 |
| Is Current Wifi Cycle | Flag indicating whether the selected Wi-Fi cycle is the current/open billing cycle |
| Is IFTA Vehicle | Indicates if IFTA is enabled for the vehicle |
| Is Video Request Confidential | Whether the video recall request is marked confidential |
| Last Drive Time | Last recorded drive time of the vehicle |
| Last Vehicle ID | The previous vehicle most recently assigned to the vehicle gateway before the current assignment |
| Malfunctions & Diagnostics | List of active (open) malfunctions and diagnostics on the vehicle gateway device |
| Next Fleet User Full Name | Full name of the next fleet user associated with the event |
| Permanent User Full Name | Full name of the permanently assigned user for the vehicle |
| Previous Fleet User Full Name | Full name of the previous fleet user associated with the event |
| Rfid Reader | The serial number of the RFID reader associated with the vehicle |
| Time Of Video Requested | Timestamp of the video that was requested |
| Tire Pressure | Recorded tire pressure during the event |
| Tire Pressure Event | Type of TPMS event (e.g., Under Pressure, Over Temperature) |
| Tire Pressure Event Location | Axle and Tire location for which the tire pressure event occurred |
| Tire Pressure Event Status | Whether the TPMS event is currently open or closed based on resolution status |
| Tire Pressure First Observed At | First timestamp when the TPMS event was observed |
| Tire Pressure Last Observed At | Recent timestamp when the TPMS event was observed |
| Tire Temperature | Recorded tire temperature during the event |
| Total AUX Activations | Count of AUX activity activations / total AUX activities for the input in scope |
| Total Fleet Wifi Data Allotted | Total Wi-Fi data allotment available to the fleet for the billing cycle |
| Total Fleet Wifi Data Consumed | Total Wi-Fi data used by the fleet in the billing cycle |
| Total Fleet Wifi Data Remaining | Total Wi-Fi data still remaining for the fleet in the billing cycle |
| Total Vehicles | Count of vehicles in scope after report filters are applied |
| Total VGs | Total count of vehicle gateways in the fleet |
| Trip Distance | The trip distance in miles or kilometers depending on your user preference settings |
| Trip Duration (formatted) | The total duration of a trip, displayed in a readable time format |
| Trip Duration (minutes) | The total duration of a trip, measured in minutes |
| Trip End Address | End address of the trip |
| Trip End City | The city where the vehicle was located at the end of the trip |
| Trip End Lat | The latitude where the vehicle was located at the end of the trip |
| Trip End Lon | The longitude where the vehicle was located at the end of the trip |
| Trip End Odometer | The reading of the odometer at the trip's end |
| Trip End State | The geographical state where the vehicle was located at the end of the trip |
| 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 |
| Trip Start Address | Start address of the trip |
| Trip Start City | The city where the vehicle was located at the trip start |
| Trip Start Lat | The latitude where the vehicle was located at the start of the trip |
| Trip Start Lon | The longitude where the vehicle was located at the start of the trip |
| Trip Start Odometer | The reading of the odometer at the trip start |
| Trip Start State | The geographical state where the vehicle was located at the start of the trip |
| Trip Start Time | The recorded timestamp indicating 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 |
| Trips | The total count of recorded trips taken by a vehicle or driver during a select period of time |
| Unidentified Trips | The count of trips with no assigned driver, typically due to missing or unverified log data |
| Unique Vehicles | The total count of distinct vehicles associated with the recorded data set |
| 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 |
| Vehicle Availability Status | current availability status of the vehicle |
| Vehicle Engine Hours | Maximum engine hours observed in vehicle location history for the vehicle |
| Vehicle Fuel Type | The type of fuel used by the vehicle, such as gasoline, diesel, electric, or hybrid |
| Vehicle Gateway Assigned At | The recorded timestamp indicates when the last known vehicle gateway was assigned to the vehicle. For date and time, include the keyword "detailed" in your data search. All time fields are localized to your time zone |
| Vehicle Gateway ID | The unique identifier assigned to each Vehicle Gateway device |
| Vehicle Gateway Status | The status of the Vehicle Gateway, indicating its current condition, such as allocated, in transit, or inactive |
| Vehicle Gateway Unassigned At | The recorded timestamp indicating when the last known vehicle gateway assignment ended for the vehicle. For date and time, include the keyword "detailed" in your data search. All time fields are localized to your time zone |
| 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 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 |
| 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 ID | The unique identifier assigned to each vehicle |
| Vehicle License Number | License number of the vehicle |
| Vehicle Location | Last known location of the vehicle based on either Trips or ELD messages |
| Vehicle Make | The manufacturer of the vehicle |
| Vehicle Model | The model of the vehicle |
| Vehicle Odometer | Last recorded value of vehicle odometer |
| 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 Status | Status of the vehicle |
| Vehicle with VGs | Count of vehicles that currently have an assigned vehicle gateway / ELD |
| Vehicle Year | The year in which the vehicle was manufactured. |
| Vehicles using data | Count of vehicles whose hotspot consumed more than 0 data in the cycle |
| Vehicles with data throttling | Count of vehicles whose hotspot status is throttled in the current cycle |
| VG Last Activity Time | Most recent activity / last message timestamp for the vehicle gateway |
| VG Shipped from Motive At | Timestamp when vehicle gateway was shipped from Motive |
| Video Recall Request Status | Status of the video recall request |
| Video Request Completed At | Completion timestamp for a video recall request, i.e., when the request finishes / footage becomes available |
| Video Request Location | Location tied to the requested video recall, based on the stored request address / coordinates. |
| Video Requested At | Timestamp when the video recall request was created |
| Video Requested By Full Name | Full name of the user who requested the video recall |
| VIN | The unique Vehicle Identification Number used by the automotive industry |
| Weight Class | The classification of a vehicle based on its weight |
| Wifi Cycle | The Wi-Fi billing cycle date range; cycles running from the 19th of one month to the 18th of the next |
| Wifi Data Consumed | Total Wi-Fi data consumed by a vehicle gateway during the billing cycle |
| Wifi Data Threshold | Vehicle-level Wi-Fi hotspot data threshold for the billing cycle |
| Wifi Network Name | The Wi-Fi SSID is currently configured on the vehicle gateway |
| Wifi Network Password | The Wi-Fi password currently configured on the vehicle gateway |
Two-way Communication
Data Field | Description |
Average Voice Call Duration in Minutes | Average call duration in minutes |
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 time zone |
Fleet Account Name | Name of the company |
Total Calls | Total call counts |
User Full Name | User associated with the voice call |
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 |
Vehicle ID | Alias assigned to the vehicle |
Vehicle Name | Vehicle Name, which is a combination of make, model & year |
Voice Call Duration in Minutes | Total durations in minutes |
Voice Call End Reason | Reason the voice call ended |
Voice Call Ended Hour | Idle timestamp hour when the voice call ended |
Voice Call Ended Time | Idle timestamp when the voice call ended |
Voice Call Joined Channel Hour | Idle timestamp hour when the voice call channel joined |
Voice Call Joined Channel Time | Idle timestamp when the voice call channel joined |
Voice Call Source | Source of the voice call (e.g., web, mobile) |
Voice Call Started Hour | Idle timestamp hour when the voice call started |
Voice Call Started Time | Idle timestamp when the voice call started |
Created At | Timestamp when the voice call record was created |
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) |
Fleet Account ID | Unique identifier for the fleet account |
Fleet User ID | Identifier for the fleet user (driver) associated with the voice call |
Fleet Vehicle ID | Identifier for the fleet vehicle associated with the voice call |
Language | Language code for this row (e.g., en, es) |
Updated At | Timestamp when the voice call record was last updated |
Vehicle Group Depth | The number of levels down in the hierarchy that the Vehicle Group Name is located |
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 |
Vehicle Parent Group Name | The name of the parent group that's one hierarchical level above the selected Vehicle Group Name |
Timecards
Data Field | Description |
Daily Trip Distance | The total distance traveled on all trips that started on the calendar date, in miles or kilometers depending on your user preference settings. Covers the whole day and is not limited to clocked-in periods |
Date | The date of the timecard entry, derived from the clock-in time and localized to your time zone. For date and time, include the keyword "detailed" in your data search |
Driver Type | The driver type, such as 'ELD', 'Logs Not Required', or 'Electronic Logbook' |
Entry Type | Type of timecard entry (clocked in) |
Fleet Account ID | Fleet account identifier for RLS filtering |
Fleet Account Name | Name of the fleet company |
Job Type | Job type or activity assigned to the timecard entry |
Timecard Detail ID | Unique identifier for the timecard detail record |
Timecard Duration (formatted) | Duration formatted as hours, minutes, seconds |
Timecard Duration (hours) | Duration of the clocked-in period in hours |
Timecard Duration (minutes) | Duration of the clocked-in period in minutes |
Timecard Duration (sec) | Duration of the clocked-in period in seconds |
Timecard End Time | Clock-out end time in selected time zone |
Timecard ID | Unique identifier for the parent timecard |
Timecard Location | Address of the clock-in location |
Timecard Notes | Notes added to the timecard entry |
Timecard Start Time | Clock-in start time in selected time zone |
Trip Distance (Clocked-in) | The total distance traveled on trips that overlap the clocked-in period, in miles or kilometers depending on your user preference settings. A trip is included if any part of it falls within the shift, even if it began before clock-in or ended after clock-out |
Trip Duration (Formatted) | The total duration of trips that fall entirely within the clocked-in period, displayed as hours, minutes, and seconds. Trips that began before clock-in or ended after clock-out are excluded |
Trip Duration (s) | The total duration, in seconds, of trips that fall entirely within the clocked-in period. Trips that began before clock-in or ended after clock-out are excluded |
User Full Name | Full name of the driver |
User Group Depth | The number of levels down in the hierarchy that the User Group Name is located |
User Group Name | Name of the group the user belongs to |
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 |
User ID | Driver alias or employee ID |
User Parent Group Name | The name of the parent group that's one hierarchical level above the selected User Group Name |
User Status | Current status of the user (active or deactivated) |
Timecard Date | Calendar date of the timecard entry |
User Role | Role assigned to the user (driver or dispatcher) |
User Time Zone | Time zone setting for the user |
Share this with others