The Verizon Connect Analytics Server

Snowflake Reader Account

This is a printed page that might be out of date. To read the most up-to-date help content, visit https://fleet-help.verizonconnect.com.
  • Updated

What is Snowflake?

Snowflake is an analytic data warehouse provided as Software-as-a-Service (SaaS). Snowflake houses Verizon Connect Analytics 2.0 Platform with over 130 pre-built key performance indicators (KPIs), as well as our analytics tools. This combination of tools lets your teams collaborate better with one another, giving them actionable insights they can use to drive business transformation.

Fleet Analytics Reports, Fleet Scorecards, Fleet Scorecard Reports, Fleet Dashboards, Coach and Spotlight all use data from Verizon Connect Analytics 2.0 Platform.

Snowflake’s data warehouse is not built on an existing database or “big data” software platform, such as Hadoop. The Snowflake data warehouse uses a new SQL database engine with a unique architecture designed for the cloud.

Snowflake’s data warehouse is a true SaaS offering. More specifically:

  • You do not need to select, install, configure, or manage any hardware.
  • You do not need to install, configure, or manage any software.
  • Snowflake handles ongoing maintenance, management, and tuning.

Snowflake runs completely on cloud infrastructure. All components of Snowflake’s service (other than an optional command line client), run in a public cloud infrastructure.

What is a Reader Account?

A reader account enables Verizon Connect Fleet Ultimate customers to access and query data on Snowflake warehouse, with no setup or usage costs, and no requirements to sign a licensing agreement with Snowflake.

Reader Account allows Verizon Connect Fleet Ultimate customers to build configurable reports and dashboards using their preferred BI tool, by connecting to the Verizon Connect’s data warehouse provided by Snowflake.

The reader account is created, owned, and managed by Verizon Connect, which assumes all responsibility for credit charges incurred by users in the reader account. Verizon Connect uses shares to share databases with reader accounts; however, a reader account can consume data only from the provider account that created it.

How Can I Manage Roles and Permissions?

When your reader account is set up, we assign a default role for you to use, named CUSTOMER_ADMIN. This role gives you unrestricted access to all views available in the reader account, and lets you manage additional roles and users within the account.

If you require users with specific sets of permissions, you can create additional roles that can be granted to new users as needed. For example, if you want a user to have access to the VZC database and the views within it, they can be assigned a role that has those permissions explicitly granted.

For more information, see the examples at the bottom of this article or consult the Role Management section in the official Snowflake documentation.

What is Restricted/Allowed in a Reader Account?

A reader account is intended primarily for querying data shared by Verizon Connect. Adding new data to the account and updating shared data in the account are not supported. Additionally, you cannot create any objects in the shared database. You can create an additional database with a set of views that work for you, sourcing the data from the shared database. This would allow you to set up permissions according to your needs. As such, the following DML and DDL commands are not allowed:

  • INSERT
  • UPDATE
  • DELETE
  • MERGE
  • COPY INTO <table>
  • CREATE PIPE
  • CREATE SHARE

Who Provides Support for a Reader Account?

As the provider of the account, Verizon Connect fields questions and requests from users in the account and responds as appropriate. Reach out to your support team if you experience issues with your reader account or have any questions.

How Do I Connect to Reader Account?

There are many ways to work with Snowflake. The default way of interaction is via the Snowflake UI using the link provided by Verizon Connect. You can familiarize yourself with it right after you complete the initial setup of your account. Additionally, there are several options when working with Snowflake database:

How Do I Export Data From a Reader Account?

Snowflake provides several options when it comes to exporting (or unloading) data from its database. We recommend that you read the information in the following Snowflake user guide pages to learn about best practices and the key concepts of exporting data from Snowflake:

The Snowflake user guide also contains some additional information on the supported data file formats, recommendations, and an option of creating your own named file format.

The following links contain detailed instructions for exporting data to one of the following destinations:

Views

Views Overview

View Name Description View Type Join Fields
address Contains key details related to an address, including state, city, and suburb. Note that addresses are immutable. Dimension address_id
app_event Contains details of events from miscellaneous mobile applications within the platform. Fact app_event_key, driver_key, event_type_key
condition Contains data around the configured conditions that can trigger Insight Alerts. Dimension condition_key, condition_id
device Contains information about the devices (hardware) installed in vehicles. Dimension device_id
device_link_history Contains information about the link history of devices with units. Fact unit_id, device_id
driver Contains key details related to a driver, including hierarchy information and other user details. Dimension driver_key
driver_day Contains day-level aggregate KPIs related to a driver. Fact driver_key
eld_driving_period Contains key details related to ELD driving period, including start time, end time and events. Fact driving_period_id, vehicle_key, unit_id
eld_driving_period_action Contains key details related to ELD driving period actions including time of action and action_id. Fact driving_period_action_id, driving_period_id
event Contains individual event data relating to units. Fact unit_id
hierarchy_node Contains information about the hierarchy configured for an account. Dimension hierarchy_node_id
insight_alert Contains data around Insight Alerts that have been triggered in the VZC Fleet platform. Fact condition_id, condition_key, vehicle_key, driver_key
install_type_diagnostic_parameter Contains information about the diagnostic parameters configured for a particular install type. Dimension install_type_id
job_pva Contains planned vs actual details for a job including its status, associated route and territory. Fact job_id, route_id, territory_key, marker_key
marker Contains details of the markers for an account, including category and geometry details. Dimension marker_key
mobile_event_type Contains details of the different mobile event types that can be present in the app_event fact Dimension mobile_event_type_key
nru_event Details around time periods where units were determined to be non-reporting. Fact unit_id, vehicle_key, driver_id, driver_key
point_with_vehicle Contains point data from vehicles, including GPS location, diagnostics, and other sensor data. Fact vehicle_key
point_with_vehicle_and_driver Contains point data from vehicles, including driver, GPS location, diagnostics, and other sensor data. Fact driver_key, vehicle_key
route_pva Contains planned vs actual details for a route including its status, job count and territory. Fact route_id, territory_key, vehicle_key, driver_key
territory Contains details of the territory for an account, including its name and timezone. Dimension territory_key
time_on_site Contains details about the duration a vehicle spent within markers at certain times. Fact vehicle_key, marker_key
trip Contains trip-level aggregate KPIs related to a driver and associated vehicle. Fact driver_key, vehicle_key
trip_by_state Contains trip-level aggregate KPIs related to a driver and associated vehicle. The data is the same as in the “trip” fact, with the exception that rows are further split when the vehicle crosses a state boundary. Fact driver_key, vehicle_key
unit_driver_history Contains information relating to the assignment of drivers to vehicles. Fact unit_id, driver_id
vehicle Contains key details related to a vehicle, including year, make, model, and time zone. Dimension vehicle_key, unit_id
vehicle_day Contains day-level aggregate KPIs related to a vehicle. Fact vehicle_key
video_course Contains information about video courses that may be taken by a driver via the Coach app. Dimension video_course_key

info.gif

The data available through Self-Service Analytics is shared using secure views and not tables. Querying with analytics tools that are trying to find the primary and foreign keys to map the relationships between tables does not work. Data and structure can change at any time, without notice.

Address View (address)

Column Name Slow Changing Behavior Data Type Description
ADDRESS_ID   NUMBER A unique identifier for this address, used within Fleet and the Analytics server alike. Use ADDRESS_ID for joining or grouping by this view.
COUNTRY_CODE Current TEXT A two-character code for the address's country.
COUNTRY Current TEXT The country of the address.
REGION Current TEXT The region of the address.
STATE Current TEXT The state of the address.
CITY Current TEXT The city of the address.
STREET Current TEXT The street of the address.
POSTCODE Current TEXT The postcode of the address. Applicable in countries that use a postcode.
ZIP Current TEXT The ZIP code of the address. Applicable in the United States.
SUBURB Current TEXT The suburb of the address.
ZONE Current TEXT In the United States the zone can be US-North, US-South, US-East, and US-West. Outside the United States the zone is usually empty.

App Event View (app_event)

Column Name Data Type Description
APP_EVENT_KEY NUMBER A unique identifier for this app_event, used within the Analytics server. Use app_event_key for joining this view.
APP_EVENT_ID TEXT A unique identifier for this app_event, used within Fleet. Use APP_EVENT_ID for grouping by this view.
DRIVER_KEY NUMBER A unique identifier for the driver, used within the Analytics server. Use DRIVER_KEY for joining this view.
EVENT_TYPE_KEY NUMBER A unique identifier for the event_type, used within the Analytics server. Use EVENT_TYPE_KEY for joining this view.
EVENT_DATA VARIANT A JSON object that contains all the unparsed data for the event.
SOURCE_APP TEXT Name of the mobile app.
SOURCE_APP_VERSION TEXT Version of the mobile app.
EVENT_TIME TIMESTAMP_NTZ The time of the event.
EVENT_TEXT TEXT Additional information for the event.
VIDEO_COURSE_KEY NUMBER A unique identifier for the video_course, used within the Analytics server. Use VIDEO_COURSE_KEY for joining this view.
DEVICE TEXT Device identification information.
ROW_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when this app_event database entry was created.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when this app_event database entry was last updated.

Condition View (condition)

Column Name Slow Changing Behavior Data Type Description
CONDITION_KEY   NUMBER A unique identifier for the condition, used within the Analytics server. Use CONDITION_KEY for joining this view.
CONDITION_ID   TEXT A unique identifier for the condition, used within Fleet. Use CONDITION_ID for grouping by this view.
CONDITION_NAME Current TEXT The name of the condition, as defined by the creator in Fleet.
CONDITION_TYPE Historic TEXT The type of condition.
USER_ID Historic NUMBER The user id of the user who created the condition.
SEVERITY Historic TEXT The severity index of this condition.
SEVERITY_COLOR Historic TEXT The severity color of this condition.
TIME_TO_TRIGGER_SECONDS Historic NUMBER The period of time the condition must be satisfied before it triggers an alert.
AGGRESSIVE Historic BOOLEAN Whether or not the condition should be triggered using the aggressive criteria.
GROUP_TYPE Historic TEXT The group type for this condition.
DISABLE_REASON Historic TEXT The reason why this condition might have been disabled.
IS_SCOREABLE Current BOOLEAN Whether or not this condition is available to include on a Scorecard in Fleet.
PROPERTIES Historic VARIANT JSON that contains properties relating to how the condition is handled.
IS_CURRENT   BOOLEAN Whether or not this driver database entry is current or has been replaced by a newer copy.
START_TIME_UTC   TIMESTAMP_NTZ The time at which this condition entry was created, in UTC.
END_TIME_UTC   TIMESTAMP_NTZ The time at which this condition entry became historical, in UTC.
ROW_UPDATE_TIME   TIMESTAMP_NTZ The time, in UTC, when this entry was last updated.

Device Link History (device_link_history)

Column Name Data Type Description
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server.
DEVICE_ID NUMBER A unique identifier for the device, used within Fleet.
LINK_DATE TIMESTAMP_NTZ The date at which the device was linked to the vehicle/unit.
UNLINK_DATE TIMESTAMP_NTZ The date at which the device was unlinked from the vehicle/unit. Null value when the device is currently linked.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when this database entry was last updated.

Device View (device)

Column Name Slow Changing Behavior Data Type Description
DEVICE_KEY   NUMBER A unique identifier for the device, used within the Analytics server.
DEVICE_ID   NUMBER A unique identifier for the device, used within Fleet.
SERIAL_NUMBER Historic TEXT The serial number of the device.
SIM Historic TEXT The SIM number of the device.
IMEI Historic TEXT The IMEI number of the device.
MDN Historic TEXT The MDN number of the device.
WIRELESS_PROVIDER Historic TEXT The wireless provider the device connects to.
TECH Historic TEXT The technology used to communicate with the provider.
IS_CURRENT   BOOLEAN Whether this vehicle database entry is current or has been replaced by a newer copy.
START_TIME_UTC   TIMESTAMP_NTZ The time at which this entry was created, in UTC.
END_TIME_UTC   TIMESTAMP_NTZ The time at which this entry became historical, in UTC.
ROW_UPDATE_TIME   TIMESTAMP_NTZ The time, in UTC, when this entry was last updated.

Driver Form Instance View (driver_form_instance)

Column Name Data Type Description
FORM_INSTANCE_XML_ID TEXT A unique identifier for this particular form instance xml.
FORM_INSTANCE_ID TEXT A unique identifier for the form instance that this form instance xml belongs to. A form_instance_id can have up to three different form_instance_xml_ids.
CREATE_TIME_ON_DEVICE_UTC TIMESTAMP_NTZ The time that the form instance xml is created on the driver''s device (in UTC).
STATUS NUMBER A number representing the status of this particular form instance xml. If the form instance xml is submitted, status = 1, else not submitted.
VERSION_NUMBER NUMBER A number representing the version of this form instance xml. The version_number can be 1, 2, or 3. The version number will be incremented when a new form instance xml is created on the same form instance.
SUBMITTED_TIME_UTC TIMESTAMP_NTZ The time that the form instance xml is submitted (in UTC).
DRIVER_ID NUMBER A unique identifier for this driver, used within Fleet. Use DRIVER_ID for grouping by this view.
DRIVER_KEY NUMBER A unique identifier for this driver, used within the Analytics server. Use DRIVER_KEY for joining this view.
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet. Use VEHICLE_ID for grouping by this view.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
JOB_ID TEXT An identifier for the job related to this form instance xml, used within the Fleet and Analytics server alike. Use JOB_ID for joining to this view.
JOB_NAME TEXT The name of this job.
JOB_DELETE_TIME_UTC TIMESTAMP_NTZ The time that the job is deleted (in UTC).
JOB_ERASE_TIME_UTC TIMESTAMP_NTZ The time that the job is hard deleted from the database (in UTC).
FORM_TEMPLATE_NAME TEXT The name of the template used for this form instance xml.
FORM_TEMPLATE_ID TEXT An identifier for the template used for this form instance xml.
FORM_TEMPLATE_REVISION_ID TEXT A unique identifier for the specific version of the template used for this form instance xml.
FORM_TEMPLATE_REVISION_NUMBER NUMBER A number representing the version of the template used for this form instance xml.
ADDRESS TEXT The location at which the form instance xml is created.
STREET_NUMBER TEXT The street number of the address.
STREET_NAME TEXT The street name of the address.
CITY TEXT The city of the address.
STATE TEXT The state of the address.
ZIP TEXT The zip code of the address.
COUNTRY TXT The country of the address.
LATITUDE FLOAT The latitude coordinate of where the form instance xml is created.
LONGITUDE FLOAT The longitude coordinate of where the form instance xml is created.
INSTANCE_BODY VARIANT The content of the form instance xml in json format.
FORM_TYPE TEXT The type of the form instance xml; for example, standard, dvir.3rdSignature.
WALKAROUND_COMPLETE BOOLEAN A boolean indicating whether the walkaround has been completed or not.
THIRD_SIG_DVIR_PASSED NUMBER The total number of passed vehicle parts.
THIRD_SIG_DVIR_FAILED NUMBER The total number of failed vehicle parts.
THIRD_SIG_DVIR_FIXED NUMBER The total number of fixed vehicle parts.
THIRD_SIG_DVIR_NA NUMBER The total number of not applicable vehicle parts.
THIRD_SIG_DVIR_NON_CRITICAL_FAILED NUMBER The total number of non-critically failed vehicle parts.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time that this form instance xml entry is last updated (in UTC).

Driver View (driver)

Column Name Slow Changing Behavior Data Type Description
DRIVER_KEY   NUMBER A unique identifier for this driver, used within the Analytics server. Use DRIVER_KEY for joining this view.
DRIVER_ID   NUMBER A unique identifier for this driver, used within Fleet. Use DRIVER_ID for grouping by this view.
DRIVER_NAME Current TEXT The driver's full name (first, middle, and last, where available).
FIRST_NAME Historic TEXT The driver's first name.
MIDDLE_NAME Historic TEXT The driver's middle name.
LAST_NAME Historic TEXT The driver's last name.
ADDRESS_FIELD_1 Historic TEXT The first field of the driver's address details.
ADDRESS_FIELD_2 Historic TEXT The second field of the driver's address details.
ADDRESS_FIELD_3 Historic TEXT The third field of the driver's address details.
CITY Historic TEXT The city that this driver lives in.
STATE Historic TEXT The state that this driver lives in.
REGION Historic TEXT The region that this driver lives in.
ZIP_CODE Historic TEXT The ZIP code for the area that this driver lives in. Applicable in the United States.
POSTCODE Historic TEXT The postcode of the area that this driver lives in. Applicable in countries that use a postcode.
COUNTRY Historic TEXT The country that this driver lives in.
PHONE_NUMBER_1 Historic TEXT The driver's primary phone number.
PHONE_NUMBER_2 Historic TEXT The driver's secondary or alternative phone number.
MOBILE_PHONE_NUMBER Historic TEXT The driver's mobile phone number.
EMPLOYEE_NUMBER Historic TEXT The driver's employee number.
HIRE_DATE Historic DATE The date when the driver was hired.
LEAVE_DATE Historic DATE The date when the driver left the organization.
LICENSE_NUMBER Historic TEXT The driver's unique driver's license number.
LICENSE_STATE Historic TEXT The state in which the driver's license was issued.
LICENSE_CLASS Historic TEXT The class of driver's license issued to the driver.
LICENSE_EXPIRY Historic DATE The expiration date of the driver's license.
INSURANCE_CARRIER Historic TEXT The driver's insurance carrier.
INSURANCE_ACCOUNT_NUMBER Historic TEXT The driver's insurance account number.
INSURANCE_EXPIRY Historic DATE The expiration date of the driver's insurance policy.
HIERARCHY Current VARIANT An array of hierarchy node names from top-level node down to the node that the driver is in. Note: Full Hierarchy, will need to parse to report on individual hierarchy.
HIERARCHY_IDS Current VARIANT An array of hierarchy node IDs from top-level node down to the node that the driver is in. Note: Full Hierarchy, will need to parse to report on individual hierarchy.
TEAMS Current VARIANT An array of names for the teams that the driver is part of.
TEAM_IDS Current VARIANT An array of IDs for the teams that the driver is part of.
EMAIL_ADDRESS Current TEXT The driver's email address.
SUPERVISOR_ID Historic TEXT A unique identifier for the Fleet user that this driver is supervised by.
WORKPLAN_VERSION Current TEXT The driver’s WorkPlan version.
HOS_RULE_SET_ID Current NUMBER The HOS rule set ID for the driver.
DEPOT_NAME Current TEXT The name of the driver's depot.
IS_CURRENT   BOOLEAN Whether this driver database entry is current or has been replaced by a newer copy.
START_TIME_UTC   TIMESTAMP_NTZ The time at which this video course entry was created, in UTC.
END_TIME_UTC   TIMESTAMP_NTZ The time at which this video course entry became historical, in UTC.
ROW_UPDATE_TIME   TIMESTAMP_NTZ The time, in UTC, when this entry was last updated.

Driver Day View (driver_day)

