Snowflake Reader Account Views N-T

A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.

A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.

A unique identifier for this driver, used within Fleet. Use DRIVER_ID for joining this view.

A unique identifier for this driver, used within the Analytics server. Use DRIVER_KEY for joining this view.

The address where the unit was at the beginning of the NRU event.

The street number where the unit was at the beginning of the NRU event.

The suspected reason for the NRU event.

The local time when the unit entered the non reporting state.

The local time when the unit began reporting again.

The local time when the unit last reported.

The time (in UTC) when the unit entered the non reporting state.

The time (in UTC) when the unit began reporting again.

The time (in UTC) when this data was generated.

The number of days configured for this vehicle to be considered non-reporting.

The duration of the NRU event in days.

An identifier for this job, used within the Fleet and Analytics server alike. Use JOB_ID for joining to this view.

An identifier for the associated route, used within the Fleet and Analytics server alike. Use ROUTE_ID for joining this view.

A unique identifier for this territory within the Analytics server. Use TERRITORY_KEY for joining this view.

An identifier for this territory, used within the Fleet. Use TERRITORY_ID for joining this view.

A unique identifier for the marker this job is at, used within the Analytics server. Use MARKER_KEY for joining this view.

A unique identifier for the marker this job is at, used within Fleet. Use MARKER_ID for joining this view.

Name of this job.

Enumeration providing the status for this job.

Planned time of arrival, in UTC.

Actual time of arrival, in UTC.

Planned time of departure, in UTC.

Actual time of departure, in UTC.

Planned stop number.

Actual stop number.

JSON that contains all the properties for this job.

The time, in UTC, when the row was inserted in the database.

The time, in UTC, when this row was last updated in the database.

An identifier for this route, used within the Fleet and Analytics server alike. Use ROUTE_ID for joining to this view.

A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.

A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for joining this view.

A unique identifier for the driver, used within the Analytics server. Use DRIVER_KEY for joining this view.

A unique identifier for the driver, used within Fleet. Use DRIVER_ID for joining this view.

A unique identifier for this territory within the Analytics server. Use TERRITORY_KEY for joining this view.

An identifier for this territory, used within the Fleet. Use TERRITORY_ID for joining this view.

A unique identifier for the marker the route starts at, used within the Analytics server. Use START_DEPOT_MARKER_KEY for joining this view.

A unique identifier for the marker the route starts at, used within Fleet. Use START_DEPOT_MARKER_ID for joining this view.

A unique identifier for the marker the route ends at, used within the Analytics server. Use END_DEPOT_MARKER_KEY for joining this view.

A unique identifier for the marker the route ends at, used within Fleet. Use END_DEPOT_MARKER_ID for joining this view.

Name of this route.

Enumeration providing the status for this route.

Planned distance to be covered for this route, in meters.

Actual distance to be covered for this route, in meters.

Planned duration for this route, in seconds.

Actual duration for this route, in seconds.

Planned start time for this route, in UTC.

Actual start time for this route, in UTC.

Planned end time for this route, in UTC.

Actual end time for this route, in UTC.

Count of jobs on this route.

Count of jobs that were completed.

Count of jobs that were completed in sequence.

Count of jobs that were completed out of sequence.

Time the driver punched in, in UTC.

Time the driver punched out, in UTC.

The time, in UTC, when the row was inserted in the database.

The time, in UTC, when this row was last updated in the database.

A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.

A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.

The time when the point data was recorded.

The latitude coordinate where the vehicle was at the given time.

The longitude coordinate where the vehicle was at the given time.

A JSON object that contains all diagnostics triggered. Details about the diagnostic IDs are available on the TID Information table.

An array of DTC (diagnostic trouble codes) received.

The speed of the vehicle in centimeters per second.

Whether the ignition was on at the given time.

Whether the vehicle was in private mode at the given time.

The delta odometer reading in meters.

An Enum providing the GPS quality level: 0 = Off, 1 = NoFix, 2 = Unreliable, 3 = Excellent

The timestamp when this GPS point was recorded.

The time zone offset, in minutes, for the recorded GPS time.

