Name | Description | Type | Additional information |
---|---|---|---|
AssetID |
The ID of the asset which made the journey |
unsigned integer |
None. |
ServiceID |
The ID of the Service which made the journey |
unsigned integer |
None. |
SummaryType |
The type of the summary |
JourneySummaryType |
None. |
StartDate |
The start date of the summary |
date |
None. |
EndDate |
The end date of the summary |
date |
None. |
FirstJourneyStartDate |
The start date of the first journey |
date |
None. |
LastJourneyEndDate |
The end date of the last journey |
date |
None. |
Duration |
The duration of the all journeys in seconds |
unsigned integer |
None. |
IdleTime |
The journey idle time in seconds during all the journeys |
unsigned integer |
None. |
MaxIdleInstance |
The maximum period of idling during all the journeys |
unsigned integer |
None. |
DistanceMeters |
The distance traveled in meters during the journeys |
unsigned integer |
None. |
StartLat |
The start latitude of the first journey |
decimal number |
None. |
StartLong |
The start longitude of the first journey |
decimal number |
None. |
StartStreet |
The start street of the first journey |
string |
None. |
StartTown |
The start town of the first journey |
string |
None. |
StartCountry |
The start country of the first journey |
string |
None. |
StartPOI |
The start POI of the first journey |
string |
None. |
StartPostcode |
The start postcode of the first journey |
string |
None. |
EndLat |
The end latitude of the last journey |
decimal number |
None. |
EndLong |
The end longitude of the last journey |
decimal number |
None. |
EndStreet |
The end street of the last journey |
string |
None. |
EndTown |
The end town of the last journey |
string |
None. |
EndCountry |
The end country of the last journey |
string |
None. |
EndPOI |
The end POI of the last journey |
string |
None. |
EndPostcode |
The end post code of the last journey |
string |
None. |
RpmEvents |
The number of RPM events seen during the journeys |
unsigned integer |
None. |
RpmMax |
The maximum RPM value seen during the journeys |
unsigned integer |
None. |
RpmLevel1Count |
The number of RPM level 1 events during the journeys |
unsigned integer |
None. |
RpmLevel2Count |
The number of RPM level 2 events during the journeys |
unsigned integer |
None. |
RpmLevel3Count |
The number of RPM level 3 events during the journeys |
unsigned integer |
None. |
RpmLevel4Count |
The number of RPM level 4 events during the journeys |
unsigned integer |
None. |
RpmLevel5Count |
The number of RPM level 5 events during the journeys |
unsigned integer |
None. |
RpmLevel6Count |
The number of RPM level 6 events during the journeys |
unsigned integer |
None. |
AccelEvents |
The amount of acceleration events during the journeys |
unsigned integer |
None. |
AccelMax |
The maximum acceleration instance during the journeys |
decimal number |
None. |
AccelLowCount |
The amount of low level acceleration events during the journeys |
unsigned integer |
None. |
AccelMediumCount |
The amount of medium level acceleration events during the journeys |
unsigned integer |
None. |
AccelHighCount |
The amount of high level acceleration events during the journeys |
unsigned integer |
None. |
DecelEvents |
The amount of deceleration events during the journeys |
unsigned integer |
None. |
DecelMax |
The maximum deceleration instance during the journeys |
decimal number |
None. |
DecelLowCount |
The amount of low level deceleration events during the journeys |
unsigned integer |
None. |
DecelMediumCount |
The amount of medium level deceleration events during the journeys |
unsigned integer |
None. |
DecelHighCount |
The amount of high level deceleration events during the journeys |
unsigned integer |
None. |
SpeedEvents |
The number of speeding events during the journeys |
unsigned integer |
None. |
SpeedMax |
The maximum speed during the journeys |
decimal number |
None. |
Speed15Count | unsigned integer |
None. |
|
Speed45Count | unsigned integer |
None. |
|
Speed55Count | unsigned integer |
None. |
|
Speed65Count | unsigned integer |
None. |
|
Speed20Count |
The number of speeding events in 20 mph zones during the journeys |
unsigned integer |
None. |
Speed30Count |
The number of speeding events in 30 mph zones during the journeys |
unsigned integer |
None. |
Speed40Count |
The number of speeding events in 40 mph zones during the journeys |
unsigned integer |
None. |
Speed50Count |
The number of speeding events in 50 mph zones during the journeys |
unsigned integer |
None. |
Speed60Count |
The number of speeding events in 60 mph zones during the journeys |
unsigned integer |
None. |
Speed70Count |
The number of speeding events in 70 mph zones during the journeys |
unsigned integer |
None. |
DeadzoneTime |
The night time driving score in seconds during the journey |
unsigned integer |
None. |
UrbanDistance |
The urban distance driven during the journey |
unsigned integer |
None. |
CO2 |
The CO2 used in the journey |
decimal number |
None. |
Input0Distance |
The distance driven with input 0 active |
unsigned integer |
None. |
Input1Distance |
The distance driven with input 1 active |
unsigned integer |
None. |
Input2Distance |
The distance driven with input 2 active |
unsigned integer |
None. |
Input3Distance |
The distance driven with input 3 active |
unsigned integer |
None. |
Input0Duration |
The duration in seconds when input 0 was active |
unsigned integer |
None. |
Input1Duration |
The duration in seconds when input 1 was active |
unsigned integer |
None. |
Input2Duration |
The duration in seconds when input 2 was active |
unsigned integer |
None. |
Input3Duration |
The duration in seconds when input 3 was active |
unsigned integer |
None. |
ActionDistance |
The distance driven with the action state active |
unsigned integer |
None. |
ActionDuration |
The duration in seconds when the action state was active |
unsigned integer |
None. |
StartVoltage |
The vehicle battery voltage at the start of the first journey |
decimal number |
None. |
EndVoltage |
The vehicle battery voltage at the end of the last journey |
decimal number |
None. |
WaterUsed |
Water used during the journeys if applicable |
decimal number |
None. |
AreaCleaned |
The area cleaned during the journeys if applicable |
decimal number |
None. |
StartFuelPercentage |
The start fuel percentage from the first journey |
decimal number |
None. |
EndFuelPercentage |
The end fuel percentage from the last journey |
decimal number |
None. |
StartFuelLitre |
The start fuel level from the first journey |
decimal number |
None. |
EndFuelLitre |
The end fuel level from the last journey |
decimal number |
None. |
TotalFuelUsed |
The fuel used in litres |
decimal number |
None. |
JourneyCount |
The number of journeys completed |
unsigned integer |
None. |
IdlingJourneyCount |
The number of journeys idling |
unsigned integer |
None. |
MaximumJourneyDistance |
The maximum journey distance in meters |
unsigned integer |
None. |
MinimumJourneyDistance |
The minimum journey distance in meters |
unsigned integer |
None. |
MaximumJourneyDuration |
The maximum journey duration in seconds |
unsigned integer |
None. |
MinimumJourneyDuration |
The minimum journey duration in seconds |
unsigned integer |
None. |
ReportingAssets |
if summarising for more than one vehicle, the count of vehicles that reported in during the selected time |
integer |
None. |
Previous16WeeksWorkingTime |
The total working time for the previous 16 weeks, this is only populated on weekly records |
unsigned integer |
None. |
CurrentPeriodWorkingTime |
The current period working time, this is only populated on the daily and weekly records |
unsigned integer |
None. |