Column Name Data Type Description
DRIVER_ID NUMBER A unique identifier for the driver, used within Fleet. Use DRIVER_ID for grouping by this view.
DRIVER_KEY NUMBER A unique identifier for the driver, used within the Analytics server. Use DRIVER_KEY for joining this view.
DATE DATE The date for which the aggregation is done.
DISTANCE NUMBER The distance that the driver has driven, across vehicles, on the given date, in meters.
TOTAL_IDLE NUMBER The total time the driver spent idling on the given date, in seconds.
HARD_ACCEL NUMBER The number of hard acceleration events recorded for the driver on the given date.
HARD_BRAKE NUMBER The number of hard braking events recorded for the driver on the given date.
SEATBELT_VIOLATIONS NUMBER The number of seat belt violation events recorded for the driver on the given date.
SPEEDING_OVER_POSTED NUMBER The number of events recorded where the driver was speeding 10 MPH over the posted speed limit on the given date.
SPEEDING_EXCESSIVE NUMBER The number of events recorded where the driver was speeding 10 MPH over the posted speed limit on the given date.
ENGINE_TIME NUMBER The total engine running time recorded for this driver and date, in seconds.
FUEL_USED NUMBER The amount of fuel the driver used on the given date, in gallons or liters.
TOTAL_NON_PRODUCTIVE_IDLE NUMBER The total time the driver spent in non-productive idling on the given date, in seconds.
PTO_DURATION NUMBER The total time for which the PTO (power take off) is active on the given date, in seconds.
DRIVING_WITHOUT_SEATBELT NUMBER The total time for which the seatbelt was not in use for this driver on the given date.
DRIVING_WITHOUT_SEATBELT_TRIP_DURATION NUMBER Trip_duration used to calculate trip values for DRIVING_WITHOUT_SEATBELT metric.
TRIP_DISTANCE NUMBER The distance that the driver has driven, across vehicles, on the given date, in meters.
TRIP_FUEL_USED NUMBER The amount of fuel the driver used on the given date, in gallons or liters.
SPEEDING_COUNT_HIGH_BAND NUMBER The number of speeding events recorded where the driver was in the high band on the given date.
SPEEDING_COUNT_MED_BAND NUMBER The number of speeding events recorded where the driver was in the medium band on the given date.
SPEEDING_COUNT_LOW_BAND NUMBER The number of speeding events recorded where the driver was in the low band on the given date.
TIME_IN_ECO_BAND NUMBER Total time the driver was driving within a good economical range (1500 - 2500 RPM) on the given date.
TIME_IN_ECO_BAND_TRIP_DURATION NUMBER  
SPEEDING_OVER_65_MPH NUMBER The number of events recorded where the driver was traveling at a speed over 65 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SPEEDING_OVER_75_MPH NUMBER The number of events recorded where the driver was traveling at a speed over 75 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SPEEDING_OVER_80_MPH NUMBER The number of events recorded where the driver was traveling at a speed over 80 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SPEEDING_OVER_90_MPH NUMBER The number of events recorded where the driver was traveling at a speed over 90 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SPEEDING_OVER_100_MPH NUMBER The number of events recorded where the driver was traveling at a speed over 100 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SPEEDING_OVER_105_KMPH NUMBER The number of events recorded where the driver was traveling at a speed over 105 KPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SPEEDING_OVER_110_KMPH NUMBER The number of events recorded where the driver was traveling at a speed over 110 KPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SPEEDING_OVER_120_KMPH NUMBER The number of events recorded where the driver was traveling at a speed over 120 KPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
ACTIVE_MOVING_COUNT NUMBER Indicator of the driver’s activity on the given date. Equal to 1 if the driver was sufficiently active, and 0 otherwise.
SEATBELT_OFF_5_MILES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 5 miles on the given date.
SEATBELT_OFF_5_MILES_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger for more than 5 miles on the given date.
SEATBELT_OFF_10_MILES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 10 miles on the given date.
SEATBELT_OFF_10_MILES_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger for more than 10 miles on the given date.
SEATBELT_OFF_2_MINUTES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 2 minutes on the given date.
SEATBELT_OFF_2_MINUTES_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger for more than 2 minutes on the given date.
SEATBELT_OFF_10_MINUTES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 10 minutes on the given date.
SEATBELT_OFF_10_MINUTES_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger for more than 10 minutes on the given date.
SEATBELT_OFF_35_MPH_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver at the speed of more than 35 MPH on the given date.
SEATBELT_OFF_35_MPH_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger at the speed of more than 35 MPH on the given date.
SEATBELT_OFF_60_MPH_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver at the speed of more than 60 MPH on the given date.
SEATBELT_OFF_60_MPH_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger at the speed of more than 60 MPH on the given date.
TOTAL_TRIP_COUNT NUMBER Total count of trips the driver makes on the given date.
RPM_767_DURATION NUMBER Total count of RPM 767 events the driver makes on the given date.
FUEL_USED_IDLING NUMBER Total amount of fuel used while the driver’s vehicles were idling on the given date. If the vehicle reports fuel usage, this KPI is based on reported fuel usage during idle time. If the vehicle does not report fuel usage, this KPI is calculated based on a fixed value of 0.8 gallons per hour (3.028 liters per hour) multiplied by idle time.
DIAGNOSTIC_PTO_DURATION NUMBER The total time for which the PTO (power take off) is active on the given date, in seconds. Data based on diagnostic readings.
DRIVE_TIME_DURATION NUMBER The total time for which the driver was actively driving on the given date.
HARD_CORNERING NUMBER The number of events recorded where the driver was harshly cornering on the given date.
FIRST_ADDRESS_ID NUMBER The first driver’s address ID reported for the day.
LAST_ADDRESS_ID NUMBER The last driver’s address ID reported for the day.
SPEEDING_5_MPH_OVERPOSTED NUMBER The number of events recorded where the driver was speeding 5 MPH over the posted speed limit on the given date.
SPEEDING_10_MPH_OVERPOSTED NUMBER The number of events recorded where the driver was speeding 10 MPH over the posted speed limit on the given date.
SPEEDING_10_KMPH_OVERPOSTED NUMBER The number of events recorded where the driver was speeding 10 KPH over the posted speed limit on the given date.
SPEEDING_20_KMPH_OVERPOSTED NUMBER The number of events recorded where the driver was speeding 20 KPH over the posted speed limit on the given date.
SPEEDING_10_PERCENT_OVERPOSTED NUMBER The number of events recorded where the driver was speeding 10% over the posted speed limit on the given date.
SPEEDING_20_PERCENT_OVERPOSTED NUMBER The number of events recorded where the driver was speeding 20% over the posted speed limit on the given date.
SPEEDING_OVER_POSTED_5_MPH_2MIN NUMBER The number of events recorded where the driver was speeding 5 MPH over the posted speed limit for 2 minutes on the given date.
SPEEDING_OVER_POSTED_10_MPH_2MIN NUMBER The number of events recorded where the driver was speeding 10 MPH over the posted speed limit for 2 minutes on the given date.
SPEEDING_10_MPH_OVERPOSTED_DURATION_2MIN NUMBER Total duration of events recorded where the driver was speeding 10 MPH over the posted speed limit for 2 minutes on the given date.
SPEEDING_OVER_POSTED_10_KPH_2MIN NUMBER The number of events recorded where the driver was speeding 10 KPH over the posted speed limit for 2 minutes on the given date.
SPEEDING_OVER_POSTED_20_KPH_2MIN NUMBER The number of events recorded where the driver was speeding 20 KPH over the posted speed limit for 2 minutes on the given date.
SPEEDING_OVER_75_MPH_2MIN NUMBER The number of events recorded where the driver was speeding over 75 MPH for 2 minutes on the given date.
SPEEDING_OVER_85_2MIN_MPH NUMBER The number of events recorded where the driver was speeding over 85 MPH for 2 minutes on the given date.
SPEEDING_10_PERCENT_OVERPOSTED_2MIN NUMBER The number of events recorded where the driver was speeding 10% over the posted speed limit for 2 minutes on the given date.
SPEEDING_20_PERCENT_OVERPOSTED_2MIN NUMBER The number of events recorded where the driver was speeding 20% over the posted speed limit for 2 minutes on the given date.
IDLE_BANDED_0_5_MINUTES_EVENTS NUMBER Total count of events where the driver was not moving and the engine is on for a duration between 0 and 5 minutes on the given date.
IDLE_BANDED_5_10_MINUTES_EVENTS NUMBER Total count of events where the driver was not moving and the engine is on for a duration between 5 and 10 minutes on the given date.
IDLE_BANDED_10_15_MINUTES_EVENTS NUMBER Total count of events where the driver was not moving and the engine is on for a duration between 10 and 15 minutes on the given date.
IDLE_BANDED_15_30_MINUTES_EVENTS NUMBER Total count of events where the driver was not moving and the engine is on for a duration between 15 and 30 minutes on the given date.
IDLE_BANDED_30_60_MINUTES_EVENTS NUMBER Total count of events where the driver was not moving and the engine is on for a duration between 30 and 60 minutes on the given date.
IDLE_BANDED_60_1440_MINUTES_EVENTS NUMBER Total count of events where the driver was not moving and the engine is on for a duration between 60 and 1440 minutes on the given date.
IDLE_OVER_FIVE_MINUTES NUMBER Total count of events where the driver was not moving and the engine is on for longer than 5 minutes on the given date.
IDLE_OVER_TEN_MINUTES NUMBER Total count of events where the driver was not moving and the engine was on for longer than 10 minutes on the given date.
IDLE_OVER_FIFTEEN_MINUTES NUMBER Total count of events where the driver was not moving and the engine is on for longer than 15 minutes on the given date.
IDLE_OVER_THIRTY_MINUTES NUMBER Total count of events where the driver was not moving and the engine is on for longer than 30 minutes on the given date.
IDLE_OVER_SIXTY_MINUTES NUMBER Total count of events where the driver was not moving and the engine is on for longer than 60 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_0_5_MINUTES_EVENTS NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 0 and 5 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_5_10_MINUTES_EVENTS NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 5 and 10 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_10_15_MINUTES_EVENTS NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 10 and 15 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_15_30_MINUTES_EVENTS NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 15 and 30 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_30_60_MINUTES_EVENTS NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 30 and 60 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_60_1440_MINUTES_EVENTS NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 60 and 1440 minutes on the given date.
NON_PRODUCTIVE_IDLE_OVER_FIVE_MINUTES NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 5 minutes on the given date.
NON_PRODUCTIVE_IDLE_OVER_TEN_MINUTES NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 10 minutes on the given date.
NON_PRODUCTIVE_IDLE_OVER_FIFTEEN_MINUTES NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 15 minutes on the given date.
NON_PRODUCTIVE_IDLE_OVER_THIRTY_MINUTES NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 30 minutes on the given date.
NON_PRODUCTIVE_IDLE_OVER_SIXTY_MINUTES NUMBER Total count of events where the driver’s vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 60 minutes on the given date.
AIRBAG_DEPLOYED_EVENTS NUMBER The number of events recorded where an airbag was deployed for the driver on the given date.
SEATBELT_WARNING NUMBER The number of events recorded where the seat belt warning light was active for the driver on the given date.
EV_ENERGY_USED_MOTOR NUMBER The amount of energy used by the driver’s electric vehicle's motor on the given date.
EV_ENERGY_GENERATED_MOTOR NUMBER The amount of energy generated by the driver’s electric vehicle's motor on the given date.
EV_ENERGY_USED_HVAC NUMBER The amount of energy used by the HVAC (Heating, Ventilation, and Air Conditioning) systems in the driver’s electric vehicle's on the given date.
EV_ENERGY_USED_AUX NUMBER The amount of energy used by auxiliary systems (for example, lights and radio) in the driver’s electric vehicle's on the given date.
EV_ENERGY_USED_IDLE NUMBER The amount of energy used by the driver’s electric vehicle's while idle on the given date.
EV_ENERGY_USED_RECHARGING NUMBER The raw amount of electricity consumption that occurs during electric vehicle recharge for the driver on the given date.
EV_BATTERY_ENERGY_USED_RECHARGING NUMBER The amount of energy used when recharging the driver’s electric vehicle's on the given date.
EV_BATTERY_ENERGY_GAINED_RECHARGING NUMBER The gain in battery energy that occurs when recharging an electric vehicle for the driver on the given date.
EV_BATTERY_ENERGY_LOST_RECHARGING NUMBER The difference between power used recharging and battery level gained for the driver on the given date.
EV_RECHARGE_DURATION NUMBER The time duration that electric vehicles spend recharging for the driver on the given date.
EV_DISTANCE_IN_ECO_BAND NUMBER The distance traveled by electric vehicles inside a good economical range (1500 - 2500 RPM) for the driver on the given date.
EV_CO2_SAVINGS NUMBER The amount of CO2 emission prevented by using an electric vehicle for the driver on the given date.
EV_ENERGY_CONSUMED NUMBER The total amount of energy used by an electric vehicle for the driver on the given date.
LONGEST_ENGINE_TIME NUMBER The longest engine running time on each particular day for the driver on the given date.
ABS_COUNT NUMBER Total number of times the Anti-Lock Braking System (ABS) was engaged for the driver on the given date.
STABILITY_COUNT NUMBER Total number of times the Roll Over Protection (ROP) engine control unit or ROP brake control was engaged for the driver on the given date.
TRACTION_COUNT NUMBER Total number of times the Anti-Slip Regulation (ASR) was engaged for the driver on the given date.
SMARTSPEEDING_5_MPH_OVERPOSTED NUMBER Total count of events when the driver’s vehicle was speeding more than 5 MPH over the posted speed limit and the speed was faster than the Smart Speed.
SMARTSPEEDING_OVER_POSTED_5MPH_2MIN NUMBER Total count of events when a driver’s vehicle was speeding more than 5 MPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_10_MPH_OVERPOSTED NUMBER Total count of events when the driver’s vehicle was speeding more than 10 MPH over the posted speed limit and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_OVER_POSTED_10MPH_2MIN NUMBER Total count of events when a driver’s vehicle was speeding more than 10 MPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_10_KMPH_OVERPOSTED NUMBER Total count of events when the driver’s vehicle was speeding more than 10 KPH over the posted speed limit and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_OVER_POSTED_10_KPH_2MIN NUMBER Total count of events when a driver’s vehicle was speeding more than 10 KPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_20_KMPH_OVERPOSTED NUMBER Total count of events when the driver’s vehicle was speeding more than 20 KPH over the posted speed limit and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_OVER_POSTED_20_KPH_2MIN NUMBER Total count of events when a driver’s vehicle was speeding more than 20 KPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_10_PERCENT_OVERPOSTED NUMBER Total count of events when a driver’s vehicle was speeding more than 10% over the posted speed limit and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_10_PERCENT_OVERPOSTED_2MIN NUMBER Total count of events when a driver’s vehicle was speeding more than 10% over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_20_PERCENT_OVERPOSTED NUMBER Total count of events when a driver’s vehicle was speeding more than 20% over the posted speed limit and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_20_PERCENT_OVERPOSTED_2MIN NUMBER Total count of events when a driver’s vehicle was speeding more than 20% over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_COUNT_LOW_BAND NUMBER The number of speeding events recorded where the driver was in the low band and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_COUNT_MED_BAND NUMBER The number of speeding events recorded where the driver was in the medium band and the speed was faster than the Smart Speed on the given date.
ROW_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when the last entry for the driver was inserted in the Analytics database on the given date.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when the last entry for the driver was updated in the Analytics database on the given date.
WORKING_DURATION NUMBER The total time the driver was working on the given date, in seconds.

ELD Driving Period View (eld_driving_period)

Column Name Data Type Description
DRIVING_PERIOD_ID NUMBER A unique identifier for this driving period, used within Fleet and the Analytics server alike. Use DRIVING_PERIOD_ID for joining to this view.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for joining this view.
DRIVING_PERIOD_STATUS NUMBER Enumeration providing the status for this driving period.
PROPERTIES VARIANT JSON that contains properties like destination, distance and driving duration.
EVENTS VARIANT JSON array that contains all ELD events.
START_TIME_UTC TIMESTAMP_NTZ The time, in UTC, when this driving period started.
END_TIME_UTC TIMESTAMP_NTZ The time, in UTC, when this driving period ended.
USER_IANA_TIME_ZONE TEXT Relevant IANA time zone.

ELD Driving Period Action View (eld_driving_period_action)

Column Name Data Type Description
DRIVING_PERIOD_ACTION_ID NUMBER A unique identifier for this driving period action, used within Fleet and the Analytics server alike. Use DRIVING_PERIOD_ID for joining to this view.
DRIVING_PERIOD_ID NUMBER A unique identifier for associated driving period, used within Fleet and the Analytics server alike. Use DRIVING_PERIOD_ID for joining this view.
DRIVING_PERIOD_STATUS NUMBER Enumeration providing the status for associated driving period.
ACTION_TIME_UTC TIMESTAMP_NTZ The time, in UTC, when the action took place.
ROW_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when the row was inserted in the database.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when this row was last updated in the database.
USER_IANA_TIME_ZONE TEXT Relevant IANA time zone.

Event View (event)

Column Name Data Type Description
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.
EVENT_ID NUMBER A unique identifier for the particular event type.
EVENT_DESCRIPTION TEXT Description of the type of event that this relates to.
START_TIME TIMESTAMP_NTZ The start time of the event (in UTC).
END_TIME TIMESTAMP_NTZ The end time of the event (in UTC).
VALUE FLOAT The value pertaining to an event. Note that not all events have a value.
ONGOING BOOLEAN Indicates whether this event is ongoing, or still occurring as of the latest point received from a unit.

Hierarchy Node View (hierarchy_node)

Column Name Slow Changing Behavior Data Type Description
HIERARCHY_NODE_ID   NUMBER A unique identifier for the hierarchy node.
HIERARCHY_NODE_NAME Current TEXT The name of the hierarchy node.
PARENT_ID Current NUMBER The unique identifier of the parent node.
HIERARCHY_DEPTH Current NUMBER The depth (or level) of the hierarchy node within the hierarchy.
PATH Current VARIANT The full path of hierarchy node IDs up to and including this node (including all ancestors).
NAME_PATH Current VARIANT The full path of the names of the hierarchy nodes up to and including this node (including all ancestors).
ROW_UPDATE_TIME   TIMESTAMP_NTZ The time, in UTC, when this database entry was last updated.

Insight Alert View (insight_alert)

Column Name Data Type Description
ALERT_ID TEXT A unique identifier for this particular insight alert.
CONDITION_ID TEXT A unique identifier for the condition, used within Fleet. Use CONDITION_ID for grouping by this view.
CONDITION_KEY NUMBER A unique identifier for the condition, used within the Analytics server. Use CONDITION_KEY for joining this view.
ON_TIME_UNIT_TZ TIMESTAMP_NTZ The time that the criteria for the alert was satisfied (in local time).
OFF_TIME_UNIT_TZ TIMESTAMP_NTZ The time that the insight alert ended, and the criteria was no longer satisfied (in local time).
TRIGGER_TIME_UNIT_TZ TIMESTAMP_NTZ The time that the insight alert was first triggered (in local time).
ON_TIME_UTC TIMESTAMP_NTZ The time that the criteria for the alert was satisfied (in UTC).
OFF_TIME_UTC TIMESTAMP_NTZ The time that the insight alert ended, and the criteria was no longer satisfied (in UTC).
TRIGGER_TIME_UTC TIMESTAMP_NTZ The time that the insight alert was first triggered (in UTC).
DURATION_SECONDS NUMBER The duration (in seconds) that the insight alert was active for.
ON_ADDRESS TEXT The address applicable at the "On" time of the alert.
TRIGGER_STREET_NUMBER TEXT The street number applicable at the "Trigger" time" of the alert.
TRIGGER_ADDRESS TEXT The address applicable at the "Trigger" time of the alert.
OFF_ADDRESS TEXT The address applicable at the "Off" time of the alert.
SPEED_CMPS FLOAT The speed (in cm/s) when the alert was triggered (if applicable).
TRIGGER_SPEED_LIMIT_CMPS FLOAT The speed limit (in cm/s) that must be exceed in order to trigger the alert (if applicable).
POSTED_SPEED_LIMIT_CMPS FLOAT The posted speed limit (in cm/s) when the alert was triggered (if applicable).
TRIGGER_VALUE TEXT The entity that triggered the alert.
TRIGGER_NAME TEXT The type of entity being targeted by the Insight Alert.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
DRIVER_KEY NUMBER A unique identifier for this driver, used within the Analytics server. Use DRIVER_KEY for joining this view.
ADDRESS_ID NUMBER A unique identifier for this address, used within Fleet and the Analytics server alike. Use ADDRESS_ID for joining or grouping by this view.
MARKER_KEY NUMBER A unique identifier for this marker, used within the Analytics server. Use MARKER_KEY for joining this view.
TRIGGER_LAT FLOAT The latitude at the time the alert was triggered.
TRIGGER_LON FLOAT The longitude at the time the alert was triggered.
JOB_ID TEXT The attached job id for the alert (if applicable).
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when this entry was last updated.

Install Type Diagnostic Parameter (install_type_diagnostic_parameter)