See Hilbert-R-tree for further details

Whether the engine was on at the given time.

The address where the vehicle was at the given time.

Whether the vehicle was on a paved road at the given time.

Whether the vehicle was on a private road at the given time.

The distance, in meters, to the closest road, when the vehicle is off road.

The time, in UTC, when the point was inserted in the Analytics database.

A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.

A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.

A unique identifier for this driver, used within the Analytics server. Use DRIVER_KEY for joining this view.

The time when the point data was recorded.

The latitude coordinate where the driver and vehicle were at the given time.

The longitude coordinate where the driver and vehicle were at the given time.

A JSON object that contains all diagnostics triggered. Details about the diagnostic IDs are available on the TID Information table.

An array of DTC (diagnostic trouble codes) received.

The speed of the vehicle in centimeters per second.

Whether the ignition was on at the given time.

Whether the vehicle was in privacy mode at the given time.

The delta odometer reading in meters.

An enum providing the GPS quality level: 0 = Off, 1 = NoFix, 2 = Unreliable, 3 = Excellent

The timestamp when this GPS point was recorded.

The time zone offset, in minutes, for the recorded GPS time.

See Hilbert-R-tree for further details

Whether the engine was on at the given time.

The address where the driver and vehicle were at the given time.

Whether the vehicle was on a paved road at the given time.

Whether the vehicle was on a private road at the given time.

The distance, in meters, to the closest road, when the vehicle is off road.

The time, in UTC, when the point was inserted in the Analytics database.

A unique identifier for this territory within the Analytics server. Use TERRITORY_KEY for joining to this view.

An identifier for this territory, used within the Fleet. Use TERRITORY_ID for joining this view.

Name of this territory.

Relevant time zone.

The time at which this entry was created, in UTC.

The time at which this entry became historical, in UTC.

Whether this database entry is current or has been replaced by a newer copy.

The time, in UTC, when this entry was last updated.

A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.

A unique identifier for the marker, used within the Analytics server. Use MARKER_KEY for joining this view.

The local time when the vehicle entered the site.

The local time when the vehicle left the site.

The total amount of time the vehicle spent on the site in seconds.

The maximum speed of the vehicle while on the site in centimeters per second.

The minimum speed of the vehicle while on the site in centimeters per second.

The time (in UTC) when the vehicle entered the site.

The time (in UTC) when the vehicle left the site.

The time, in UTC, when the last entry for the trip was inserted in the Analytics database.

The time, in UTC, when the last entry for the trip was updated in the Analytics database.

A unique identifier for the trip, used within Fleet. Use TRIP_ID for grouping by this view.

A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.

A unique identifier for the driver, used within Fleet. Use DRIVER_ID for grouping by this view.

A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.

A unique identifier for the driver, used within the Analytics server. Use DRIVER_KEY for joining this view.

The marker IDs at which this trip began. Maps to the Marker view.

The marker keys at which this trip ended. Maps to the Marker view.

The marker IDs associated with the end of the trip.

The marker keys associated with the end of the trip.

The time at which this trip began, in UTC.

The time at which this trip ended, in UTC.

The start time as recorded on the hardware unit installed in the vehicle.

The end time as recorded on the hardware unit installed in the vehicle.

The duration of the trip, in seconds.

Total distance traveled in this trip, in meters.

The amount of fuel used in this trip, in milliliters.

The driving duration of this trip, in seconds.

The working duration of this trip, in seconds.

The on-site duration of this trip, in seconds.

The pre-idle state duration of this trip, in seconds.

The post-idle state duration of this trip, in seconds.

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.

The number of hard acceleration events recorded during this trip.

The number of hard braking events recorded during this trip.

The number of seat belt violation events recorded during this trip.

The number of speeding over posted violation events recorded during this trip.

The number of excessive speeding events recorded during this trip.

The engine run-time duration during this trip, in seconds.

The duration of the trip spent in a non-productive pre-idle state, in seconds.

The vehicle odometer reading at the start of the trip, in meters.

The vehicle odometer reading at the end of the trip, in meters.