Column Name Slow Changing Behavior Data Type Description
INSTALL_TYPE_ID   NUMBER The install type id that this diagnostic parameter belongs to.
TID   NUMBER The TID (ID) of the diagnostic parameter.
NAME Historic TEXT The name of the diagnostic parameter.
IS_CURRENT   BOOLEAN Whether this vehicle database entry is current or has been replaced by a newer copy.
START_TIME_UTC   TIMESTAMP_NTZ The time at which this entry was created, in UTC.
END_TIME_UTC   TIMESTAMP_NTZ The time at which this entry became historical, in UTC.
ROW_UPDATE_TIME   TIMESTAMP_NTZ The time, in UTC, when this entry was last updated.

Marker View (marker)

Column Name Slow Changing Behavior Data Type Description
MARKER_KEY   NUMBER A unique identifier for this marker, used within the Analytics server. Use MARKER_KEY for joining this view.
MARKER_ID   NUMBER A unique identifier for this marker, used within Fleet. Use MARKER_ID for grouping by this view.
MARKER_NAME Current TEXT The name of the marker.
MARKER_TYPE Historic NUMBER The type of the marker.
LATITUDE Historic FLOAT The latitude coordinate where the marker is located.
LONGITUDE Historic FLOAT The longitude coordinate where the marker is located.
GEOMETRY Historic TEXT The shape of the marker: "Circle" or "Polygon".
SHAPE Historic TEXT The detailed shape of the marker.
RADIUS Historic NUMBER The radius of the marker's area, if the marker's shape is a circle.
PRIMARY_CATEGORY_ID Current NUMBER The primary category ID that this marker is assigned to.
PRIMARY_CATEGORY_TAG Current TEXT The primary category tag that this marker is assigned to.
JSON_PROPERTIES Historic VARIANT A JSON object that contains all the unparsed data for the marker.
COUNTRY Current TEXT The country that the marker is in.
POSTCODE Current TEXT The postcode of the area that the marker is in. Applicable in countries that use a postcode.
ZIP Current TEXT The ZIP code for the area that the marker is in. Applicable in the United States.
REGION Current TEXT The region that the marker is in.
STATE Current TEXT The state that the marker is in.
CITY Current TEXT The city that the marker is in.
SUBURB Current TEXT The suburb that the marker is in.
STREET_NUMBER Current TEXT The street number that the marker is on.
STREET_NUMBER_TXT Current TEXT The street number that the marker is on.
STOP_ID Historic TEXT A unique identifier that can be used as stops for jobs and routes.
PRIMARY_TERRITORY_ID Historic TEXT The primary territory ID that this marker is assigned to.
TAGS Historic VARIANT The tags that are associated with this marker.
TAG_IDS Historic VARIANT The tag IDs that are associated with this marker.
INTERSECTION_LATITUDE Historic FLOAT The latitude coordinates where the marker address intersects with the street (where the driveway meets the road).
INTERSECTION_LONGITUDE Historic FLOAT The longitude coordinates where the marker address intersects with the street (where the driveway meets the road).
GENESIS Historic TEXT The genesis of the marker
SITE_ADDRESSES Current VARIANT The address of the sites associated with the marker.
SITE_DESCRIPTION Historic TEXT The description of the site associated with the marker.
PHONE_NUMBERS Current VARIANT Phone numbers associated with the marker.
IANA_TIME_ZONE Historic TEXT IANA time zone of the marker.
FOLLOWED_VEHICLE Historic NUMBER Unit ID that marker is set to be associated with.
REPORT_COLOR Current TEXT The report color of the marker.
IS_CURRENT   BOOLEAN Whether this marker database entry is current or has been replaced by a newer copy.
IS_CURATED Current BOOLEAN Whether this marker entry is curated or not.
START_TIME_UTC   TIMESTAMP_NTZ The time at which this video course entry was created, in UTC.
END_TIME_UTC   TIMESTAMP_NTZ The time at which this video course entry became historical, in UTC.
ROW_UPDATE_TIME   TIMESTAMP_NTZ The time, in UTC, when this entry was last updated.

Mobile Event Type View (mobile_event_type)

Column Name Slow Changing Behavior Data Type Description
MOBILE_EVENT_TYPE_KEY   NUMBER A unique identifier for this mobile event type, used within the Analytics server. Use MOBILE_EVENT_TYPE_KEY for joining this view.
MOBILE_EVENT_TYPE_ID   NUMBER A unique identifier for this mobile event type, used within Fleet. Use MOBILE_EVENT_TYPE_ID for grouping by this view.
EVENT_NAME Current TEXT The name of the mobile event type.
IS_CURRENT   BOOLEAN Whether this mobile event type database entry is current or has been replaced by a newer copy.

Non-Reporting-Unit View (nru_event)

Column Name Data Type Description
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
DRIVER_ID NUMBER A unique identifier for this driver, used within Fleet. Use DRIVER_ID for joining this view.
DRIVER_KEY NUMBER A unique identifier for this driver, used within the Analytics server. Use DRIVER_KEY for joining this view.
ADDRESS_ID NUMBER The address where the unit was at the beginning of the NRU event.
STREET_NUMBER TEXT The street number where the unit was at the beginning of the NRU event.
CATEGORY TEXT The suspected reason for the NRU event.
START_TIME_UNIT_TZ TIMESTAMP_NTZ The local time when the unit entered the non reporting state.
END_TIME_UNIT_TZ TIMESTAMP_NTZ The local time when the unit began reporting again.
LAST_REPORT_TIME_UNIT_TZ TIMESTAMP_NTZ The local time when the unit last reported.
START_TIME_UTC TIMESTAMP_NTZ The time (in UTC) when the unit entered the non reporting state.
END_TIME_UTC TIMESTAMP_NTZ The time (in UTC) when the unit began reporting again.
PROCESSED_TIME_UTC TIMESTAMP_NTZ The time (in UTC) when this data was generated.
THRESHOLD_DAYS NUMBER The number of days configured for this vehicle to be considered non-reporting.
NOT_REPORTING_FOR_DAYS NUMBER The duration of the NRU event in days.

Planned Vs Actual Job View (job_pva)

Column Name Data Type Description
JOB_ID TEXT An identifier for this job, used within the Fleet and Analytics server alike. Use JOB_ID for joining to this view.
ROUTE_ID TEXT An identifier for the associated route, used within the Fleet and Analytics server alike. Use ROUTE_ID for joining this view.
TERRITORY_KEY NUMBER A unique identifier for this territory within the Analytics server. Use TERRITORY_KEY for joining this view.
TERRITORY_ID TEXT An identifier for this territory, used within the Fleet. Use TERRITORY_ID for joining this view.
MARKER_KEY NUMBER A unique identifier for the marker this job is at, used within the Analytics server. Use MARKER_KEY for joining this view.
MARKER_ID NUMBER A unique identifier for the marker this job is at, used within Fleet. Use MARKER_ID for joining this view.
NAME TEXT Name of this job.
STATUS NUMBER Enumeration providing the status for this job.
PLANNED_ARRIVAL_TIME_UTC TIMESTAMP_NTZ Planned time of arrival, in UTC.
ACTUAL_ARRIVAL_TIME_UTC TIMESTAMP_NTZ Actual time of arrival, in UTC.
PLANNED_DEPARTURE_TIME_UTC TIMESTAMP_NTZ Planned time of departure, in UTC.
ACTUAL_DEPARTURE_TIME_UTC TIMESTAMP_NTZ Actual time of departure, in UTC.
PLANNED_STOP_NUMBER NUMBER Planned stop number.
ACTUAL_STOP_NUMBER NUMBER Actual stop number.
PROPERTIES TEXT JSON that contains all the properties for this job.
ROW_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when the row was inserted in the database.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when this row was last updated in the database.

Planned Vs Actual Route View (route_pva)

Column Name Data Type Description
ROUTE_ID TEXT An identifier for this route, used within the Fleet and Analytics server alike. Use ROUTE_ID for joining to this view.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for joining this view.
DRIVER_KEY NUMBER A unique identifier for the driver, used within the Analytics server. Use DRIVER_KEY for joining this view.
DRIVER_ID NUMBER A unique identifier for the driver, used within Fleet. Use DRIVER_ID for joining this view.
TERRITORY_KEY NUMBER A unique identifier for this territory within the Analytics server. Use TERRITORY_KEY for joining this view.
TERRITORY_ID TEXT An identifier for this territory, used within the Fleet. Use TERRITORY_ID for joining this view.
START_DEPOT_MARKER_KEY NUMBER A unique identifier for the marker the route starts at, used within the Analytics server. Use START_DEPOT_MARKER_KEY for joining this view.
START_DEPOT_MARKER_ID NUMBER A unique identifier for the marker the route starts at, used within Fleet. Use START_DEPOT_MARKER_ID for joining this view.
END_DEPOT_MARKER_KEY NUMBER A unique identifier for the marker the route ends at, used within the Analytics server. Use END_DEPOT_MARKER_KEY for joining this view.
END_DEPOT_MARKER_ID NUMBER A unique identifier for the marker the route ends at, used within Fleet. Use END_DEPOT_MARKER_ID for joining this view.
NAME TEXT Name of this route.
STATUS NUMBER Enumeration providing the status for this route.
PLANNED_DISTANCE_METERS NUMBER Planned distance to be covered for this route, in meters.
ACTUAL_DISTANCE_METERS NUMBER Actual distance to be covered for this route, in meters.
PLANNED_TIME_SECONDS NUMBER Planned duration for this route, in seconds.
ACTUAL_TIME_SECONDS NUMBER Actual duration for this route, in seconds.
PLANNED_START_TIME_UTC TIMESTAMP_NTZ Planned start time for this route, in UTC.
ACTUAL_START_TIME_UTC TIMESTAMP_NTZ Actual start time for this route, in UTC.
PLANNED_END_TIME_UTC TIMESTAMP_NTZ Planned end time for this route, in UTC.
ACTUAL_END_TIME_UTC TIMESTAMP_NTZ Actual end time for this route, in UTC.
JOB_COUNT NUMBER Count of jobs on this route.
COMPLETED_JOB_COUNT NUMBER Count of jobs that were completed.
JOBS_COMPLETED_IN_SEQUENCE NUMBER Count of jobs that were completed in sequence.
JOBS_COMPLETED_OUT_OF_SEQUENCE NUMBER Count of jobs that were completed out of sequence.
PUNCH_IN_TIME_UTC TIMESTAMP_NTZ Time the driver punched in, in UTC.
PUNCH_OUT_TIME_UTC TIMESTAMP_NTZ Time the driver punched out, in UTC.
ROW_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when the row was inserted in the database.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when this row was last updated in the database.

Point With Vehicle View (point_with_vehicle)

Column Name Data Type Description
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
TIME TIMESTAMP_NTZ The time when the point data was recorded.
LAT FLOAT The latitude coordinate where the vehicle was at the given time.
LON FLOAT The longitude coordinate where the vehicle was at the given time.
DIAGS OBJECT A JSON object that contains all diagnostics triggered. Details about the diagnostic IDs are available on the TID Information table.
DTC_LIST ARRAY An array of DTC (diagnostic trouble codes) received.
SPEED_CMPS NUMBER The speed of the vehicle in centimeters per second.
FLAG_IGN_ON BOOLEAN Whether the ignition was on at the given time.
FLAG_PRIVACY_MODE BOOLEAN Whether the vehicle was in private mode at the given time.
DELTA_ODO_M NUMBER The delta odometer reading in meters.
GPS_QUALITY NUMBER An Enum providing the GPS quality level: 0 = Off, 1 = NoFix, 2 = Unreliable, 3 = Excellent
GPS_TIME TIMESTAMP_NTZ The timestamp when this GPS point was recorded.
GPS_TZ_OFFSET_MINUTES NUMBER The time zone offset, in minutes, for the recorded GPS time.
HILBERT_INDEX NUMBER See Hilbert-R-tree for further details
ENGINE_ON BOOLEAN Whether the engine was on at the given time.
ADDRESS OBJECT The address where the vehicle was at the given time.
PAVED_ROAD BOOLEAN Whether the vehicle was on a paved road at the given time.
PRIVATE_ROAD BOOLEAN Whether the vehicle was on a private road at the given time.
ROAD_SEG_DISTANCE FLOAT The distance, in meters, to the closest road, when the vehicle is off road.
_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when the point was inserted in the Analytics database.

Point With Vehicle and Driver View (point_with_vehicle_and_driver)

Column Name Data Type Description
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
DRIVER_KEY NUMBER A unique identifier for this driver, used within the Analytics server. Use DRIVER_KEY for joining this view.
TIME TIMESTAMP_NTZ The time when the point data was recorded.
LAT FLOAT The latitude coordinate where the driver and vehicle were at the given time.
LON FLOAT The longitude coordinate where the driver and vehicle were at the given time.
DIAGS OBJECT A JSON object that contains all diagnostics triggered. Details about the diagnostic IDs are available on the TID Information table.
DTC_LIST ARRAY An array of DTC (diagnostic trouble codes) received.
SPEED_CMPS NUMBER The speed of the vehicle in centimeters per second.
FLAG_IGN_ON BOOLEAN Whether the ignition was on at the given time.
FLAG_PRIVACY_MODE BOOLEAN Whether the vehicle was in privacy mode at the given time.
DELTA_ODO_M NUMBER The delta odometer reading in meters.
GPS_QUALITY NUMBER An enum providing the GPS quality level: 0 = Off, 1 = NoFix, 2 = Unreliable, 3 = Excellent
GPS_TIME TIMESTAMP_NTZ The timestamp when this GPS point was recorded.
GPS_TZ_OFFSET_MINUTES NUMBER The time zone offset, in minutes, for the recorded GPS time.
HILBERT_INDEX NUMBER See Hilbert-R-tree for further details
ENGINE_ON BOOLEAN Whether the engine was on at the given time.
ADDRESS OBJECT The address where the driver and vehicle were at the given time.
PAVED_ROAD BOOLEAN Whether the vehicle was on a paved road at the given time.
PRIVATE_ROAD BOOLEAN Whether the vehicle was on a private road at the given time.
ROAD_SEG_DISTANCE FLOAT The distance, in meters, to the closest road, when the vehicle is off road.
_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when the point was inserted in the Analytics database.

Territory View (territory)

Column Name Data Type Description
TERRITORY_KEY NUMBER A unique identifier for this territory within the Analytics server. Use TERRITORY_KEY for joining to this view.
TERRITORY_ID TEXT An identifier for this territory, used within the Fleet. Use TERRITORY_ID for joining this view.
TERRITORY_NAME TEXT Name of this territory.
TIME_ZONE TEXT Relevant time zone.
START_TIME_UTC TIMESTAMP_NTZ The time at which this entry was created, in UTC.
END_TIME_UTC TIMESTAMP_NTZ The time at which this entry became historical, in UTC.
IS_CURRENT BOOLEAN Whether this database entry is current or has been replaced by a newer copy.
ROW_UPDATE_TIME TIMESTAMP_NTZ/td> The time, in UTC, when this entry was last updated.

Time on Site View (time_on_site)

Column Name Data Type Description
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
MARKER_KEY NUMBER A unique identifier for the marker, used within the Analytics server. Use MARKER_KEY for joining this view.
ENTRY_TIMESTAMP TIMESTAMP_NTZ The local time when the vehicle entered the site.
EXIT_TIMESTAMP TIMESTAMP_NTZ The local time when the vehicle left the site.
TIME_ON_SITE NUMBER The total amount of time the vehicle spent on the site in seconds.
MAX_SPEED NUMBER The maximum speed of the vehicle while on the site in centimeters per second.
MIN_SPEED NUMBER The minimum speed of the vehicle while on the site in centimeters per second.
ENTRY_TIMESTAMP_UTC TIMESTAMP_NTZ The time (in UTC) when the vehicle entered the site.
EXIT_TIMESTAMP_UTC TIMESTAMP_NTZ The time (in UTC) when the vehicle left the site.
ROW_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when the last entry for the trip was inserted in the Analytics database.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when the last entry for the trip was updated in the Analytics database.

Trip View (trip)