The number of diagnostic trouble codes (DTCs) logged during the trip.

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.

The total time for which the seatbelt was not in use during the trip.

Trip_duration used to calculate trip values for DRIVING_WITHOUT_SEATBELT metric.

Total distance traveled in this trip, in meters.

The amount of fuel used in this trip, in milliliters.

The number of speeding in the high band events recorded during the trip.

The number of speeding in the medium band events recorded during the trip.

The number of speeding in the low band events recorded during the trip.

Total time driven within a good economical range (1500 - 2500 RPM) during the trip.

Trip_duration used to calculate trip values for TIME_IN_ECO_BAND metric.

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.

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.

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.

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.

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.

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.

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.

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.

The total time for which the seatbelt was not in use by the driver for more than 5 miles during the trip.

The total time for which the seatbelt was not in use by a passenger for more than 5 miles during the trip.

The total time for which the seatbelt was not in use by a passenger for more than 10 miles during the trip.

The total time for which the seatbelt was not in use by the driver for more than 10 miles during the trip.

The total time for which the seatbelt was not in use by the driver for more than 2 minutes during the trip.

The total time for which the seatbelt was not in use by a passenger for more than 2 minutes during the trip.

The total time for which the seatbelt was not in use by the driver for more than 10 minutes during the trip.

The total time for which the seatbelt was not in use by a passenger for more than 10 minutes during the trip.

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.

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.

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.

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.

Total duration of RPM 767 events during the trip.

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.

The total time for which the PTO (power take off) is active during the trip, in seconds. Data based on diagnostic readings.

The number of events recorded where the driver was harshly cornering during the trip.

The first address ID reported for the trip.

The first address’s street number reported for the trip.

The last address ID reported for the trip.

The last address’s street number reported for the trip.

The last fill level of the vehicle's DEF tank reported for the trip in percent, shown in increments of 5%.

Whether the fill level of the vehicle's DEF tank is known or not.

The last time fill level of the vehicle's DEF tank was reported for the trip.

Total count of RPM 767 events during the trip.

The latitude coordinate of where the trip started.

The longitude coordinate of where the trip started.

The latitude coordinate where the trip ended.

The longitude coordinate where the trip ended.

The first address’s street number reported for the trip.

The last address’s street number reported for the trip.

The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit during the trip.

The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit during the trip.

The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit during the trip.

The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit during the trip.

The number of events recorded where the vehicle was speeding 10% over the posted speed limit during the trip.

The number of events recorded where the vehicle was speeding 20% over the posted speed limit during the trip.

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.

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.

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.

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.

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.

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.

Total count of events where the vehicle was not moving and the engine is on for longer than 5 minutes during the trip.

Total count of events where the vehicle was not moving and the engine is on for longer than 15 minutes during the trip.

Total count of events where the vehicle was not moving and the engine is on for longer than 30 minutes during the trip.

Total count of events where the vehicle was not moving and the engine is on for longer than 60 minutes during the trip.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

The number of events recorded where the vehicle was speeding over 75 MPH for 2 minutes during the trip.

Total duration of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 20% over the posted speed limit for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 10% over the posted speed limit for 2 minutes during the trip.

The number of events recorded where an airbag was deployed during the trip.

The lowest battery voltage recorded during the trip.

The highest battery voltage recorded during the trip.

Total number of times the DEF (Diesel Exhaust Fluid) level warning light was active during the trip.

The lowest oil life time recorded during the trip. The oil life time is the time remaining before an oil change is due.

The highest oil life time recorded during the trip. The oil life time is the time remaining before an oil change is due.

Total number of times that the oil life remaining warning light was active during the trip.

Total number of times that the low tire pressure warning light was active during the trip.

Total number of times that the water in fuel warning light was active during the trip.

The number of times the malfunction indicator lamp (MIL), or check engine light, was active during the trip.

Total number of times the airbag warning light was active during the trip.

Maximum reported Total Engine Hours during the trip.

Minimum reported coolant temperature during the trip.

Maximum reported coolant temperature during the trip.

Maximum reported speed during the trip.