Column Name Data Type Description
TRIP_ID NUMBER A unique identifier for the trip, used within Fleet. Use TRIP_ID for grouping by this view.
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.
DRIVER_ID NUMBER A unique identifier for the driver, used within Fleet. Use DRIVER_ID for grouping by this view.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
DRIVER_KEY NUMBER A unique identifier for the driver, used within the Analytics server. Use DRIVER_KEY for joining this view.
START_MARKER_IDS ARRAY The marker IDs at which this trip began. Maps to the Marker view.
START_MARKER_KEYS ARRAY The marker keys at which this trip ended. Maps to the Marker view.
END_MARKER_IDS ARRAY The marker IDs associated with the end of the trip.
END_MARKER_KEYS ARRAY The marker keys associated with the end of the trip.
START_TIME_UTC TIMESTAMP_NTZ The time at which this trip began, in UTC.
END_TIME_UTC TIMESTAMP_NTZ The time at which this trip ended, in UTC.
START_TIME_UNIT_TZ TIMESTAMP_NTZ The start time as recorded on the hardware unit installed in the vehicle.
END_TIME_UNIT_TZ TIMESTAMP_NTZ The end time as recorded on the hardware unit installed in the vehicle.
TRIP_DURATION NUMBER The duration of the trip, in seconds.
TOTAL_DISTANCE NUMBER Total distance traveled in this trip, in meters.
FUEL_USED NUMBER The amount of fuel used in this trip, in milliliters.
DRIVE_DURATION NUMBER The driving duration of this trip, in seconds.
WORKING_DURATION NUMBER The working duration of this trip, in seconds.
ON_SITE_DURATION NUMBER The on-site duration of this trip, in seconds.
PREIDLE_DURATION NUMBER The pre-idle state duration of this trip, in seconds.
POSTIDLE_DURATION NUMBER The post-idle state duration of this trip, in seconds.
PTO_DURATION NUMBER The duration of PTO (Power Take Off, for off-board pony engine applications such as boom arms and pumps) used in this trip, in seconds.
HARD_ACCEL NUMBER The number of hard acceleration events recorded during this trip.
HARD_BRAKE NUMBER The number of hard braking events recorded during this trip.
SEATBELT_VIOLATIONS NUMBER The number of seat belt violation events recorded during this trip.
SPEEDING_OVER_POSTED NUMBER The number of speeding over posted violation events recorded during this trip.
SPEEDING_EXCESSIVE NUMBER The number of excessive speeding events recorded during this trip.
ENGINE_TIME NUMBER The engine run-time duration during this trip, in seconds.
NON_PRODUCTIVE_PREIDLE_DURATION NUMBER The duration of the trip spent in a non-productive pre-idle state, in seconds.
START_ODO NUMBER The vehicle odometer reading at the start of the trip, in meters.
END_ODO NUMBER The vehicle odometer reading at the end of the trip, in meters.
DTC_COUNT NUMBER The number of diagnostic trouble codes (DTCs) logged during the trip.
SPEEDING_OVER_POSTED_WITHOUT_EDITS NUMBER The number of events triggered by speeding over the posted speed limit by 10 MPH or more on links without a speed limit edited using the SVACS speed limit editor.
DRIVING_WITHOUT_SEATBELT NUMBER The total time for which the seatbelt was not in use during the trip.
DRIVING_WITHOUT_SEATBELT_TRIP_DURATION NUMBER Trip_duration used to calculate trip values for DRIVING_WITHOUT_SEATBELT metric.
TRIP_DISTANCE NUMBER Total distance traveled in this trip, in meters.
TRIP_FUEL_USED NUMBER The amount of fuel used in this trip, in milliliters.
SPEEDING_COUNT_HIGH_BAND NUMBER The number of speeding in the high band events recorded during the trip.
SPEEDING_COUNT_MED_BAND NUMBER The number of speeding in the medium band events recorded during the trip.
SPEEDING_COUNT_LOW_BAND NUMBER The number of speeding in the low band events recorded during the trip.
TIME_IN_ECO_BAND NUMBER Total time driven within a good economical range (1500 - 2500 RPM) during the trip.
TIME_IN_ECO_BAND_TRIP_DURATION NUMBER Trip_duration used to calculate trip values for TIME_IN_ECO_BAND metric.
SPEEDING_OVER_65_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 65 MPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_75_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 75 MPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_80_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 80 MPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_90_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 90 MPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_100_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 100 MPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_105_KMPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 105 KPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_110_KMPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 110 KPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SPEEDING_OVER_120_KMPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 120 KPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SEATBELT_OFF_5_MILES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 5 miles during the trip.
SEATBELT_OFF_5_MILES_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger for more than 5 miles during the trip.
SEATBELT_OFF_10_MILES_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger for more than 10 miles during the trip.
SEATBELT_OFF_10_MILES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 10 miles during the trip.
SEATBELT_OFF_2_MINUTES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 2 minutes during the trip.
SEATBELT_OFF_2_MINUTES_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger for more than 2 minutes during the trip.
SEATBELT_OFF_10_MINUTES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 10 minutes during the trip.
SEATBELT_OFF_10_MINUTES_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger for more than 10 minutes during the trip.
SEATBELT_OFF_35_MPH_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver at the speed of more than 35 MPH during the trip.
SEATBELT_OFF_35_MPH_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger at the speed of more than 35 MPH during the trip.
SEATBELT_OFF_60_MPH_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver at the speed of more than 60 MPH during the trip.
SEATBELT_OFF_60_MPH_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger at the speed of more than 60 MPH during the trip.
RPM_767_DURATION NUMBER Total duration of RPM 767 events during the trip.
FUEL_USED_IDLING NUMBER Total amount of fuel used while the vehicle was idling during the trip. If the vehicle reports fuel usage, this KPI is based on reported fuel usage during idle time. If the vehicle does not report fuel usage, this KPI is calculated based on a fixed value of 0.8 gallons per hour (3.028 liters per hour) multiplied by idle time.
DIAGNOSTIC_PTO_DURATION NUMBER The total time for which the PTO (power take off) is active during the trip, in seconds. Data based on diagnostic readings.
HARD_CORNERING NUMBER The number of events recorded where the driver was harshly cornering during the trip.
FIRST_ADDRESS_ID NUMBER The first address ID reported for the trip.
FIRST_STREET_NUMBER TEXT The first address’s street number reported for the trip.
LAST_ADDRESS_ID NUMBER The last address ID reported for the trip.
LAST_STREET_NUMBER TEXT The last address’s street number reported for the trip.
LAST_REPORTED_DEF_LEVEL NUMBER The last fill level of the vehicle's DEF tank reported for the trip in percent, shown in increments of 5%.
IS_DEF_LEVEL_KNOWN BOOLEAN Whether the fill level of the vehicle's DEF tank is known or not.
LAST_DEF_LEVEL_REPORT_TIME TIMESTAMP_NTZ The last time fill level of the vehicle's DEF tank was reported for the trip.
RPM_307 NUMBER Total count of RPM 767 events during the trip.
START_LATITUDE FLOAT The latitude coordinate of where the trip started.
START_LONGITUDE FLOAT The longitude coordinate of where the trip started.
STOP_LATITUDE FLOAT The latitude coordinate where the trip ended.
STOP_LONGITUDE FLOAT The longitude coordinate where the trip ended.
FIRST_STREET_NUMBER_TXT TEXT The first address’s street number reported for the trip.
LAST_STREET_NUMBER_TXT TEXT The last address’s street number reported for the trip.
SPEEDING_5_MPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit during the trip.
SPEEDING_10_MPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit during the trip.
SPEEDING_10_KMPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit during the trip.
SPEEDING_20_KMPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit during the trip.
SPEEDING_10_PERCENT_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 10% over the posted speed limit during the trip.
SPEEDING_20_PERCENT_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 20% over the posted speed limit during the trip.
IDLE_BANDED_0_5_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 0 and 5 minutes during the trip.
IDLE_BANDED_5_10_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 5 and 10 minutes during the trip.
IDLE_BANDED_10_15_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 10 and 15 minutes during the trip.
IDLE_BANDED_15_30_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 15 and 30 minutes during the trip.
IDLE_BANDED_30_60_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 30 and 60 minutes during the trip.
IDLE_BANDED_60_1440_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 60 and 1440 minutes during the trip.
IDLE_OVER_FIVE_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 5 minutes during the trip.
IDLE_OVER_FIFTEEN_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 15 minutes during the trip.
IDLE_OVER_THIRTY_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 30 minutes during the trip.
IDLE_OVER_SIXTY_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 60 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_0_5_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 0 and 5 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_5_10_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 5 and 10 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_10_15_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 10 and 15 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_15_30_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 15 and 30 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_30_60_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 30 and 60 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_60_1440_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 60 and 1440 minutes during the trip.
NON_PRODUCTIVE_IDLE_OVER_FIVE_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 5 minutes during the trip.
NON_PRODUCTIVE_IDLE_OVER_TEN_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 10 minutes during the trip.
NON_PRODUCTIVE_IDLE_OVER_FIFTEEN_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 15 minutes during the trip.
NON_PRODUCTIVE_IDLE_OVER_THIRTY_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 30 minutes during the trip.
NON_PRODUCTIVE_IDLE_OVER_SIXTY_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 60 minutes during the trip.
SPEEDING_OVER_75_MPH_2MIN NUMBER The number of events recorded where the vehicle was speeding over 75 MPH for 2 minutes during the trip.
SPEEDING_10_MPH_OVERPOSTED_DURATION_2MIN NUMBER Total duration of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes during the trip.
SPEEDING_20_PERCENT_OVERPOSTED_2MIN NUMBER The number of events recorded where the vehicle was speeding 20% over the posted speed limit for 2 minutes during the trip.
SPEEDING_10_PERCENT_OVERPOSTED_2MIN NUMBER The number of events recorded where the vehicle was speeding 10% over the posted speed limit for 2 minutes during the trip.
AIRBAG_DEPLOYED_EVENTS NUMBER The number of events recorded where an airbag was deployed during the trip.
MINIMUM_BATTERY_VOLTAGE NUMBER The lowest battery voltage recorded during the trip.
MAXIMUM_BATTERY_VOLTAGE NUMBER The highest battery voltage recorded during the trip.
DEF_LEVEL_WARNING NUMBER Total number of times the DEF (Diesel Exhaust Fluid) level warning light was active during the trip.
MINIMUM_OIL_LIFE_REMAINING NUMBER The lowest oil life time recorded during the trip. The oil life time is the time remaining before an oil change is due.
MAXIMUM_OIL_LIFE_REMAINING NUMBER The highest oil life time recorded during the trip. The oil life time is the time remaining before an oil change is due.
OIL_LIFE_WARNING NUMBER Total number of times that the oil life remaining warning light was active during the trip.
LOW_TIRE_PRESSURE_WARNING NUMBER Total number of times that the low tire pressure warning light was active during the trip.
WATER_IN_FUEL_WARNING NUMBER Total number of times that the water in fuel warning light was active during the trip.
MIL_CEL_STATUS NUMBER The number of times the malfunction indicator lamp (MIL), or check engine light, was active during the trip.
AIRBAG_WARNING NUMBER Total number of times the airbag warning light was active during the trip.
LIFE_TIME_ENGINE_HOURS NUMBER Maximum reported Total Engine Hours during the trip.
MINIMUM_COOLANT_TEMPERATURE NUMBER Minimum reported coolant temperature during the trip.
MAXIMUM_COOLANT_TEMPERATURE NUMBER Maximum reported coolant temperature during the trip.
VEHICLE_MAX_SPEED NUMBER Maximum reported speed during the trip.
VEHICLE_AVG_SPEED NUMBER Average reported speed during the trip.
SEATBELT_WARNING NUMBER The number of events recorded where the seat belt warning light was active during the trip.
SPEEDING_OVER_85_2MIN_MPH NUMBER The number of events recorded where the vehicle was speeding over 85 MPH for 2 minutes during the trip.
SPEEDING_OVER_POSTED_5_MPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit for 2 minutes during the trip.
SPEEDING_OVER_POSTED_10_MPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes during the trip.
SPEEDING_OVER_POSTED_10_KPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit for 2 minutes during the trip.
SPEEDING_OVER_POSTED_20_KPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit for 2 minutes during the trip.
FUEL_LEVEL_PERCENTAGE NUMBER The fuel level at the end of the trip.
FUEL_RAIL_PRESSURE_MIN NUMBER Minimum reported fuel rail pressure during the trip.
FUEL_RAIL_PRESSURE_MAX NUMBER Maximum reported fuel rail pressure during the trip.
FUEL_RAIL_PRESSURE_AVG NUMBER Average reported fuel rail pressure during the trip.
MANIFOLD_PRESSURE_MIN NUMBER Minimum reported manifold pressure during the trip.
MANIFOLD_PRESSURE_MAX NUMBER Maximum reported manifold pressure during the trip.
MANIFOLD_PRESSURE_AVG NUMBER Average reported manifold pressure during the trip.
TRIP_PTO_FUEL_USED NUMBER The total amount of PTO fuel used in this trip.
DEF_REGEN_ACTIVE NUMBER Indicator of the Diesel Particulate Filter Regeneration during the trip. Equal to 1 if the Diesel Particulate Filter was being regenerated and 0 otherwise.
DEF_REGEN_LIGHT_ON NUMBER Indicator of the Diesel Particulate Filter Regeneration Light during the trip. Equal to 1 if the Diesel Particulate Filter regeneration status light was on and 0 otherwise.
UREA_TANK_CONTAMINATED NUMBER Indicator of the Diesel Exhaust Fluid Quality Warning during the trip. Equal to 1 if the Diesel Exhaust Fluid (DEF) injection system has determined the urea tank was contaminated and 0 otherwise.
DPF_SOOT_LEVEL_MIN NUMBER Minimum reported percentage of soot accumulation in the diesel particulate filter during the trip.
DPF_SOOT_LEVEL_MAX NUMBER Maximum reported percentage of soot accumulation in the diesel particulate filter during the trip.
DPF_SOOT_LEVEL_AVG NUMBER Average reported percentage of soot accumulation in the diesel particulate filter during the trip.
ACCELERATOR_POSITION_MIN NUMBER Minimum reported level of the accelerator pedal engagement during the trip.
ACCELERATOR_POSITION_MAX NUMBER Maximum reported level of the accelerator pedal engagement during the trip.
ACCELERATOR_POSITION_AVG NUMBER Average reported level of the accelerator pedal engagement during the trip.
RPM_MIN NUMBER Minimum reported RPM during the trip.
RPM_MAX NUMBER Maximum reported RPM during the trip.
RPM_AVG NUMBER Average reported RPM during the trip.
AVERAGE_COOLANT_TEMPERATURE NUMBER Average reported coolant temperature during the trip.
EV_ENERGY_USED_MOTOR NUMBER The amount of energy used by the electric vehicle's motor during the trip.
EV_ENERGY_GENERATED_MOTOR NUMBER The amount of energy generated by the electric vehicle's motor during the trip.
EV_ENERGY_USED_HVAC NUMBER The amount of energy used by the HVAC (Heating, Ventilation, and Air Conditioning) systems in the electric vehicles during the trip.
EV_ENERGY_USED_AUX NUMBER The amount of energy used by auxiliary systems (for example, lights and radio) in the electric vehicles during the trip.
EV_ENERGY_USED_IDLE NUMBER The amount of energy used by the electric vehicles while idle during the trip.
EV_ENERGY_USED_RECHARGING NUMBER The raw amount of electricity consumption that occurs during electric vehicle recharge during the trip.
EV_BATTERY_ENERGY_USED_RECHARGING NUMBER The amount of energy used when recharging the electric vehicles during the trip.
EV_BATTERY_ENERGY_GAINED_RECHARGING NUMBER The gain in battery energy that occurs when recharging an electric vehicle during the trip.
EV_BATTERY_ENERGY_LOST_RECHARGING NUMBER The difference between power used recharging and battery level gained during the trip.
EV_RECHARGE_DURATION NUMBER The time duration that electric vehicles spend recharging during the trip.
EV_DISTANCE_IN_ECO_BAND NUMBER The distance traveled by electric vehicles inside a good economical range (1500 - 2500 RPM) during the trip.
ABS_COUNT NUMBER Total number of times the Anti-Lock Braking System (ABS) was engaged during the trip.
STABILITY_COUNT NUMBER Total number of times the Roll Over Protection (ROP) engine control unit or ROP brake control was engaged during the trip.
TRACTION_COUNT NUMBER Total number of times the Anti-Slip Regulation (ASR) was engaged during the trip.
IGNITION_ON_TIME_UNIT_TZ TIMESTAMP_NTZ The time when the vehicle’s ignition was turned on.
IGNITION_OFF_TIME_UNIT_TZ TIMESTAMP_NTZ The time when the vehicle’s ignition was turned off.
DEPARTURE_TIME_UNIT_TZ TIMESTAMP_NTZ The departure time associated with the trip.
ARRIVAL_TIME_UNIT_TZ TIMESTAMP_NTZ The arrival time associated with the trip.
SMARTSPEEDING_5_MPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 5 MPH over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_10_MPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 10 MPH over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_OVER_POSTED_10MPH_2MIN NUMBER Total count of events when the vehicle was speeding more than 10 MPH over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_10_KMPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 10 KPH over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_OVER_POSTED_10_KPH_2MIN NUMBER Total count of events when the vehicle was speeding more than 10 KPH over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_20_KMPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 20 KPH over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_OVER_POSTED_20_KPH_2MIN NUMBER Total count of events when the vehicle was speeding more than 20 KPH over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_10_PERCENT_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 10% over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_10_PERCENT_OVERPOSTED_2MIN NUMBER Total count of events when the vehicle was speeding more than 10% over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_20_PERCENT_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 20% over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_20_PERCENT_OVERPOSTED_2MIN NUMBER Total count of events when the vehicle was speeding more than 20% over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_COUNT_LOW_BAND NUMBER The number of speeding events recorded where the vehicle was in the low band and the speed was faster than the Smart Speed during the trip.
SMARTSPEEDING_COUNT_MED_BAND NUMBER The number of speeding events recorded where the vehicle was in the medium band and the speed was faster than the Smart Speed during the trip.
SMARTSPEEDING_OVER_POSTED_5MPH_2MIN NUMBER Total count of events when the vehicle was speeding more than 5 MPH over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
LINKED_VEHICLE_NAME TEXT The name of the vehicle associated with the trip.
LINKED_DRIVER_NAME TEXT The name of the driver associated with the trip.
NATURAL_GAS_USED NUMBER The amount of natural gas used on the trip.
ROW_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when the last entry for the trip was inserted in the Analytics database.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when the last entry for the trip was updated in the Analytics database.
IDLE_OVER_TEN_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine was on for longer than 10 minutes on the given date.
VEHICLE_NAME TEXT The name of the vehicle associated with the trip.
DRIVER_NAME TEXT The name of the driver associated with the trip.
UTC_OFFSET NUMBER The offset between the trip’s local time and UTC in seconds.
DISTANCE NUMBER The distance traveled in this trip, in meters.
HARSH_CORNERING NUMBER The number of events recorded where the vehicle was harshly cornering during the trip.
TOTAL_IDLE NUMBER The total idle time recorded for this trip, in seconds.
TOTAL_NON_PRODUCTIVE_IDLE NUMBER The total non-productive idle time recorded for this trip, in seconds.
VEHICLE_SPEED_MAX NUMBER Maximum reported vehicle speed during the trip.

Trip by State View (trip_by_state)

Column Name Data Type Description
TRIP_ID NUMBER A unique identifier for the trip, used within Fleet. Use TRIP_ID for grouping by this view.
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.
DRIVER_ID NUMBER A unique identifier for the driver, used within Fleet. Use DRIVER_ID for grouping by this view.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
DRIVER_KEY NUMBER A unique identifier for the driver, used within the Analytics server. Use DRIVER_KEY for joining this view.
START_MARKER_IDS ARRAY The marker IDs at which this trip began. Maps to the Marker view.
START_MARKER_KEYS ARRAY The marker keys at which this trip ended. Maps to the Marker view.
END_MARKER_IDS ARRAY The marker IDs associated with the end of the trip.
END_MARKER_KEYS ARRAY The marker keys associated with the end of the trip.
START_TIME_UTC TIMESTAMP_NTZ The time at which this trip began, in UTC.
END_TIME_UTC TIMESTAMP_NTZ The time at which this trip ended, in UTC.
START_TIME_UNIT_TZ TIMESTAMP_NTZ The start time as recorded on the hardware unit installed in the vehicle.
END_TIME_UNIT_TZ TIMESTAMP_NTZ The end time as recorded on the hardware unit installed in the vehicle.
TRIP_DURATION NUMBER The duration of the trip, in seconds.
TOTAL_DISTANCE NUMBER Total distance traveled in this trip, in meters.
FUEL_USED NUMBER The amount of fuel used in this trip, in milliliters.
DRIVE_DURATION NUMBER The driving duration of this trip, in seconds.
WORKING_DURATION NUMBER The working duration of this trip, in seconds.
ON_SITE_DURATION NUMBER The on-site duration of this trip, in seconds.
PREIDLE_DURATION NUMBER The pre-idle state duration of this trip, in seconds.
POSTIDLE_DURATION NUMBER The post-idle state duration of this trip, in seconds.
PTO_DURATION NUMBER The duration of PTO (Power Take Off, for off-board pony engine applications such as boom arms and pumps) used in this trip, in seconds.
HARD_ACCEL NUMBER The number of hard acceleration events recorded during this trip.
HARD_BRAKE NUMBER The number of hard braking events recorded during this trip.
SEATBELT_VIOLATIONS NUMBER The number of seat belt violation events recorded during this trip.
SPEEDING_OVER_POSTED NUMBER The number of speeding over posted violation events recorded during this trip.
SPEEDING_EXCESSIVE NUMBER The number of excessive speeding events recorded during this trip.
ENGINE_TIME NUMBER The engine run-time duration during this trip, in seconds.
NON_PRODUCTIVE_PREIDLE_DURATION NUMBER The duration of the trip spent in a non-productive pre-idle state, in seconds.
START_ODO NUMBER The vehicle odometer reading at the start of the trip, in meters.
END_ODO NUMBER The vehicle odometer reading at the end of the trip, in meters.
DTC_COUNT NUMBER The number of diagnostic trouble codes (DTCs) logged during the trip.
SPEEDING_OVER_POSTED_WITHOUT_EDITS NUMBER The number of events triggered by speeding over the posted speed limit by 10MPH or more on links without a speed limit edited using the SVACS speed limit editor.
DRIVING_WITHOUT_SEATBELT NUMBER The total time for which the seatbelt was not in use during the trip.
DRIVING_WITHOUT_SEATBELT_TRIP_DURATION NUMBER Trip_duration used to calculate trip values for DRIVING_WITHOUT_SEATBELT metric.
TRIP_DISTANCE NUMBER Total distance traveled in this trip, in meters.
TRIP_FUEL_USED NUMBER The amount of fuel used in this trip, in milliliters.
SPEEDING_COUNT_HIGH_BAND NUMBER The number of speeding in the high band events recorded during the trip.
SPEEDING_COUNT_MED_BAND NUMBER The number of speeding in the medium band events recorded during the trip.
SPEEDING_COUNT_LOW_BAND NUMBER The number of speeding in the low band events recorded during the trip.
TIME_IN_ECO_BAND NUMBER Total time driven within a good economical range (1500 - 2500 RPM) during the trip.
TIME_IN_ECO_BAND_TRIP_DURATION NUMBER Trip_duration used to calculate trip values for TIME_IN_ECO_BAND metric.
SPEEDING_OVER_65_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 65 MPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_75_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 75 MPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_80_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 80 MPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_90_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 90 MPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_100_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 100 MPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_105_KMPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 105 KPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_110_KMPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 110 KPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SPEEDING_OVER_120_KMPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 120 KPH during the trip. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.
SEATBELT_OFF_5_MILES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 5 miles during the trip.
SEATBELT_OFF_5_MILES_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger for more than 5 miles during the trip.
SEATBELT_OFF_10_MILES_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger for more than 10 miles during the trip.
SEATBELT_OFF_10_MILES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 10 miles during the trip.
SEATBELT_OFF_2_MINUTES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 2 minutes during the trip.
SEATBELT_OFF_2_MINUTES_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger for more than 2 minutes during the trip.
SEATBELT_OFF_10_MINUTES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 10 minutes during the trip.
SEATBELT_OFF_10_MINUTES_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger for more than 10 minutes during the trip.
SEATBELT_OFF_35_MPH_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver at the speed of more than 35 MPH during the trip.
SEATBELT_OFF_35_MPH_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger at the speed of more than 35 MPH during the trip.
SEATBELT_OFF_60_MPH_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver at the speed of more than 60 MPH during the trip.
SEATBELT_OFF_60_MPH_PASSENGER NUMBER The total time for which the seatbelt was not in use by a passenger at the speed of more than 60 MPH during the trip.
RPM_767_DURATION NUMBER Total duration of RPM 767 events during the trip.
FUEL_USED_IDLING NUMBER Total amount of fuel used while the vehicle was idling during the trip. If the vehicle reports fuel usage, this KPI is based on reported fuel usage during idle time. If the vehicle does not report fuel usage, this KPI is calculated based on a fixed value of 0.8 gallons per hour (3.028 liters per hour) multiplied by idle time.
DIAGNOSTIC_PTO_DURATION NUMBER The total time for which the PTO (power take off) is active during the trip, in seconds. Data based on diagnostic readings.
HARD_CORNERING NUMBER The number of events recorded where the driver was harshly cornering during the trip.
FIRST_ADDRESS_ID NUMBER The first address ID reported for the trip.
FIRST_STREET_NUMBER TEXT The first address’s street number reported for the trip.
LAST_ADDRESS_ID NUMBER The last address ID reported for the trip.
LAST_STREET_NUMBER TEXT The last address’s street number reported for the trip.
LAST_REPORTED_DEF_LEVEL NUMBER The last fill level of the vehicle's DEF tank reported for the trip in percent, shown in increments of 5%.
IS_DEF_LEVEL_KNOWN BOOLEAN Whether the fill level of the vehicle's DEF tank is known or not.
LAST_DEF_LEVEL_REPORT_TIME TIMESTAMP_NTZ The last time fill level of the vehicle's DEF tank was reported for the trip.
RPM_307 NUMBER Total count of RPM 767 events during the trip.
START_LATITUDE FLOAT The latitude coordinate of where the trip started.
START_LONGITUDE FLOAT The longitude coordinate of where the trip started.
STOP_LATITUDE FLOAT The latitude coordinate where the trip ended.
STOP_LONGITUDE FLOAT The longitude coordinate where the trip ended.
FIRST_STREET_NUMBER_TXT TEXT The first address’s street number reported for the trip.
LAST_STREET_NUMBER_TXT TEXT The last address’s street number reported for the trip.
SPEEDING_5_MPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit during the trip.
SPEEDING_10_MPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit during the trip.
SPEEDING_10_KMPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit during the trip.
SPEEDING_20_KMPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit during the trip.
SPEEDING_10_PERCENT_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 10% over the posted speed limit during the trip.
SPEEDING_20_PERCENT_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 20% over the posted speed limit during the trip.
IDLE_BANDED_0_5_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 0 and 5 minutes during the trip.
IDLE_BANDED_5_10_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 5 and 10 minutes during the trip.
IDLE_BANDED_10_15_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 10 and 15 minutes during the trip.
IDLE_BANDED_15_30_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 15 and 30 minutes during the trip.
IDLE_BANDED_30_60_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 30 and 60 minutes during the trip.
IDLE_BANDED_60_1440_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 60 and 1440 minutes during the trip.
IDLE_OVER_FIVE_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 5 minutes during the trip.
IDLE_OVER_FIFTEEN_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 15 minutes during the trip.
IDLE_OVER_THIRTY_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 30 minutes during the trip.
IDLE_OVER_SIXTY_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 60 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_0_5_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 0 and 5 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_5_10_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 5 and 10 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_10_15_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 10 and 15 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_15_30_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 15 and 30 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_30_60_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 30 and 60 minutes during the trip.
NON_PRODUCTIVE_IDLE_BANDED_60_1440_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 60 and 1440 minutes during the trip.
NON_PRODUCTIVE_IDLE_OVER_FIVE_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 5 minutes during the trip.
NON_PRODUCTIVE_IDLE_OVER_TEN_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 10 minutes during the trip.
NON_PRODUCTIVE_IDLE_OVER_FIFTEEN_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 15 minutes during the trip.
NON_PRODUCTIVE_IDLE_OVER_THIRTY_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 30 minutes during the trip.
NON_PRODUCTIVE_IDLE_OVER_SIXTY_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 60 minutes during the trip.
SPEEDING_OVER_75_MPH_2MIN NUMBER The number of events recorded where the vehicle was speeding over 75 MPH for 2 minutes during the trip.
SPEEDING_10_MPH_OVERPOSTED_DURATION_2MIN NUMBER Total duration of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes during the trip.
SPEEDING_20_PERCENT_OVERPOSTED_2MIN NUMBER The number of events recorded where the vehicle was speeding 20% over the posted speed limit for 2 minutes during the trip.
SPEEDING_10_PERCENT_OVERPOSTED_2MIN NUMBER The number of events recorded where the vehicle was speeding 10% over the posted speed limit for 2 minutes during the trip.
AIRBAG_DEPLOYED_EVENTS NUMBER The number of events recorded where an airbag was deployed during the trip.
MINIMUM_BATTERY_VOLTAGE NUMBER The lowest battery voltage recorded during the trip.
MAXIMUM_BATTERY_VOLTAGE NUMBER The highest battery voltage recorded during the trip.
DEF_LEVEL_WARNING NUMBER Total number of times the DEF (Diesel Exhaust Fluid) level warning light was active during the trip.
MINIMUM_OIL_LIFE_REMAINING NUMBER The lowest oil life time recorded during the trip. The oil life time is the time remaining before an oil change is due.
MAXIMUM_OIL_LIFE_REMAINING NUMBER The highest oil life time recorded during the trip. The oil life time is the time remaining before an oil change is due.
OIL_LIFE_WARNING NUMBER Total number of times that the oil life remaining warning light was active during the trip.
LOW_TIRE_PRESSURE_WARNING NUMBER Total number of times that the low tire pressure warning light was active during the trip.
WATER_IN_FUEL_WARNING NUMBER Total number of times that the water in fuel warning light was active during the trip.
MIL_CEL_STATUS NUMBER The number of times the malfunction indicator lamp (MIL), or check engine light, was active during the trip.
AIRBAG_WARNING NUMBER Total number of times the airbag warning light was active during the trip.
LIFE_TIME_ENGINE_HOURS NUMBER Maximum reported Total Engine Hours during the trip.
MINIMUM_COOLANT_TEMPERATURE NUMBER Minimum reported coolant temperature during the trip.
MAXIMUM_COOLANT_TEMPERATURE NUMBER Maximum reported coolant temperature during the trip.
VEHICLE_MAX_SPEED NUMBER Maximum reported speed during the trip.
VEHICLE_AVG_SPEED NUMBER Average reported speed during the trip.
SEATBELT_WARNING NUMBER The number of events recorded where the seat belt warning light was active during the trip.
SPEEDING_OVER_85_2MIN_MPH NUMBER The number of events recorded where the vehicle was speeding over 85 MPH for 2 minutes during the trip.
SPEEDING_OVER_POSTED_5_MPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit for 2 minutes during the trip.
SPEEDING_OVER_POSTED_10_MPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes during the trip.
SPEEDING_OVER_POSTED_10_KPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit for 2 minutes during the trip.
SPEEDING_OVER_POSTED_20_KPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit for 2 minutes during the trip.
FUEL_LEVEL_PERCENTAGE NUMBER The fuel level at the end of the trip.
FUEL_RAIL_PRESSURE_MIN NUMBER Minimum reported fuel rail pressure during the trip.
FUEL_RAIL_PRESSURE_MAX NUMBER Maximum reported fuel rail pressure during the trip.
FUEL_RAIL_PRESSURE_AVG NUMBER Average reported fuel rail pressure during the trip.
MANIFOLD_PRESSURE_MIN NUMBER Minimum reported manifold pressure during the trip.
MANIFOLD_PRESSURE_MAX NUMBER Maximum reported manifold pressure during the trip.
MANIFOLD_PRESSURE_AVG NUMBER Average reported manifold pressure during the trip.
TRIP_PTO_FUEL_USED NUMBER The total amount of PTO fuel used in this trip.
DEF_REGEN_ACTIVE NUMBER Indicator of the Diesel Particulate Filter Regeneration during the trip. Equal to 1 if the Diesel Particulate Filter was being regenerated and 0 otherwise.
DEF_REGEN_LIGHT_ON NUMBER Indicator of the Diesel Particulate Filter Regeneration Light during the trip. Equal to 1 if the Diesel Particulate Filter regeneration status light was on and 0 otherwise.
UREA_TANK_CONTAMINATED NUMBER Indicator of the Diesel Exhaust Fluid Quality Warning during the trip. Equal to 1 if the Diesel Exhaust Fluid (DEF) injection system has determined the urea tank was contaminated and 0 otherwise.
DPF_SOOT_LEVEL_MIN NUMBER Minimum reported percentage of soot accumulation in the diesel particulate filter during the trip.
DPF_SOOT_LEVEL_MAX NUMBER Maximum reported percentage of soot accumulation in the diesel particulate filter during the trip.
DPF_SOOT_LEVEL_AVG NUMBER Average reported percentage of soot accumulation in the diesel particulate filter during the trip.
ACCELERATOR_POSITION_MIN NUMBER Minimum reported level of the accelerator pedal engagement during the trip.
ACCELERATOR_POSITION_MAX NUMBER Maximum reported level of the accelerator pedal engagement during the trip.
ACCELERATOR_POSITION_AVG NUMBER Average reported level of the accelerator pedal engagement during the trip.
RPM_MIN NUMBER Minimum reported RPM during the trip.
RPM_MAX NUMBER Maximum reported RPM during the trip.
RPM_AVG NUMBER Average reported RPM during the trip.
AVERAGE_COOLANT_TEMPERATURE NUMBER Average reported coolant temperature during the trip.
EV_ENERGY_USED_MOTOR NUMBER The amount of energy used by the electric vehicle's motor during the trip.
EV_ENERGY_GENERATED_MOTOR NUMBER The amount of energy generated by the electric vehicle's motor during the trip.
EV_ENERGY_USED_HVAC NUMBER The amount of energy used by the HVAC (Heating, Ventilation, and Air Conditioning) systems in the electric vehicles during the trip.
EV_ENERGY_USED_AUX NUMBER The amount of energy used by auxiliary systems (for example, lights and radio) in the electric vehicles during the trip.
EV_ENERGY_USED_IDLE NUMBER The amount of energy used by the electric vehicles while idle during the trip.
EV_ENERGY_USED_RECHARGING NUMBER The raw amount of electricity consumption that occurs during electric vehicle recharge during the trip.
EV_BATTERY_ENERGY_USED_RECHARGING NUMBER The amount of energy used when recharging the electric vehicles during the trip.
EV_BATTERY_ENERGY_GAINED_RECHARGING NUMBER The gain in battery energy that occurs when recharging an electric vehicle during the trip.
EV_BATTERY_ENERGY_LOST_RECHARGING NUMBER The difference between power used recharging and battery level gained during the trip.
EV_RECHARGE_DURATION NUMBER The time duration that electric vehicles spend recharging during the trip.
EV_DISTANCE_IN_ECO_BAND NUMBER The distance traveled by electric vehicles inside a good economical range (1500 - 2500 RPM) during the trip.
ABS_COUNT NUMBER Total number of times the Anti-Lock Braking System (ABS) was engaged during the trip.
STABILITY_COUNT NUMBER Total number of times the Roll Over Protection (ROP) engine control unit or ROP brake control was engaged during the trip.
TRACTION_COUNT NUMBER Total number of times the Anti-Slip Regulation (ASR) was engaged during the trip.
IGNITION_ON_TIME_UNIT_TZ TIMESTAMP_NTZ The time when the vehicle’s ignition was turned on.
IGNITION_OFF_TIME_UNIT_TZ TIMESTAMP_NTZ The time when the vehicle’s ignition was turned off.
DEPARTURE_TIME_UNIT_TZ TIMESTAMP_NTZ The departure time associated with the trip.
ARRIVAL_TIME_UNIT_TZ TIMESTAMP_NTZ The arrival time associated with the trip.
SMARTSPEEDING_5_MPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 5 MPH over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_10_MPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 10 MPH over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_OVER_POSTED_10MPH_2MIN NUMBER Total count of events when the vehicle was speeding more than 10 MPH over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_10_KMPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 10 KPH over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_OVER_POSTED_10_KPH_2MIN NUMBER Total count of events when the vehicle was speeding more than 10 KPH over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_20_KMPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 20 KPH over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_OVER_POSTED_20_KPH_2MIN NUMBER Total count of events when the vehicle was speeding more than 20 KPH over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_10_PERCENT_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 10% over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_10_PERCENT_OVERPOSTED_2MIN NUMBER Total count of events when the vehicle was speeding more than 10% over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_20_PERCENT_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 20% over the posted speed limit during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_20_PERCENT_OVERPOSTED_2MIN NUMBER Total count of events when the vehicle was speeding more than 20% over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
SMARTSPEEDING_COUNT_LOW_BAND NUMBER The number of speeding events recorded where the vehicle was in the low band and the speed was faster than the Smart Speed during the trip.
SMARTSPEEDING_COUNT_MED_BAND NUMBER The number of speeding events recorded where the vehicle was in the medium band and the speed was faster than the Smart Speed during the trip.
SMARTSPEEDING_OVER_POSTED_5MPH_2MIN NUMBER Total count of events when the vehicle was speeding more than 5 MPH over the posted speed limit for a duration of more than 2 minutes during the trip and the speed was faster than the Smart Speed.
LINKED_VEHICLE_NAME TEXT The name of the vehicle associated with the trip.
LINKED_DRIVER_NAME TEXT The name of the driver associated with the trip.
NATURAL_GAS_USED NUMBER The amount of natural gas used on the trip.
ROW_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when the last entry for the trip was inserted in the Analytics database.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when the last entry for the trip was updated in the Analytics database.
IDLE_OVER_TEN_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine was on for longer than 10 minutes on the given date.
VEHICLE_NAME TEXT The name of the vehicle associated with the trip.
DRIVER_NAME TEXT The name of the driver associated with the trip.
UTC_OFFSET NUMBER The offset between the trip’s local time and UTC in seconds.
DISTANCE NUMBER The distance traveled in this trip, in meters.
HARSH_CORNERING NUMBER The number of events recorded where the vehicle was harshly cornering during the trip.
TOTAL_IDLE NUMBER The total idle time recorded for this trip, in seconds.
TOTAL_NON_PRODUCTIVE_IDLE NUMBER The total non-productive idle time recorded for this trip, in seconds.
VEHICLE_SPEED_MAX NUMBER Maximum reported vehicle speed during the trip.

Unit Driver History View (unit_driver_history)

Column Name Data Type Description
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet.
DRIVER_ID NUMBER A unique identifier for the driver, used within Fleet.
FROM_TIME_UTC TIMESTAMP_NTZ The time at which the assignment began.
TO_TIME_UTC TIMESTAMP_NTZ The time at which the assignment ended. Null value when the assignment is ongoing.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when this database entry was last updated.

Vehicle View (vehicle)

Column Name Slow Changing Behavior Data Type Description
VEHICLE_KEY   NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
VEHICLE_ID   NUMBER A unique identifier for the vehicle, used within Fleet. Use VEHICLE_ID for grouping by this view.
VEHICLE_NAME Current TEXT The vehicle's display name.
FUEL_TYPE Historic TEXT The type of fuel that the vehicle uses.
YEAR Historic TEXT The year that the vehicle was made.
MAKE Historic TEXT The vehicle's make.
MODEL Historic TEXT The vehicle's model.
VIN Historic TEXT The unique Vehicle Identification Number (VIN) of the vehicle.
COLOR Historic TEXT The vehicle's color.
REGO Historic TEXT The vehicle's registration details (number plate).
VEHICLE_TYPE Historic TEXT The vehicle's type, as defined in Fleet.
ENGINE_SERIAL Historic TEXT The unique serial number of the vehicle’s engine.
JSON_HIERARCHY Current VARIANT An array of hierarchy node names from top-level node down to the node that the vehicle is in.
JSON_HIERARCHY_IDS Current VARIANT An array of hierarchy node IDs from top-level node down to the node that the vehicle is in.
HIERARCHY Current VARIANT An array of hierarchy node names from top-level node down to the node that the vehicle is in.
HIERARCHY_IDS Current VARIANT An array of hierarchy node IDs from top-level node down to the node that the vehicle is in.
INACTIVE   BOOLEAN Whether the vehicle is inactive.
FLEETS Current VARIANT An array of names for the fleets that the vehicle is part of.
FLEET_IDS Current VARIANT An array of IDs for the fleets that the vehicle is part of.
TAG_IDS Historic VARIANT An array of vehicle tag IDs that have been defined in Fleet.
TAGS Historic VARIANT An array of vehicle tags that have been defined in Fleet.
OEM_NAME Historic TEXT The name of the OEM (original equipment manufacturer) or vehicle manufacturer.
CLASS Historic TEXT The vehicle class.
ENGINE_TYPE Historic TEXT The type of engine that is in the vehicle.
BODY_TYPE Historic TEXT The body type of the vehicle, for example dry van or refrigerated.
ASSET_TYPE_NAME Historic TEXT The name of the asset type associated with the vehicle, as defined in Fleet.
VEHICLE_CATEGORY Historic TEXT The vehicle category, as defined in Fleet.
ASSET_TYPE_ID Historic NUMBER The ID of the asset type associated with the vehicle, as defined in Fleet.
INSTALL_TYPE_NAME Historic TEXT The name of the install type associated with the vehicle, as defined in Fleet.
INSTALL_TYPE_ID Historic NUMBER The name of the install type associated with the vehicle, as defined in Fleet.
DEPOT_NAME Current TEXT The name of the vehicle's depot.
ELECTRONIC_SERIAL_NUMBER Current TEXT The serial number of the GPS unit installed in the vehicle.
UNIT_ID   NUMBER A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.
LICENSE_STATUS Current TEXT The current billing status of the vehicle within Fleet.
IS_CURRENT   BOOLEAN Whether this vehicle database entry is current or has been replaced by a newer copy.
START_TIME_UTC   TIMESTAMP_NTZ The time at which this video course entry was created, in UTC.
END_TIME_UTC   TIMESTAMP_NTZ The time at which this video course entry became historical, in UTC.
ROW_UPDATE_TIME   TIMESTAMP_NTZ The time, in UTC, when this entry was last updated.

Vehicle Day View (vehicle_day)