Average reported speed during the trip.

The number of events recorded where the seat belt warning light was active during the trip.

The number of events recorded where the vehicle was speeding over 85 MPH for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit for 2 minutes during the trip.

The fuel level at the end of the trip.

Minimum reported fuel rail pressure during the trip.

Maximum reported fuel rail pressure during the trip.

Average reported fuel rail pressure during the trip.

Minimum reported manifold pressure during the trip.

Maximum reported manifold pressure during the trip.

Average reported manifold pressure during the trip.

The total amount of PTO fuel used in this trip.

Indicator of the Diesel Particulate Filter Regeneration during the trip. Equal to 1 if the Diesel Particulate Filter was being regenerated and 0 otherwise.

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.

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.

Minimum reported percentage of soot accumulation in the diesel particulate filter during the trip.

Maximum reported percentage of soot accumulation in the diesel particulate filter during the trip.

Average reported percentage of soot accumulation in the diesel particulate filter during the trip.

Minimum reported level of the accelerator pedal engagement during the trip.

Maximum reported level of the accelerator pedal engagement during the trip.

Average reported level of the accelerator pedal engagement during the trip.

Minimum reported RPM during the trip.

Maximum reported RPM during the trip.

Average reported RPM during the trip.

Average reported coolant temperature during the trip.

The amount of energy used by the electric vehicle's motor during the trip.

The amount of energy generated by the electric vehicle's motor during the trip.

The amount of energy used by the HVAC (Heating, Ventilation, and Air Conditioning) systems in the electric vehicles during the trip.

The amount of energy used by auxiliary systems (for example, lights and radio) in the electric vehicles during the trip.

The amount of energy used by the electric vehicles while idle during the trip.

The raw amount of electricity consumption that occurs during electric vehicle recharge during the trip.

The amount of energy used when recharging the electric vehicles during the trip.

The gain in battery energy that occurs when recharging an electric vehicle during the trip.

The difference between power used recharging and battery level gained during the trip.

The time duration that electric vehicles spend recharging during the trip.

The distance traveled by electric vehicles inside a good economical range (1500 - 2500 RPM) during the trip.

Total number of times the Anti-Lock Braking System (ABS) was engaged during the trip.

Total number of times the Roll Over Protection (ROP) engine control unit or ROP brake control was engaged during the trip.

Total number of times the Anti-Slip Regulation (ASR) was engaged during the trip.

The time when the vehicle’s ignition was turned on.

The time when the vehicle’s ignition was turned off.

The departure time associated with the trip.

The arrival time associated with the trip.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

The name of the vehicle associated with the trip.

The name of the driver associated with the trip.

The amount of natural gas used on the trip.

The time, in UTC, when the last entry for the trip was inserted in the Analytics database.

The time, in UTC, when the last entry for the trip was updated in the Analytics database.

Total count of events where the vehicle was not moving and the engine was on for longer than 10 minutes on the given date.

The name of the vehicle associated with the trip.

The name of the driver associated with the trip.

The offset between the trip’s local time and UTC in seconds.

The distance traveled in this trip, in meters.

The number of events recorded where the vehicle was harshly cornering during the trip.

The total idle time recorded for this trip, in seconds.

The total non-productive idle time recorded for this trip, in seconds.

Maximum reported vehicle speed during the trip.

A unique identifier for the trip, used within Fleet. Use TRIP_ID for grouping by this view.

A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.

A unique identifier for the driver, used within Fleet. Use DRIVER_ID for grouping by this view.

A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.

A unique identifier for the driver, used within the Analytics server. Use DRIVER_KEY for joining this view.

The marker IDs at which this trip began. Maps to the Marker view.

The marker keys at which this trip ended. Maps to the Marker view.

The marker IDs associated with the end of the trip.

The marker keys associated with the end of the trip.

The time at which this trip began, in UTC.

The time at which this trip ended, in UTC.

The start time as recorded on the hardware unit installed in the vehicle.

The end time as recorded on the hardware unit installed in the vehicle.

The duration of the trip, in seconds.

Total distance traveled in this trip, in meters.