Column Name Data Type Description
UNIT_ID NUMBER A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.
VEHICLE_KEY NUMBER A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.
DATE DATE The date for which the aggregation is done.
START_TIME_UTC TIMESTAMP_NTZ The start time of the vehicle day, in UTC time zone.
END_TIME_UTC TIMESTAMP_NTZ The end time of the vehicle day, in UTC time zone.
DISTANCE NUMBER The distance that the vehicle has traveled on the given date, in meters.
TOTAL_IDLE NUMBER The total time the vehicle spent idling on the given date, in seconds.
HARD_ACCEL NUMBER The number of hard acceleration events recorded for the vehicle on the given date.
HARD_BRAKE NUMBER The number of hard braking events recorded for the vehicle on the given date.
SEATBELT_VIOLATIONS NUMBER The number of seatbelt violation events recorded for the vehicle on the given date.
SPEEDING_OVER_POSTED NUMBER The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit on the given date.
SPEEDING_EXCESSIVE NUMBER The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit on the given date.
ENGINE_TIME NUMBER The total engine running time recorded for this vehicle and date, in seconds.
FUEL_USED NUMBER The amount of fuel the vehicle used on the given date, in gallons or liters.
TOTAL_NON_PRODUCTIVE_IDLE NUMBER The total time the vehicle spent in non-productive idling on the given date, in seconds.
DTC_COUNT NUMBER The number of diagnostic trouble codes (DTCs) logged for this vehicle on the given date.
PTO_DURATION NUMBER The total time for which the PTO (power take off) is active on the given date, in seconds.
DRIVING_WITHOUT_SEATBELT NUMBER The total time for which the seatbelt was not in use for this vehicle on the given date.
DRIVING_WITHOUT_SEATBELT_TRIP_DURATION NUMBER Trip_duration used to calculate trip values for DRIVING_WITHOUT_SEATBELT metric.
TRIP_DISTANCE NUMBER The distance that the vehicle has driven, on the given date, in meters.
TRIP_FUEL_USED NUMBER The amount of fuel the vehicle used on the given date, in gallons or liters.
SPEEDING_COUNT_HIGH_BAND NUMBER The number of speeding events recorded where the vehicle was in the high band on the given date.
SPEEDING_COUNT_MED_BAND NUMBER The number of speeding events recorded where the vehicle was in the medium band on the given date.
SPEEDING_COUNT_LOW_BAND NUMBER The number of speeding events recorded where the vehicle was in the low band on the given date.
TIME_IN_ECO_BAND NUMBER Total time the vehicle was driving within a good economical range (1500 - 2500 RPM) on the given date.
TIME_IN_ECO_BAND_TRIP_DURATION NUMBER Trip_duration used to calculate trip values for TIME_IN_ECO_BAND metric.
SPEEDING_OVER_65_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 65 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_75_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 75 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_80_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 80 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_90_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 90 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_100_MPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 100 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_105_KMPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 105 KPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_110_KMPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 110 KPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
SPEEDING_OVER_120_KMPH NUMBER The number of events recorded where the vehicle was traveling at a speed over 120 KPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted. 
ACTIVE_MOVING_COUNT NUMBER Indicator of the vehicle’s activity on the given date. Equal to 1 if the driver was sufficiently active and 0 otherwise.
SEATBELT_OFF_5_MILES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 5 miles for the vehicle on the given date.
SEATBELT_OFF_5_MILES_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger for more than 5 miles for the vehicle on the given date.
SEATBELT_OFF_10_MILES_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver for more than 10 miles for the vehicle on the given date.
SEATBELT_OFF_10_MILES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger for more than 10 miles for the vehicle on the given date.
SEATBELT_OFF_2_MINUTES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 2 minutes for the vehicle on the given date.
SEATBELT_OFF_2_MINUTES_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger for more than 2 minutes for the vehicle on the given date.
SEATBELT_OFF_10_MINUTES_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver for more than 10 minutes for the vehicle on the given date.
SEATBELT_OFF_10_MINUTES_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger for more than 10 minutes for the vehicle on the given date.
SEATBELT_OFF_35_MPH_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver at the speed of more than 35 MPH for the vehicle on the given date.
SEATBELT_OFF_35_MPH_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger at the speed of more than 35 MPH for the vehicle on the given date.
SEATBELT_OFF_60_MPH_DRIVER NUMBER The total time for which the seatbelt was not in use by the driver at the speed of more than 60 MPH for the vehicle on the given date.
SEATBELT_OFF_60_MPH_PASSENGER NUMBER The total time for which the seatbelt was not in use by the driver’s passenger at the speed of more than 60 MPH for the vehicle on the given date.
TOTAL_TRIP_COUNT NUMBER Total count of trips the vehicle makes on the given date.
RPM_767_DURATION NUMBER Total count of RPM 767 events the vehicle makes on the given date.
FUEL_USED_IDLING NUMBER Total amount of fuel used while the vehicle was idling on the given date. If the vehicle reports fuel usage, this KPI is based on reported fuel usage during idle time. If the vehicle does not report fuel usage, this KPI is calculated based on a fixed value of 0.8 gallons per hour (3.028 liters per hour) multiplied by idle time.
DIAGNOSTIC_PTO_DURATION NUMBER The total time for which the PTO (power take off) was active on the given date, in seconds. Data based on diagnostic readings.
DRIVE_TIME_DURATION NUMBER The total time for which the vehicle was actively driving on the given date.
HARD_CORNERING NUMBER The number of events recorded where the vehicle was harshly cornering on the given date.
FIRST_ADDRESS_ID NUMBER The first vehicle’s address ID reported for the day.
LAST_ADDRESS_ID NUMBER The last vehicle’s address ID reported for the day.
LAST_REPORTED_DEF_LEVEL NUMBER The last fill level of the vehicle's DEF tank reported for the day in percent, shown in increments of 5%.
IS_DEF_LEVEL_KNOWN BOOLEAN Whether the fill level of the vehicle's DEF tank is known or not.
LAST_DEF_LEVEL_REPORT_TIME TIMESTAMP_NTZ The last time fill level of the vehicle's DEF tank was reported for the day.
SPEEDING_5_MPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit on the given date.
SPEEDING_10_MPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit on the given date.
SPEEDING_10_KMPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit on the given date.
SPEEDING_20_KMPH_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit on the given date.
SPEEDING_10_PERCENT_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 10% over the posted speed limit on the given date.
SPEEDING_20_PERCENT_OVERPOSTED NUMBER The number of events recorded where the vehicle was speeding 20% over the posted speed limit on the given date.
IDLE_BANDED_0_5_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 0 and 5 minutes on the given date.
IDLE_BANDED_5_10_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 5 and 10 minutes on the given date.
IDLE_BANDED_10_15_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 10 and 15 minutes on the given date.
IDLE_BANDED_15_30_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 15 and 30 minutes on the given date.
IDLE_BANDED_30_60_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 30 and 60 minutes on the given date.
IDLE_BANDED_60_1440_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving and the engine is on for a duration between 60 and 1440 minutes on the given date.
IDLE_OVER_FIVE_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 5 minutes on the given date.
IDLE_OVER_TEN_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine was on for longer than 10 minutes on the given date.
IDLE_OVER_FIFTEEN_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 15 minutes on the given date.
IDLE_OVER_THIRTY_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 30 minutes on the given date.
IDLE_OVER_SIXTY_MINUTES NUMBER Total count of events where the vehicle was not moving and the engine is on for longer than 60 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_0_5_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 0 and 5 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_5_10_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 5 and 10 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_10_15_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 10 and 15 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_15_30_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 15 and 30 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_30_60_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 30 and 60 minutes on the given date.
NON_PRODUCTIVE_IDLE_BANDED_60_1440_MINUTES_EVENTS NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 60 and 1440 minutes on the given date.
NON_PRODUCTIVE_IDLE_OVER_FIVE_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 5 minutes on the given date.
NON_PRODUCTIVE_IDLE_OVER_TEN_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 10 minutes on the given date.
NON_PRODUCTIVE_IDLE_OVER_FIFTEEN_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 15 minutes on the given date.
NON_PRODUCTIVE_IDLE_OVER_THIRTY_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 30 minutes on the given date.
NON_PRODUCTIVE_IDLE_OVER_SIXTY_MINUTES NUMBER Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 60 minutes on the given date.
SPEEDING_OVER_75_MPH_2MIN NUMBER The number of events recorded where the vehicle was speeding over 75 MPH for 2 minutes on the given date.
SPEEDING_10_MPH_OVERPOSTED_DURATION_2MIN NUMBER Total duration of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes on the given date.
SPEEDING_20_PERCENT_OVERPOSTED_2MIN NUMBER The number of events recorded where the vehicle was speeding 20% over the posted speed limit for 2 minutes on the given date.
SPEEDING_10_PERCENT_OVERPOSTED_2MIN NUMBER The number of events recorded where the vehicle was speeding 10% over the posted speed limit for 2 minutes on the given date.
AIRBAG_DEPLOYED_EVENTS NUMBER The number of events recorded where an airbag was deployed for the vehicle on the given date.
MINIMUM_BATTERY_VOLTAGE NUMBER The lowest battery voltage recorded for the vehicle on the given date.
MAXIMUM_BATTERY_VOLTAGE NUMBER The highest battery voltage recorded for the vehicle on the given date.
DEF_LEVEL_WARNING NUMBER Total number of times the DEF (Diesel Exhaust Fluid) level warning light was active for the vehicle on the given date.
MINIMUM_OIL_LIFE_REMAINING NUMBER The lowest oil life time recorded for the vehicle on the given date. The oil life time is the time remaining before an oil change is due.
MAXIMUM_OIL_LIFE_REMAINING NUMBER The highest oil life time recorded for the vehicle on the given date. The oil life time is the time remaining before an oil change is due.
OIL_LIFE_WARNING NUMBER Total number of times that the oil life remaining warning light was active for the vehicle on the given date.
LOW_TIRE_PRESSURE_WARNING NUMBER Total number of times that the low tire pressure warning light was active for the vehicle on the given date.
WATER_IN_FUEL_WARNING NUMBER Total number of times that the water in fuel warning light was active for the vehicle on the given date.
MIL_CEL_STATUS NUMBER The number of times the malfunction indicator lamp (MIL), or check engine light, was active for the vehicle on the given date.
AIRBAG_WARNING NUMBER Total number of times the airbag warning light was active for the vehicle on the given date.
LIFE_TIME_ENGINE_HOURS NUMBER Maximum reported Total Engine Hours for the vehicle on the given date.
MINIMUM_COOLANT_TEMPERATURE NUMBER Minimum reported coolant temperature for the vehicle on the given date.
MAXIMUM_COOLANT_TEMPERATURE NUMBER Maximum reported coolant temperature for the vehicle on the given date.
VEHICLE_MAX_SPEED NUMBER Maximum reported speed for the vehicle on the given date.
SEATBELT_WARNING NUMBER The number of events recorded where the seat belt warning light was active for the vehicle on the given date.
SPEEDING_OVER_85_2MIN_MPH NUMBER The number of events recorded where the vehicle was speeding over 85 MPH for 2 minutes on the given date.
SPEEDING_OVER_POSTED_5_MPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit for 2 minutes on the given date.
SPEEDING_OVER_POSTED_10_MPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes on the given date.
SPEEDING_OVER_POSTED_10_KPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit for 2 minutes on the given date.
SPEEDING_OVER_POSTED_20_KPH_2MIN NUMBER The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit for 2 minutes on the given date.
EV_ENERGY_USED_MOTOR NUMBER The amount of energy used by the electric vehicle motor on the given date.
EV_ENERGY_GENERATED_MOTOR NUMBER The amount of energy generated by the electric vehicle motor on the given date.
EV_ENERGY_USED_HVAC NUMBER The amount of energy used by the HVAC (Heating, Ventilation, and Air Conditioning) systems in the electric vehicle on the given date.
EV_ENERGY_USED_AUX NUMBER The amount of energy used by auxiliary systems (for example, lights and radio) in the electric vehicle on the given date.
EV_ENERGY_USED_IDLE NUMBER The amount of energy used by the electric vehicle while idle on the given date.
EV_ENERGY_USED_RECHARGING NUMBER The raw amount of electricity consumption that occurs during the electric vehicle recharge on the given date.
EV_BATTERY_ENERGY_USED_RECHARGING NUMBER The amount of energy used when recharging the electric vehicle on the given date.
EV_BATTERY_ENERGY_GAINED_RECHARGING NUMBER The gain in battery energy that occurs when recharging an electric vehicle for the vehicle on the given date.
EV_BATTERY_ENERGY_LOST_RECHARGING NUMBER The difference between power used recharging and battery level gained for the vehicle on the given date.
EV_RECHARGE_DURATION NUMBER The time duration that the electric vehicle spent recharging on the given date.
EV_DISTANCE_IN_ECO_BAND NUMBER The distance traveled by the electric vehicle inside a good economical range (1500 - 2500 RPM) on the given date.
EV_CO2_SAVINGS NUMBER The amount of CO2 emission prevented by using the electric vehicle on the given date.
EV_ENERGY_CONSUMED NUMBER The total amount of energy used by an electric vehicle for the driver on the given date.
LONGEST_ENGINE_TIME NUMBER The longest engine running time on each particular day for the vehicle on the given date.
ABS_COUNT NUMBER Total number of times the Anti-Lock Braking System (ABS) was engaged for the vehicle on the given date.
STABILITY_COUNT NUMBER Total number of times the Roll Over Protection (ROP) engine control unit or ROP brake control was engaged for the vehicle on the given date.
TRACTION_COUNT NUMBER Total number of times the Anti-Slip Regulation (ASR) was engaged for the vehicle on the given date.
SMARTSPEEDING_5_MPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 5 MPH over the posted speed limit and the speed was faster than the Smart Speed.
SMARTSPEEDING_OVER_POSTED_5MPH_2MIN NUMBER Total count of events when a vehicle was speeding more than 5 MPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_10_MPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 10 MPH over the posted speed limit and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_OVER_POSTED_10MPH_2MIN NUMBER Total count of events when a vehicle was speeding more than 10 MPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_10_KMPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 10 KPH over the posted speed limit and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_OVER_POSTED_10_KPH_2MIN NUMBER Total count of events when a vehicle was speeding more than 10 KPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_20_KMPH_OVERPOSTED NUMBER Total count of events when the vehicle was speeding more than 20 KPH over the posted speed limit and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_OVER_POSTED_20_KPH_2MIN NUMBER Total count of events when a vehicle was speeding more than 20 KPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_10_PERCENT_OVERPOSTED NUMBER Total count of events when a vehicle was speeding more than 10% over the posted speed limit and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_10_PERCENT_OVERPOSTED_2MIN NUMBER Total count of events when a vehicle was speeding more than 10% over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_20_PERCENT_OVERPOSTED NUMBER Total count of events when a vehicle was speeding more than 20% over the posted speed limit and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_20_PERCENT_OVERPOSTED_2MIN NUMBER Total count of events when a vehicle was speeding more than 20% over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_COUNT_LOW_BAND NUMBER The number of speeding events recorded where the vehicle was in the low band and the speed was faster than the Smart Speed on the given date.
SMARTSPEEDING_COUNT_MED_BAND NUMBER The number of speeding events recorded where the vehicle was in the medium band and the speed was faster than the Smart Speed on the given date.
NATURAL_GAS_USED NUMBER The amount of natural gas used by the vehicle on the given date.
ROW_INSERT_TIME TIMESTAMP_NTZ The time, in UTC, when the last entry for the vehicle was inserted in the Analytics database on the given date.
ROW_UPDATE_TIME TIMESTAMP_NTZ The time, in UTC, when the last entry for the vehicle was updated in the Analytics database on the given date.
WORKING_DURATION NUMBER The total time the vehicle was working on the given date, in seconds.
TIMER_ERROR_QUALITY_FLAG BOOLEAN Preview - Indicator as to whether some of the timer data might not be trustworthy.
NO_DISTANCE_QUALITY_FLAG BOOLEAN Preview - Indicator as to whether the distance data might not be trustworthy due to a mismatch between fuel usage and/or speed.
NO_SPEED_QUALITY_FLAG BOOLEAN Preview - Indicator as to whether the maximum speed data might not be trustworthy.
HIGH_DISTANCE_QUALITY_FLAG BOOLEAN Preview - Indicator as to whether the distance data might not be trustworthy due to incompatibilities with engine time and idle time.

Video course View (video_course)

Column Name Slow Changing Behavior Data Type Description
VIDEO_COURSE_KEY   NUMBER A unique identifier for the video course, used within the Analytics server. Use VIDEO_COURSE_KEY for joining this view.
VIDEO_COURSE_ID   TEXT A unique identifier for the video course, used within Fleet. Use VIDEO_COURSE_ID for grouping by this view.
VIDEOCHANNEL_UUID Historic TEXT A unique identifier for the video course channel, used within Fleet. Use VIDEOCHANNEL_UUID for grouping by this view.
VIDEO_NAME Current TEXT The video course name.
VIDEO_DESCRIPTION Historic TEXT The video course description.
URL Historic TEXT The video course URL.
THUMBNAIL Historic TEXT The video course thumbnail.
DURATION Historic NUMBER The video course duration.
CHANNEL_NAME Current TEXT The video course channel name.
CHANNEL_DESCRIPTION Historic TEXT The video course channel description.
IS_CURRENT   BOOLEAN Whether this video course database entry is current or has been replaced by a newer copy.
START_TIME_UTC   TIMESTAMP_NTZ The time at which this video course entry was created, in UTC.
END_TIME_UTC   TIMESTAMP_NTZ The time at which this video course entry became historical, in UTC.
ROW_UPDATE_TIME   TIMESTAMP_NTZ The time, in UTC, when this entry was last updated.

TID Information

The following table lists the TIDs that can be part of the DIAGS column in the point_with_vehicle and point_with_vehicle_and_driver views. See "Notes" in the Properties column notes for more information.

The following list describes the table columns:

  • TID: The "TID", or storage identifier, for the parameter. A number less than 32,000. Once assigned, it should never be changed.
  • SCALE: The precision used for this diagnostic.
  • TYPE: The data type used:
    • 1 = UInt8 (byte) 0 to 256
    • 2 = Int8 (sbyte) -128 to 127
    • 3 = UInt16 (ushort) 0 to 65,535
    • 4 = Int16 (short) -32,768 to 32,767
    • 5 = UInt32 (uint) 0 to 0 to 4,294,967,295
    • 6 = Int32 (int) -2,147,483,648 to 2,147,483,647
    • 7 = Float - ±1.5 × 10−45 to ±3.4 × 1038
    • 8 = Double - ±5.0 × 10−324 to ±1.7 × 10308
    • 9 = TrAsciiDouble (translation only)
    • 10 = Boolean
    • 11 = TrAsciiBool (translation only)
    • 12 = TrInvertedBool (translation only)
    • 13 = Event
    • 14 = DTC (diagnostic trouble code)
    • 15 = TripSeparator
    • 16 = Text
    • 255 = Null
  • UNITS: The units the diagnostics are measured in.
  • PROPERTIES:
    • SymbolicName - Can be ignored.
    • TimeFrame - Specifies the nature of the time-related data (best practice is to specify this):
      • 0 = Event (Occurred, NotReported)
      • 1 = Instantaneous (default)
      • 2 = Delta (from the previous report of this TID)
      • 3 = Lifetime
      • 4 = Resettable (resets on occasion)
    • ExtendsRangeOf - Allows range extension of the data type when values overflow.
    • BrowserVisible - (default is True) Exposes property in the Fleet UI.
    • PersistsFor - (default is zero time) For diagnostics that don't report each time, defines when the existing value will expire (22 min, 2 hrs, 3 days).
    • Operations - What you can do when accumulating diagnostic values. Multiple bit flags acceptable:
      • 0 = None (Default)
      • 1 = Sum
      • 2 = Average
      • 4 = Min
      • 8 = Max
    • TripOperations - Accumulator options for one vehicle over the course of a trip.
    • FleetOperations - Accumulator options for a set of vehicles.
    • Enum - Description of numeric values. 
TID Scale Type Units Properties Description
0 1 5 km

{

"IgnoreIf": "tid 0 < 5; decreasing; hourly change > 250; value > 5000000",

"Notes": "Value is ignored if it is decreasing, excessively high, or too rapid an hourly change.",

"PersistFor": "3.00:00:00",

"SymbolicName": "Odometer",

"TimeFrame": "3"

}

 Odometer
1 0.05 5 hours

{

"FleetOperations": "15",

"IgnoreIf": "tid 1 < 1; decreasing; hourly change > 3; value > 400000",

"Notes": "Accumulated time of operation of the engine. Value is ignored if it is decreasing, excessively high, or too rapid an hourly change. The maximum engine time is 45 years.",

"PersistFor": "3.00:00:00",

"SymbolicName": "EngineHours",

"TimeFrame": "3",

"TripOperations": "0"

}

 Total Engine Hours
2 0.05 3 V

{

"Notes": "",

"PersistFor": "00:22:00",

"SymbolicName": "BatteryVoltage",

"TimeFrame": "1",

"TripOperations": "12"

}

 Battery Voltage
3 0.5 5 L

{

"FleetOperations": "15",

"IgnoreIf": "zero; decreasing; hourly change > 500; value > 10000000",

"Notes": "Value is ignored if it is zero, decreasing, excessively high, or too rapid an hourly change.",

"PersistFor": "3.00:00:00",

"SymbolicName": "TotalFuelUsed",

"TimeFrame": "3",

"TripOperations": "0"

}

 Total Fuel Used
4 0.001 3 km/L

{

"IgnoreIf": "zero",

"Notes": "",

"PersistFor": "3.00:00:00",

"SymbolicName": "AverageFuelEconomy",

"TimeFrame": "3"

}

 Average Fuel Economy
6 1 10  

{

"ExpireIf": "ignition off",

"Notes": "True if the driver seatbelt is fastened. ",

"PersistFor": "00:22:00",

"SymbolicName": "SeatBeltFastened",

"TimeFrame": "1"

}

 Driver Seatbelt Fastened
7 1 3 RPM

{

"ExpireIf": "ignition off; tid 951 = 0",

"Notes": "Actual engine speed, calculated over a minimum crankshaft angle of 720 degrees divided by the number of cylinders. ",

"PersistFor": "00:22:00",

"SymbolicName": "EngineSpeed",

"TimeFrame": "1",

"TripOperations": "10"

}

 Engine Speed
8 1 3 mph

{

"AlwaysUseExtension": "true",

"DataType": "Speed",

"ExpireIf": "ignition off",

"Notes": "Vehicle Speed reported on the diagnostic bus",

"SymbolicName": "Speed",

"TimeFrame": "1",

"TripOperations": "10"

}

 Vehicle Speed
13 1 3 %

{

"AlwaysUseExtension": "true",

"Notes": "Ratio of volume of fuel to the total volume of fuel in the primary or left-side storage container, if there are two. When Fuel Level 2 is not used, Fuel Level 1 represents the total fuel.",

"PersistFor": "3.00:00:00",

"SymbolicName": "FuelLevel",

"TimeFrame": "1",

"TripOperations": "12"

}

 Fuel Level
14 0.05 3 gal

{

"FleetOperations": "1",

"Notes": "",

"PersistFor": "00:22:00",

"SymbolicName": "FuelRemaining",

"TimeFrame": "1",

"TripOperations": "12"

}

 Fuel Remaining
16 1 3 gal/hour

{

"ExpireIf": "ignition off",

"Notes": "Amount of fuel consumed by the engine per unit of time. ",

"PersistFor": "00:22:00",

"SymbolicName": "FuelRate",

"TimeFrame": "1",

"TripOperations": "10"

}

 Fuel Rate
25 1 10  

{

"Default":"false",

"DefaultIfNull":"true",

"FleetOperations":"1",

"NormalValue":"false",

"SymbolicName":"HarshCorneringLeft",

"TimeFrame":"0",

"TripOperations":"1"

}

 Harsh Cornering Left
26 1 10  

{

"Default":"false",

"DefaultIfNull":"true",

"FleetOperations":"1",

"NormalValue":"false",

"SymbolicName":"HarshCorneringRight",

"TimeFrame":"0",

"TripOperations":"1"

}

 Harsh Cornering Right
31 0.1 4 C

{

"BrowserVisible": "false",

"DataType": "Temperature",

"ExtendsRangeOf": "757",

"IgnoreIf": "value > 1735"

}

 Transmission Fluid Temperature (extension)
37 1 3 RPM

{

"Notes": "Peak engine speed over a time period.",

"SymbolicName": "TripMaxEngineSpeed",

"TimeFrame": "2",

"TripOperations": "8"

}

 Trip Max Engine Speed
38 1 5 seconds

{

"FleetOperations": "15",

"Notes": "Time the engine spent over the RPM threshold.",

"SymbolicName": "TripEngineOverspeedDuration",

"TimeFrame": "2",

"TripOperations": "1"

}

 Trip Engine Overspeed Duration
40 0.001 5 L

{

"Notes": "Total Fuel Used during Power Take Off(PTO).",

"SymbolicName": "TotalPtoFuel",

"TimeFrame": "3"

}

 Total PTO Fuel
41 0.1 3 kPa

{

"Notes": "Engine intake manifold air pressure before injection.",

"PersistFor": "00:22:00",

"SymbolicName": "ManifoldPressure",

"TimeFrame": "1",

"TripOperations": "12"

}

 Manifold Pressure
43 1 1 %

{

"Notes": "Ratio of volume of Diesel Exhaust Fluid to the total volume of fluid tank.",

"PersistFor": "3.00:00:00",

"SymbolicName": "DefTankLevel",

"TimeFrame": "1",

"TripOperations": "12"

}

 Diesel Exhaust Fluid Level
44 1 10  

{

"FleetOperations": "1",

"NormalValue": "false",

"Notes": "True if the warning lamp for the urea tank level in the Diesel Exhaust Fluid (DEF) injection system is on.",

"PersistFor": "00:22:00",

"SymbolicName": "UreaTankLevelWarning",

"TimeFrame": "1"

}

 Diesel Exhaust Fluid Level Warning
45 1 10  

{

"FleetOperations": "1",

"NormalValue": "false",

"Notes": "True if the Diesel Exhaust Fluid (DEF) injection system has determined the urea tank is contaminated.",

"PersistFor": "00:22:00",

"SymbolicName": "UreaTankContaminated",

"TimeFrame": "1"

}

 Diesel Exhaust Fluid Quality Warning
55 1 10  

{

"ExpireIf": "ignition off",

"Notes": "True if the front passenger seatbelt is fastened. ",

"PersistFor": "00:22:00",

"SymbolicName": "FrontPassengerSeatBeltFastened",

"TimeFrame": "1"

}

 Front Passenger Seatbelt Fastened
56 1 10  

{

"ExpireIf": "ignition off",

"Notes": "True if the front passenger seat is occupied. ",

"SymbolicName": "FrontPassengerSeatOccupied",

"TimeFrame": "1"

}

 Front Passenger Seat Occupied
57 1 5 seconds

{

"Notes": "Time spent driving without the front passenger seatbelt fastened on this trip while a passenger was in the seat.",

"SymbolicName": "TripDrivingWithoutPassengerSeatbeltTime",

"TimeFrame": "2",

"TripOperations": "1"

}

 Trip Time Driving Without Passenger Seat Belt
58 1 10  

{

"Notes": "True when any of the driving without seatbelt alerts are true.",

"SymbolicName": "DrivingWithoutSeatbeltAlertEvent",

"TimeFrame": "0"

}

 Driving Without Seatbelt Warning
59 1 10  

{

"Notes": "True if the headlights are on. ",

"SymbolicName": "HeadlightsOn",

"TimeFrame": "1"

}

 Headlights
61 1 10  

{

"NormalValue": "false",

"Notes": "True if the reported position is probably stale and may not be the current position.",

"SymbolicName": "PositionIsStale",

"TimeFrame": "1"

}

 Position is Stale
62 1 1  

{

"Enum": {

"Change Oil": "0",

"Oil OK": "1"

},

"NormalValue": "0",

"Notes": "For vehicles that do not report oil life, the status is either Oil OK or Change Oil.",

"SymbolicName": "OilLifeStatus",

"TimeFrame": "1"

}

 Oil Life Status
63 0.005 6 Wh

{

"Notes":"Total energy capacity of the electric vehicle main battery.",

"TimeFrame":"1",

"SymbolicName":"EVBatteryCapacity",

"TripOperations":"0"

}

 Electric Vehicle Battery Capacity
64 1 10  

{

"Notes":"True if the EV battery is being charged.",

"TimeFrame":"1",

"PersistFor":"00:05:00",

"SymbolicName":"EVBatteryCharging",

"TripOperations":"0"

}

 Electric Vehicle Battery Charging
66 0.005 6 Wh

{

"Notes":"Amount of drive motor electricity generated on this trip.",

"TimeFrame":"2",

"SymbolicName":"TripDriveMotorEnergyGenerated",

"TripOperations":"1",

"AlwaysUseExtension":"true"

}

 Trip Drive Motor Energy Generated
68 0.001 6 Wh

{

"Notes":"Amount of electricity used by auxiliary equipment on this this trip.",

"TimeFrame":"2",

"SymbolicName":"TripAuxEnergyUsed",

"TripOperations":"1",

"AlwaysUseExtension":"true"

}

 Trip Auxiliary Electrical Energy Used
74 1 3 seconds

{

"FleetOperations": "1", "Notes": "The amount of time the engine has operated since the previous report.", "SymbolicName": "DeltaEngineTime", "TimeFrame": "2", "TripOperations": "1"

}

 Delta Engine Time
76 0.001 5 L

{

"IgnoreIf": "tid 76 < 0",

"Notes": "Fuel consumed since the beginning of the current fuel tracking interval. This interval may be reset arbitrarily. For example, the interval may correspond to an ignition cycle, or it may be shorter or longer, depending on the data source's behavior.",

"TimeFrame": "4",

"TripOperations": "0"

}

 Interval Fuel Used
77 0.005 6 Wh

{

"FleetOperations":"1",

"TripOperations":"1",

"TimeFrame":"2",

"SymbolicName":"DeltaIdleEnergyUsed",

"Notes":"Amount of electricity used while idling since the last time this parameter was reported."

}

 Delta Idle Energy Used
78 0.005 6 Wh

{

"Notes":"Amount of electricity consumption that occurred during the Electric Vehicle Battery recharging cycle.",

"TimeFrame":"2",

"SymbolicName":"DeltaEvRechargeEnergyUsed"

}

 Delta EV Recharge Energy Used
88 0.1 3 kPa

{

"Notes": "Tire Pressure Monitoring System setting for the minimum threshold for Axle 1.",

"SymbolicName": "TpmsMinThresholdAxle1",

"TimeFrame": "1"

}

TPMS Minimum Threshold - Axle 1
89 0.1 3 kPa

{

"Notes": "Tire Pressure Monitoring System setting for the minimum threshold for Axle 2.",

"SymbolicName": "TpmsMinThresholdAxle2",

"TimeFrame": "1"

}

 TPMS Minimum Threshold - Axle 2
95 1 10  

{

"FleetOperations": "1",

"Notes": "Sensors on the vehicle have detected an impact indicating a collision may have occurred.",

"SymbolicName": "ProbableImpact",

"TimeFrame": "0",

"TripOperations": "1"

}

 Probable Impact
307 1 10  

{

"FleetOperations": "1",

"NormalValue": "false",

"Notes": "True if the redline (maximum rated engine RPM) is exceeded.",

"SymbolicName": "EngineOverspeed",

"TimeFrame": "1",

"TripOperations": "1"

}

 Engine Overspeed
684 1 1 %

{

"Notes": "Amount of ambient water vapor present expressed as a ratio to complete water vapor saturation at ambient temperature.",

"SymbolicName": "AmbientRelativeHumidity",

"TimeFrame": "1"

}

 Ambient Relative Humidity
685 1 1 %

{

"Notes": "Total percentage of energy capacity remaining in the battery of device.",

"SymbolicName": "DeviceBatteryLifeRemaining",

"TimeFrame": "1"

}

 Device Battery Life Remaining
686 0.003051758 4 m/(s2)

{

"Notes": "Represents the acceleration of the vehicle parallel to its heading.",

"SymbolicName": "LongitudinalAcceleration",

"TimeFrame": "1"

}

 Longitudinal Acceleration
687 0.003051758 4 m/(s2)

{

"Notes": "Represents the acceleration of the vehicle due to a vertical component relative to the horizontal plane.",

"SymbolicName": "VerticalAcceleration",

"TimeFrame": "1"

}

 Vertical Acceleration
700 1 1 C

{

"DataType": "Temperature",

"ExpireIf": "ignition off",

"Notes": "Temperature of the liquid in the engine's cooling system. ",

"PersistFor": "00:22:00",

"SymbolicName": "EngineCoolantTemp",

"TimeFrame": "1",

"TripOperations": "14"

}

 Engine Coolant Temperature
701 1 1 %

{

"Notes": "The ratio of the actual position of the accelerator pedal (or throttle lever) to its maximum position. The beginning position (not engaged) starts at 0%.",

"PersistFor": "00:22:00",

"SymbolicName": "AcceleratorPosition",

"TimeFrame": "1"

}

 Accelerator Pedal Position
702 1 10  

{

"NormalValue": "false",

"Notes": "True if the brake is engaged.",

"SymbolicName": "BrakePedalSwitch",

"TimeFrame": "1"

}

 Brake Pedal Switch
703 1 1  

{

"Enum": {

"High regen need": "3",

"Low regen need": "1",

"Moderate regen need": "2",

"Normal": "0"

},

"Notes": "Normal means that no regeneration is needed.",

"PersistFor": "2:00:00",

"SymbolicName": "DpfStatus",

"TimeFrame": "1"

}

 Diesel Particulate Filter Status
704 1 10  

{

"FleetOperations": "1",

"NormalValue": "false",

"Notes": "(Diagnostic Message 1: Active Diagnostic Trouble Code) True if the lamp is on.",

"SymbolicName": "MilStatus",

"TimeFrame": "3"

}

 Malfunction Indicator Lamp Status (DM1)
705 1 10  

{

"BrowserVisible": "false",

"NormalValue": "false",

"Notes": "(Diagnostic Message 1: Active Diagnostic Trouble Code)",

"TimeFrame": "1"

}

 Red Stop Lamp Status (DM1)
706 1 10  

{

"BrowserVisible": "false",

"NormalValue": "false",

"Notes": "(Diagnostic Message 1: Active Diagnostic Trouble Code)",

"TimeFrame": "1"

}

 Amber Warning Lamp (DM1)
707 1 10  

{

"BrowserVisible": "false",

"NormalValue": "false",

"Notes": "(Diagnostic Message 1: Active Diagnostic Trouble Code)",

"TimeFrame": "1"

}

 Protect Lamp Status (DM1)
708 1 10  

{

"BrowserVisible": "false",

"NormalValue": "false",

"Notes": "(Diagnostic Message 1: Active Diagnostic Trouble Code)",

"TimeFrame": "1"

}

 Flash Malfunction Indicator Lamp (DM1)
709 1 10  

{

"BrowserVisible": "false",

"NormalValue": "false",

"Notes": "(Diagnostic Message 1: Active Diagnostic Trouble Code)",

"TimeFrame": "1"

}

 Flash Red Stop Lamp (DM1)
710 1 10  

{

"BrowserVisible": "false",

"NormalValue": "false",

"Notes": "(Diagnostic Message 1: Active Diagnostic Trouble Code)",

"TimeFrame": "1"

}

 Flash Amber Warning Lamp (DM1)
711 1 10  

{

"BrowserVisible": "false",

"NormalValue": "false",

"Notes": "(Diagnostic Message 1: Active Diagnostic Trouble Code)",

"TimeFrame": "1"

}

 Flash Protect Lamp (DM1)
716 0.1 4 C

{

"DataType": "Temperature",

"Notes": "",

"PersistFor": "00:22:00",

"SymbolicName": "RefrigerationTemp",

"TimeFrame": "1",

"TripOperations": "14"

}

 Refrigeration Temperature
718 0.003051758 4 m/(s2)

{

"ExpireIf": "ignition off",

"Notes": "Reports the peak acceleration on the trip.",

"SymbolicName": "MaxAccel",

"TimeFrame": "2",

"TripOperations": "8"

}

 Max Acceleration
720 0.003051758 4 m/(s2)

{

"ExpireIf": "ignition off",

"Notes": "Reports the peak deceleration on the trip.",

"SymbolicName": "MaxDecel",

"TimeFrame": "2",

"TripOperations": "8"

}

 Max Deceleration
724 1 10  

{

"NormalValue": "false",

"Notes": "True if the speed exceeds the maximum that is allowed by the customer.",

"SymbolicName": "SpeedingOverMax",

"TimeFrame": "1",

"TripOperations": "1"

}

 Speeding Over Max
725 0.1 4 C

{

"DataType": "Temperature",

"Notes": "Refers to the temperature of air surrounding the vehicle.",

"PersistFor": "00:22:00",

"SymbolicName": "AmbientAirTemp",

"TimeFrame": "1",

"TripOperations": "14"

}

 Ambient Air Temperature
727 1 1 %

{

"ExpireIf": "ignition off",

"Notes": "",

"PersistFor": "00:22:00",

"SymbolicName": "EngineLoad",

"TimeFrame": "1",

"TripOperations": "10"

}

 Engine Load
728 0.1 4 C

{

"DataType": "Temperature",

"Notes": "(dual refrigeration units)",

"PersistFor": "00:22:00",

"SymbolicName": "RefrigerationTemp2",

"TimeFrame": "1",

"TripOperations": "14"

}

 Refrigeration Temperature 2
729 1 2  

{

"Enum": {

"Drive": "125",

"Low1": "122",

"Low2": "123",

"Low3": "124",

"Neutral": "0",

"Park": "126",

"Reverse": "-1"

},

"Notes": "The gear currently engaged or the last gear engaged while the transmission is shifting. Standard gear numbers use their literal values (second gear is 2).",

"SymbolicName": "CurrentGear",

"TimeFrame": "1"

}

 Current Gear
731 1 1  

{

"Enum": {

"Full tank no restrictions": "0x00",

"Restriction Active": {

"max": "0x0B",

"min": "0x01"

}

},

"NormalValue": "0",

"Notes": "Refers to the restriction status of the urea in the Diesel Emission Fluid (DEF) injection system. 'Full tank no restrictions' (0) is the base, and higher values indicate increasing restrictions.",

"PersistFor": "3.00:00:00",

"SymbolicName": "UreaRestriction",

"TimeFrame": "1"

}

 Urea Restriction
733 1 10  

{

"NormalValue": "false",

"Notes": "True if an electronic skid control program is operating, including electronic stability control (ESC), electronic stability program (ESP), or dynamic stability control (DSC).",

"SymbolicName": "StabilityControlEngaged",

"TimeFrame": "0"

}

 Stability Control Engaged
742 0.05 3 V

{

"Notes": "",

"PersistFor": "00:22:00",

"SymbolicName": "BackupBatteryVoltage",

"TimeFrame": "1",

"TripOperations": "12"

}

 Backup Battery Voltage
743 1 8 V

{

"BrowserVisible": "false",

"PersistFor": "00:22:00",

"ReplacedBy": "742",

"TimeFrame": "1",

"TripOperations": "12"

}

 Backup Battery Voltage - superseded
744 1 10  

{

"CanMapToAnalog": "true",

"Notes": "(required on every point) Indicates whether the ignition is on (such as to power the radio), regardless of engine status.",

"SymbolicName": "Ignition",

"TimeFrame": "1"

}

 Ignition
745 1 10  

{

"NormalValue": "false",

"Notes": "Refers to Power Take Off, the device used to transmit engine power to auxiliary equipment. True if PTO is engaged.",

"PersistFor": "00:22:00",

"SymbolicName": "PtoEngaged",

"TimeFrame": "1"

}

 PTO
751 1 10  

{

"NormalValue": "false",

"Notes": "Warns of low brake fluid level; sometimes used for ABS fault.",

"SymbolicName": "LowBrakeFluid",

"TimeFrame": "1"

}

 Low Brake Fluid
753 1 10  

{

"NormalValue": "false",

"Notes": "Alarm System warning light (red).",

"SymbolicName": "LowEngineOilPressure",

"TimeFrame": "1"

}

 Low Engine Oil Pressure
754 1 10  

{

"IgnoreIf": "tid(8061)!=0; tid(8062)!=0; tid(8063)!=0; tid(8064)!=0; tid(8065)!=0; tid(8066)!=0; tid(8067)!=0; tid(8068)!=0; tid(8069)!=0; tid(8070)!=0; tid(8071)!=0; tid(8072)!=0",

"NormalValue": "false",

"Notes": "",

"PersistFor": "00:22:00",

"SymbolicName": "LowTirePressure",

"TimeFrame": "1"

}

 Low Tire Pressure
755 1 10  

{

"NormalValue": "false",

"Notes": "True if an unacceptable amount of water is present in the fuel.",

"PersistFor": "00:22:00",

"SymbolicName": "WaterInFuel",

"TimeFrame": "1"

}

 Water In Fuel
756 1 1 %

{

"Notes": "Ratio of current service life remaining to maximum recommended service life (where 100% indicates fresh oil).",

"PersistFor": "3.00:00:00",

"SymbolicName": "OilLifeRemaining",

"TimeFrame": "1",

"TripOperations": "12"

}

 Oil Life Remaining
757 1 1 C

{

"DataType": "Temperature",

"Notes": "",

"PersistFor": "00:22:00",

"SymbolicName": "TransmissionFluidTemp",

"TimeFrame": "1",

"TripOperations": "14"

}

 Transmission Fluid Temperature
760 0.001 3 L