The amount of fuel used in this trip, in milliliters.

The driving duration of this trip, in seconds.

The working duration of this trip, in seconds.

The on-site duration of this trip, in seconds.

The pre-idle state duration of this trip, in seconds.

The post-idle state duration of this trip, in seconds.

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.

The number of hard acceleration events recorded during this trip.

The number of hard braking events recorded during this trip.

The number of seat belt violation events recorded during this trip.

The number of speeding over posted violation events recorded during this trip.

The number of excessive speeding events recorded during this trip.

The engine run-time duration during this trip, in seconds.

The duration of the trip spent in a non-productive pre-idle state, in seconds.

The vehicle odometer reading at the start of the trip, in meters.

The vehicle odometer reading at the end of the trip, in meters.

The number of diagnostic trouble codes (DTCs) logged during the trip.

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.

The total time for which the seatbelt was not in use during the trip.

Trip_duration used to calculate trip values for DRIVING_WITHOUT_SEATBELT metric.

Total distance traveled in this trip, in meters.

The amount of fuel used in this trip, in milliliters.

The number of speeding in the high band events recorded during the trip.

The number of speeding in the medium band events recorded during the trip.

The number of speeding in the low band events recorded during the trip.

Total time driven within a good economical range (1500 - 2500 RPM) during the trip.

Trip_duration used to calculate trip values for TIME_IN_ECO_BAND metric.

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.

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.

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.

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.

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.

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.

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.

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.

The total time for which the seatbelt was not in use by the driver for more than 5 miles during the trip.

The total time for which the seatbelt was not in use by a passenger for more than 5 miles during the trip.

The total time for which the seatbelt was not in use by a passenger for more than 10 miles during the trip.

The total time for which the seatbelt was not in use by the driver for more than 10 miles during the trip.

The total time for which the seatbelt was not in use by the driver for more than 2 minutes during the trip.

The total time for which the seatbelt was not in use by a passenger for more than 2 minutes during the trip.

The total time for which the seatbelt was not in use by the driver for more than 10 minutes during the trip.

The total time for which the seatbelt was not in use by a passenger for more than 10 minutes during the trip.

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.

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.

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.

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.

Total duration of RPM 767 events during the trip.

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.

The total time for which the PTO (power take off) is active during the trip, in seconds. Data based on diagnostic readings.

The number of events recorded where the driver was harshly cornering during the trip.

The first address ID reported for the trip.

The first address’s street number reported for the trip.

The last address ID reported for the trip.

The last address’s street number reported for the trip.

The last fill level of the vehicle's DEF tank reported for the trip in percent, shown in increments of 5%.

Whether the fill level of the vehicle's DEF tank is known or not.

The last time fill level of the vehicle's DEF tank was reported for the trip.

Total count of RPM 767 events during the trip.

The latitude coordinate of where the trip started.

The longitude coordinate of where the trip started.

The latitude coordinate where the trip ended.

The longitude coordinate where the trip ended.

The first address’s street number reported for the trip.

The last address’s street number reported for the trip.

The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit during the trip.

The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit during the trip.

The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit during the trip.

The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit during the trip.

The number of events recorded where the vehicle was speeding 10% over the posted speed limit during the trip.

The number of events recorded where the vehicle was speeding 20% over the posted speed limit during the trip.

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.

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.

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.

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.

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.

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.

Total count of events where the vehicle was not moving and the engine is on for longer than 5 minutes during the trip.

Total count of events where the vehicle was not moving and the engine is on for longer than 15 minutes during the trip.

Total count of events where the vehicle was not moving and the engine is on for longer than 30 minutes during the trip.

Total count of events where the vehicle was not moving and the engine is on for longer than 60 minutes during the trip.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

The number of events recorded where the vehicle was speeding over 75 MPH for 2 minutes during the trip.

Total duration of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 20% over the posted speed limit for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 10% over the posted speed limit for 2 minutes during the trip.

The number of events recorded where an airbag was deployed during the trip.

The lowest battery voltage recorded during the trip.

The highest battery voltage recorded during the trip.

Total number of times the DEF (Diesel Exhaust Fluid) level warning light was active during the trip.

The lowest oil life time recorded during the trip. The oil life time is the time remaining before an oil change is due.

The highest oil life time recorded during the trip. The oil life time is the time remaining before an oil change is due.

Total number of times that the oil life remaining warning light was active during the trip.

Total number of times that the low tire pressure warning light was active during the trip.

Total number of times that the water in fuel warning light was active during the trip.

The number of times the malfunction indicator lamp (MIL), or check engine light, was active during the trip.

Total number of times the airbag warning light was active during the trip.

Maximum reported Total Engine Hours during the trip.

Minimum reported coolant temperature during the trip.

Maximum reported coolant temperature during the trip.

Maximum reported speed during the trip.

Average reported speed during the trip.

The number of events recorded where the seat belt warning light was active during the trip.

The number of events recorded where the vehicle was speeding over 85 MPH for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit for 2 minutes during the trip.

The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit for 2 minutes during the trip.

The fuel level at the end of the trip.

Minimum reported fuel rail pressure during the trip.

Maximum reported fuel rail pressure during the trip.

Average reported fuel rail pressure during the trip.

Minimum reported manifold pressure during the trip.

Maximum reported manifold pressure during the trip.

Average reported manifold pressure during the trip.

The total amount of PTO fuel used in this trip.

Indicator of the Diesel Particulate Filter Regeneration during the trip. Equal to 1 if the Diesel Particulate Filter was being regenerated and 0 otherwise.

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.

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.

Minimum reported percentage of soot accumulation in the diesel particulate filter during the trip.

Maximum reported percentage of soot accumulation in the diesel particulate filter during the trip.

Average reported percentage of soot accumulation in the diesel particulate filter during the trip.

Minimum reported level of the accelerator pedal engagement during the trip.

Maximum reported level of the accelerator pedal engagement during the trip.

Average reported level of the accelerator pedal engagement during the trip.

Minimum reported RPM during the trip.

Maximum reported RPM during the trip.

Average reported RPM during the trip.

Average reported coolant temperature during the trip.

The amount of energy used by the electric vehicle's motor during the trip.

The amount of energy generated by the electric vehicle's motor during the trip.

The amount of energy used by the HVAC (Heating, Ventilation, and Air Conditioning) systems in the electric vehicles during the trip.

The amount of energy used by auxiliary systems (for example, lights and radio) in the electric vehicles during the trip.

The amount of energy used by the electric vehicles while idle during the trip.

The raw amount of electricity consumption that occurs during electric vehicle recharge during the trip.

The amount of energy used when recharging the electric vehicles during the trip.

The gain in battery energy that occurs when recharging an electric vehicle during the trip.

The difference between power used recharging and battery level gained during the trip.

The time duration that electric vehicles spend recharging during the trip.

The distance traveled by electric vehicles inside a good economical range (1500 - 2500 RPM) during the trip.

Total number of times the Anti-Lock Braking System (ABS) was engaged during the trip.

Total number of times the Roll Over Protection (ROP) engine control unit or ROP brake control was engaged during the trip.

Total number of times the Anti-Slip Regulation (ASR) was engaged during the trip.

The time when the vehicle’s ignition was turned on.

The time when the vehicle’s ignition was turned off.

The departure time associated with the trip.

The arrival time associated with the trip.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

The name of the vehicle associated with the trip.

The name of the driver associated with the trip.

The amount of natural gas used on the trip.

The time, in UTC, when the last entry for the trip was inserted in the Analytics database.

The time, in UTC, when the last entry for the trip was updated in the Analytics database.

Total count of events where the vehicle was not moving and the engine was on for longer than 10 minutes on the given date.

The name of the vehicle associated with the trip.

The name of the driver associated with the trip.

The offset between the trip’s local time and UTC in seconds.

The distance traveled in this trip, in meters.

The number of events recorded where the vehicle was harshly cornering during the trip.

The total idle time recorded for this trip, in seconds.

The total non-productive idle time recorded for this trip, in seconds.

Maximum reported vehicle speed during the trip.