{

"IgnoreIf": "tid 760 < 0; value > 375",

"Notes": "Fuel consumed since the last time this parameter was reported.",

"SymbolicName": "TripFuelUsed",

"TimeFrame": "2",

"TripOperations": "1"

}

 Trip Fuel Used
762 1 5 seconds

{

"Notes": "Time the vehicle spent over the customer's speed threshold.",

"SymbolicName": "TripSpeedingTime",

"TimeFrame": "2",

"TripOperations": "1"

}

 Trip Time Speeding
763 1 5 seconds

{

"Notes": "Time spent driving without the driver seatbelt fastened on this trip.",

"SymbolicName": "TripDrivingWithoutSeatbeltTime",

"TimeFrame": "2",

"TripOperations": "1"

}

 Trip Time Driving Without Driver Seatbelt
768 1 10  

{

"Notes": "True if the Airbag indicator is lighted.",

"PersistFor": "3.00:00:00",

"SymbolicName": "AirbagLight",

"TimeFrame": "1"

}

 Airbag Light
769 1 10  

{

"FleetOperations": "1",

"NormalValue": "false",

"Notes": "",

"SymbolicName": "HarshAcceleration",

"TimeFrame": "0",

"TripOperations": "1"

}

 Harsh Acceleration
770 1 10  

{

"FleetOperations": "1",

"NormalValue": "false",

"Notes": "",

"SymbolicName": "HarshBraking",

"TimeFrame": "0",

"TripOperations": "1"

}

 Harsh Braking
772 1 5 gal

{

"BrowserVisible": "false",

"IgnoreIf": "decreasing; hourly change > 100; value > 1000000",

"Notes": "Accumulated amount of fuel used during vehicle operation while under idle conditions. Value is ignored if it is decreasing, excessively high, or too rapid an hourly change.",

"PersistFor": "3.00:00:00",

"ReplacedBy": "{'id':775, 'scale':3.78541}",

"TimeFrame": "3"

}

 Total Idle Fuel Used
773 1 3 kPa

{

"Notes": "",

"PersistFor": "00:22:00",

"SymbolicName": "EngineOilPressure",

"TimeFrame": "1",

"TripOperations": "14"

}

 Engine Oil Pressure
774 0.05 5 hours

{

"FleetOperations": "15",

"IgnoreIf": "decreasing",

"Notes": "Refers to the time spent while under idle conditions (engine speed greater than zero and vehicle speed less than 2 km/h).",

"PersistFor": "3.00:00:00",

"SymbolicName": "TotalIdleHours",

"TimeFrame": "3",

"TripOperations": "0"

}

 Total Idle Hours
775 0.5 5 L

{

"FleetOperations": "15",

"IgnoreIf": "decreasing; hourly change > 400; value > 4000000",

"Notes": "Accumulated amount of fuel used during vehicle operation while under idle conditions (engine speed greater than zero and vehicle speed less than 2 km/h). Value is ignored if it is decreasing, excessively high, or too rapid an hourly change.",

"PersistFor": "3.00:00:00",

"SymbolicName": "TotalIdleFuelUsed",

"TimeFrame": "3",

"TripOperations": "0"

}

 Total Idle Fuel Used
776 1 3 km/h

{

"DataType": "Speed",

"Notes": "The maximum speed of the vehicle over a period of time.",

"PersistFor": "00:22:00",

"SymbolicName": "TripMaxSpeed",

"TimeFrame": "2",

"TripOperations": "8"

}

 Trip Max Vehicle Speed
777 1 10  

{

"NormalValue": "false",

"Notes": "Indicates whether the boom is deployed for use.",

"PersistFor": "00:22:00",

"SymbolicName": "BoomUp",

"TimeFrame": "1"

}

 Boom Status
786 0.001 5 km

{

"Notes": "Distance traveled during all or part of the trip.",

"SymbolicName": "TripDistance",

"TimeFrame": "2",

"TripOperations": "1"

}

 Trip Distance
789 1 10  

{

"NormalValue": "false",

"Notes": "Refers to an OBDII-compatible tool for reading DTC codes.",

"SymbolicName": "ScanToolConnected",

"TimeFrame": "1"

}

 Diagnostics Scan Tool Connected
804 1 5 seconds

{

"BrowserVisible": "false",

"TimeFrame": "1"

}

 Idle Time
821 1 10  

{

"NormalValue": "false",

"Notes": "Refers to the lift arms of a loader, which pivot to dump.",

"SymbolicName": "DumpArm",

"TimeFrame": "1"

}

 Dump Arm
831 1 10  

{

"NormalValue": "false",

"Notes": "Indicates whether the hopper is open. Refers to the dispenser for granular material, or the first in a series of such dispensers.",

"SymbolicName": "Hopper1",

"TimeFrame": "1"

}

 Hopper #1
832 1 10  

{

"NormalValue": "false",

"Notes": "Indicates whether the hopper is open. Refers to one of a series of dispensers for granular materials.",

"SymbolicName": "Hopper2",

"TimeFrame": "1"

}

 Hopper #2
833 1 10  

{

"NormalValue": "false",

"Notes": "Indicates whether the hopper is open. Refers to one of a series of dispensers for granular materials.",

"SymbolicName": "Hopper3",

"TimeFrame": "1"

}

 Hopper #3
836 1 10  

{

"TimeFrame": "0"

}

 iButton Driver Id Event
837 1 8  

{

"TimeFrame": "1"

}

 iButton Id
931 0.1 4 C

{

"DataType": "Temperature",

"Notes": "Refers to the temperature of air entering the induction system.",

"PersistFor": "00:22:00",

"SymbolicName": "AirInletTemp"

}

 Air Inlet Temperature
934 1.2 2 A

{

"Notes": "Indicates the amperage flowing into (-) or out of (+) the vehicle's battery.",

"PersistFor": "00:22:00",

"SymbolicName": "NetBatteryCurrent"

}

 Net Battery Current
937 0.01 3 kPa

{

"Notes": "Refers to the atmospheric pressure around the vehicle.",

"PersistFor": "00:22:00",

"SymbolicName": "BarometricPressure"

}

 Barometric Pressure
941 0.5 1 %

{

"Notes": "",

"PersistFor": "00:22:00",

"SymbolicName": "CoolantLevel"

}

 Coolant Level
945 0.05 6 hours

{

"Notes": "",

"PersistFor": "3.00:00:00",

"SymbolicName": "TotalVehicleTime"

}

 Total Vehicle Time
946 0.05 6 hours

{

"Notes": "Refers to Power Take Off, the device used to transmit engine power to auxiliary equipment.",

"PersistFor": "3.00:00:00",

"SymbolicName": "TotalPtoTime"

}

 Total PTO Time
947 1 4  

{

"IgnoreIf": ">= 0",

"Notes": "(received signal strength indicator) The closer the value is to zero, the better the power level received by the unit. ",

"SymbolicName": "RSSI"

}

 RSSI
948 1 10  

{

"Notes": "",

"TimeFrame": "0"

}

 Engine Start Event
949 1 10  

{

"Notes": "",

"TimeFrame": "0"

}

 Engine Stop Event
951 1 10  

{

"CanMapToAnalog": "true",

"Notes": "Indicates whether the engine is running, as opposed to ignition only.",

"SymbolicName": "EngineOn"

}

 Engine On
970 0.01 6 m

{

"Notes": "Altitude of the vehicle referenced to sea level at standard atmospheric pressure and temperature.",

"SymbolicName": "Altitude"

}

 Altitude
990 0.003051758 4 m/(s2)

{

"Notes": "Represents the acceleration of the vehicle perpendicular to its heading; positive values go right, and negative values go left.",

"SymbolicName": "LateralAcceleration",

"TimeFrame": "1"

}

 Lateral Acceleration
998 0.01 3 m/s

{

"DataType": "Speed",

"Notes": "Vehicle Speed determined by best speed source available",

"SymbolicName": "DerivedSpeed",

"TimeFrame": "1",

"TripOperations": "10"

}

 Derived Vehicle Speed
1044 1 10  

{

"Notes": "Warns that the battery power of the unit is low.",

"SymbolicName": "LowTrackerBattery",

"TimeFrame": "1"

}

 Low Tracker Battery
1045 1 10  

{

"Notes": "True if the device is using its internal battery.",

"SymbolicName": "LostExternalPower",

"TimeFrame": "0"

}

 Lost External Power
1064 1 10  

{

"Notes": "True if Traction Control is engaged.",

"PersistFor": "00:22:00",

"SymbolicName": "TractionControlEngaged",

"TimeFrame": "1"

}

 Traction Control Engaged
1066 1 10  

{

"Notes": "(Automatic Braking System) True if detected.",

"SymbolicName": "AbsEvent",

"TimeFrame": "0"

}

 ABS Event
1073 1 10  

{

"Notes": "",

"SymbolicName": "ExternalPowerRestored",

"TimeFrame": "0"

}

 External Power Restored
1075 1 10  

{

"Notes": "Indicates this point was generated by the device entering sleep.",

"SymbolicName": "EnterSleep",

"TimeFrame": "0"

}

 Enter Sleep
1082 0.01 4 °

{

"Notes": "The roll angle of the vehicle. A positive angle indicates the streetside of the chassis is higher than the curbside of the chassis.",

"SymbolicName": "Roll",

"TimeFrame": "1"

}

 Vehicle Roll Angle
1083 0.01 4 °

{

"Notes": "The pitch angle of the vehicle. A positive angle indicates the front of the chassis is higher than the rear of the chassis.",

"SymbolicName": "Pitch",

"TimeFrame": "1"

}

 Vehicle Pitch Angle
1099 1 10  

{

"NormalValue": "false",

"Notes": "True if the speed exceeds the posted speed limit plus the configured threshold (defaults to posted speed plus 5 mph).",

"SymbolicName": "SpeedingOverPosted",

"TimeFrame": "1",

"TripOperations": "1"

}

 Speeding Over Posted Speed Limit
1100 1 10  

{

"Notes": "True if an alert has been delivered. The type of alert delivered depends on the installed device and how it is configured.",

"SymbolicName": "InCabAlertDelivered",

"TimeFrame": "0",

"TripOperations": "1"

}

 In Cab Alert Delivered
1300 0.05 5 hours

{

"FleetOperations": "15",

"Notes": "Derived time of operation of the engine from a non diagnostic source.",

"SymbolicName": "DerivedEngineHours",

"TimeFrame": "3",

"TripOperations": "0"

}

 Derived Total Engine Hours
1514 0.1 3 %

{

"TimeFrame":"1",

"SymbolicName":"BatteryStateOfCharge",

"IgnoreIf":"value > 100",

"Notes":"State of the battery charger connected to the main battery"

}

 Battery State of Charge
1528 0.5 5 kWh

{

"FleetOperations":"15",

"IgnoreIf":"zero; decreasing; hourly change > 500; value > 10000000",

"Notes":"Total EV energy used, Value is ignored if it is zero, decreasing, excessively high, or too rapid an hourly change.",

"TimeFrame":"3",

"ExpireIf":"tid 1529 != 4",

"SymbolicName":"TotalEVEnergyUsed",

"TripOperations":"0"

}

 Total EV Energy Used
1532 0.005 8 Wh

{

"ExtendsRangeOf":"65",

"BrowserVisible":"false"

}

 Trip Drive Motor Energy Used (extension)
1533 0.005 8 Wh

{

"ExtendsRangeOf":"66",

"BrowserVisible":"false"

}

 Trip Drive Motor Energy Generated (extension)
1534 0.001 8 Wh

{

"ExtendsRangeOf":"68",

"BrowserVisible":"false"

}

 Trip Auxiliary Electrical Energy Used (extension)
8001 0.1 3 kPa

{

"FleetOperations": "2",

"IgnoreIf": "zero",

"PersistFor": "1.00:00:00",

"SymbolicName": "TirePressure1LA",

"TimeFrame": "1"

}

 Axle 1, Left Side, Tire A Pressure
8004 0.1 3 kPa

{

"FleetOperations": "2",

"IgnoreIf": "zero",

"PersistFor": "1.00:00:00",

"SymbolicName": "TirePressure1RA",

"TimeFrame": "1"

}

 Axle 1, Right Side, Tire A Pressure
8005 0.1 3 kPa

{

"FleetOperations": "2",

"IgnoreIf": "zero",

"PersistFor": "1.00:00:00",

"SymbolicName": "TirePressure2LA",

"TimeFrame": "1"

}

 Axle 2, Left Side, Tire A Pressure
8006 0.1 3 kPa

{

"FleetOperations": "2",

"IgnoreIf": "zero",

"PersistFor": "1.00:00:00",

"SymbolicName": "TirePressure2LB",

"TimeFrame": "1"

}

 Axle 2, Left Side, Tire B Pressure
8007 0.1 3 kPa

{

"FleetOperations": "2",

"IgnoreIf": "zero",

"PersistFor": "1.00:00:00",

"SymbolicName": "TirePressure2RB",

"TimeFrame": "1"

}

 Axle 2, Right Side, Tire B Pressure
8008 0.1 3 kPa

{

"FleetOperations": "2",

"IgnoreIf": "zero",

"PersistFor": "1.00:00:00",

"SymbolicName": "TirePressure2RA",

"TimeFrame": "1"

}

 Axle 2, Right Side, Tire A Pressure
8061 1 10  

{

"FleetOperations": "1",

"PersistFor": "1.00:00:00",

"SymbolicName": "LowTirePressure1LA",

"TimeFrame": "1"

}

 Axle 1, Left Side, Tire A Pressure Low
8064 1 10  

{

"FleetOperations": "1",

"PersistFor": "1.00:00:00",

"SymbolicName": "LowTirePressure1RA",

"TimeFrame": "1"

}

 Axle 1, Right Side, Tire A Pressure Low
8066 1 10  

{

"FleetOperations": "1",

"PersistFor": "1.00:00:00",

"SymbolicName": "LowTirePressure2LB",

"TimeFrame": "1"

}

 Axle 2, Left Side, Tire B Pressure Low
8067 1 10  

{

"FleetOperations": "1",

"PersistFor": "1.00:00:00",

"SymbolicName": "LowTirePressure2RB",

"TimeFrame": "1"

}

 Axle 2, Right Side, Tire B Pressure Low
10206 1 4 C

{

"BrowserVisible": "false",

"DataType": "Temperature",

"Notes": "The temperature internal to the tracking device.",

"SymbolicName": "DeviceTemperature",

"TimeFrame": "1",

"TripOperations": "12"

}

 Device Internal Temperature

Example Queries

How Do I Get Certain Diagnostics Data for a Vehicle?

To get the latest odometer readings for a vehicle on a specific day, find the TID in the TID Information table, above. You can then write a select query that may resemble the following query:

SELECT VEHICLE_KEY, DIAGS['0'], TIME FROM "VZC"."PUBLIC"."POINT_WITH_VEHICLE" 
WHERE VEHICLE_KEY = vehicle_key_1 AND TIME > '2020-01-01' AND TIME < '2020-01-02' AND DIAGS['0'] IS NOT NULL 
ORDER BY TIME LIMIT 1;

Alternatively, if you do not know the key but would like to filter out the vehicle by name or registration number, you can join to the vehicle view:

SELECT V.VEHICLE_KEY, V.VEHICLE_NAME, PWE.DIAGS['0'], PWE.TIME FROM "VZC"."PUBLIC"."POINT_WITH_VEHICLE" PWE
JOIN "VZC"."PUBLIC"."VEHICLE" V ON PWE.VEHICLE_KEY = V.VEHICLE_KEY
WHERE V.VEHICLE_NAME = 'vehicle_name_1' AND PWE.TIME > '2020-01-01' AND PWE.TIME < '2020-01-02' AND PWE.DIAGS['0'] IS NOT NULL
ORDER BY PWE.TIME LIMIT 1;

How Do I Get a Set of KPIs for a Driver/Hierarchy for a Time Duration?

You can query KPIs for a particular week for a specific driver. The following code block shows an example query:

SELECT D.DRIVER_KEY, D.DRIVER_NAME, D.HIERARCHY, DD.DATE, DD.DISTANCE, DD.ENGINE_TIME, DD.FUEL_USED FROM "VZC"."PUBLIC"."DRIVER_DAY" DD
JOIN "VZC"."PUBLIC"."DRIVER" D ON DD.DRIVER_KEY = D.DRIVER_KEY
WHERE DD.DATE > '2020-01-01' AND DD.DATE < '2020-01-07' AND D.DRIVER_KEY = driver_key_1 [AND D.DRIVER_NAME = 'driver_name_1']
ORDER BY DD.DATE;

For a hierarchy you can add aggregation to KPIs:

SELECT D.HIERARCHY, DD.DATE, SUM(DD.DISTANCE), SUM(DD.ENGINE_TIME), SUM(DD.FUEL_USED) FROM "VZC"."PUBLIC"."DRIVER_DAY" DD
JOIN "VZC"."PUBLIC"."DRIVER" D ON DD.DRIVER_KEY = D.DRIVER_KEY
WHERE DD.DATE > '2020-01-01' AND DD.DATE < '2020-01-07' AND ARRAY_CONTAINS('hierarchy_name_1'::VARIANT, D.HIERARCHY)
GROUP BY D.HIERARCHY, DD.DATE
ORDER BY DD.DATE;

How Do I Get KPI Aggregation Grouped by States?

SELECT A.STATE, T.VEHICLE_KEY, SUM(T.DISTANCE), SUM(T.ENGINE_TIME), SUM(T.FUEL_USED) FROM "VZC"."PUBLIC"."TRIP_BY_STATE" T
JOIN "VZC"."PUBLIC"."ADDRESS" A ON A.ADDRESS_ID = T.FIRST_ADDRESS_ID
JOIN "VZC"."PUBLIC"."VEHICLE" V ON V.VEHICLE_KEY = T.VEHICLE_KEY
WHERE T.START_TIME_UTC > '2020-01-01' AND T.START_TIME_UTC < '2020-01-10'
GROUP BY A.STATE, T.VEHICLE_KEY;

How Do I Get Time That a Vehicle Spent at a Marker?

SELECT M.MARKER_NAME, V.VEHICLE_NAME, T.TIME_ON_SITE FROM "VZC"."PUBLIC"."TIME_ON_SITE" T
JOIN "VZC"."PUBLIC"."MARKER" M ON M.MARKER_KEY = T.MARKER_KEY
JOIN "VZC"."PUBLIC"."VEHICLE" V ON V.VEHICLE_KEY = T.VEHICLE_KEY
WHERE T.ENTRY_TIMESTAMP_UTC > '2020-01-01' AND T.ENTRY_TIMESTAMP_UTC < '2020-01-10' AND VEHICLE_NAME = 'VEHICLE_NAME_1' AND MARKER_NAME = 'MARKER_NAME_1';

How Do I Create a New View?

CREATE DATABASE TEST_DB;
CREATE VIEW TEST_DB.PUBLIC.EAST_VEHICLES AS
SELECT
    vehicle_id,
    vehicle_name,
    hierarchy
FROM VZC.PUBLIC.VEHICLE
WHERE hierarchy[1] = 'East Division';

SELECT * FROM TEST_DB.PUBLIC.EAST_VEHICLES;

How Do I Create a New Role With Certain Permissions?

CREATE ROLE EAST_DIVISION;
GRANT USAGE ON DATABASE TEST_DB TO ROLE EAST_DIVISION;
GRANT USAGE ON SCHEMA TEST_DB.PUBLIC TO ROLE EAST_DIVISION;
GRANT USAGE ON WAREHOUSE VZC_WH TO ROLE EAST_DIVISION;
GRANT SELECT ON TEST_DB.PUBLIC.EAST_VEHICLES TO ROLE EAST_DIVISION;

How Do I Grant Access to the VZC Database to a Role?

GRANT IMPORTED PRIVILEGES ON DATABASE VZC TO ROLE NEW_ROLE;

How Do I Create an Additional User?

CREATE USER TEST_USER PASSWORD='***' DEFAULT_WAREHOUSE = BI_PROD_WH DEFAULT_NAMESPACE = VZC.PUBLIC DEFAULT_ROLE = EAST_DIVISION;
GRANT ROLE EAST_DIVISION TO USER TEST_USER;

Related articles

Comments

0 comments

Please sign in to leave a comment.