Answer
Below, is a complete list of what each column is with a brief description
Column Name | Description |
DeviceName | Name of Device within database |
DeviceId | Device's raw Id (IE: device, id:b123) |
DeviceComment | Comments within the Device Edit page |
DeviceGroup | Groups associated with Device |
UserFirstName | Driver's first name associated with vehicle |
UserLastName | Driver's last name associated with vehicle |
UserName | Driver's username associated with vehicle |
UserId | Driver's raw user Id (IE:user,id:b41B4) |
UserComment | Comments within the user/driver's profile |
DriverGroup | Group's associated with Driver |
TripDetailRouteName | Trips Route Name (If applicable, defined in Routes) |
TripDetailStartDateTime | Trip's Start Time |
TripDetailDrivingDuraion | Trip's Driving Duration |
TripDetailStopDateTime | Trip's Stop Time |
TripDetailDistance | Total Trip Distance |
TripDetailStopDuration | Stopped Duration between Trips or since last Trip |
TripDetailLatitude | Trip Latitude of GPS Point |
TripDetailLongitude | Trip Longitude of GPS Point |
TripDetailLocation | Trip Location of Latitude/Longitude |
Location.ZoneZoneTypes | Zone Type of Location |
Location.ZoneExternalReference | Comment in Zone Type of Location |
TripDetailPrivateTrip | Personal Mode On or Off |
TripDetailIdlingDuration | Total Duration of Idling on Trip |
TripDetailMaximumSpeed | Maximum Speed of Trip |
TripDetailSpeedRange1 | Count of Max Speed events exceeding Speed Band 1 (Defined in System Settings) |
TripDetailSpeedRange1Duration | Duration of Max Speed events exceeding Speed Band 1 (Defined in System Settings) |
TripDetailSpeedRange2 | Count of Max Speed events exceeding Speed Band 2 (Defined in System Settings) |
TripDetailSpeedRange2Duration | Duration of Max Speed events exceeding Speed Band 2 (Defined in System Settings) |
TripDetailSpeedRange3 | Count of Max Speed events exceeding Speed Band 3 (Defined in System Settings) |
TripDetailSpeedRange3Duration | Duration of Max Speed events exceeding Speed Band 3 (Defined in System Settings) |
TripDetailIsStartDriveWorkHours | Did Trip Start within Standard Work Hours? Yes or No (Defined in Work Hours Settings) |
TripDetailIsStopDriveWorkHours | Did Trip Stop within Standard Work Hours? Yes or No (Defined in Work Hours Settings) |
TripDetailWorkHoursDistance | Distance Driven within Standard Work Hours (Defined in Work Hours Settings) |
TripDetailWorkHoursTripTime | Trip Driving Duration within Standard Work Hours (Defined in Work Hours Settings) |
TripDetailWorkHoursStopTime | Trip Stop Duration within Standard Work Hours (Defined in Work Hours Settings) |
TripDetailOdometerAtStart | Odometer of Vehicle at Start of Trip |
TripDetailExceptionRule1Duration | Duration of Exception Rule 1 (Rule Defined in Report Settings) |
TripDetailExceptionRule1Count | Count of Exception Rule 1 events (Rule Defined in Report Settings) |
TripDetailExceptionRule1Distance | Distance of Exception Rule 1 (Rule Defined in Report Settings) |
TripDetailExceptionRule2Duration | Duration of Exception Rule 2 (Rule Defined in Report Settings) |
TripDetailExceptionRule2Count | Count of Exception Rule 2 events (Rule Defined in Report Settings) |
TripDetailExceptionRule2Distance | Distance of Exception Rule 2 (Rule Defined in Report Settings) |
TripDetailExceptionRule3Duration | Duration of Exception Rule 3 (Rule Defined in Report Settings) |
TripDetailExceptionRule3Count | Count of Exception Rule 3 events (Rule Defined in Report Settings) |
TripDetailExceptionRule3Distance | Distance of Exception Rule 3 (Rule Defined in Report Settings) |
TripDetailExceptionRule4Duration | Duration of Exception Rule 4 (Rule Defined in Report Settings) |
TripDetailExceptionRule4Count | Count of Exception Rule 4 events (Rule Defined in Report Settings) |
TripDetailExceptionRule4Distance | Distance of Exception Rule 4 (Rule Defined in Report Settings) |
TripDetailExceptionRule5Duration | Duration of Exception Rule 5 (Rule Defined in Report Settings) |
TripDetailExceptionRule5Count | Count of Exception Rule 5 events (Rule Defined in Report Settings) |
TripDetailExceptionRule5Distance | Distance of Exception Rule 5 (Rule Defined in Report Settings) |
TripDetailExceptionRule6Duration | Duration of Exception Rule 6 (Rule Defined in Report Settings) |
TripDetailExceptionRule6Count | Count of Exception Rule 6 events (Rule Defined in Report Settings) |
TripDetailExceptionRule6Distance | Distance of Exception Rule 6 (Rule Defined in Report Settings) |
TripDetailExceptionRule7Duration | Duration of Exception Rule 7 (Rule Defined in Report Settings) |
TripDetailExceptionRule7Count | Count of Exception Rule 7 events (Rule Defined in Report Settings) |
TripDetailExceptionRule7Distance | Distance of Exception Rule 7 (Rule Defined in Report Settings) |
TripDetailExceptionRule8Duration | Duration of Exception Rule 8 (Rule Defined in Report Settings) |
TripDetailExceptionRule8Count | Count of Exception Rule 8 events (Rule Defined in Report Settings) |
TripDetailExceptionRule8Distance | Distance of Exception Rule 8 (Rule Defined in Report Settings) |
TripStartEVBatteryCharge | Battery charge level for Electric Vehicles at the start of the trip |
TripEndEVBatteryCharge | Battery charge level for Electric Vehicles at the end of the trip |
TripElectricEnergyUsed | Energy used by Electric Vehicles over the course of the trip |
TripElectricEnergyUsedWhileDriving | Energy used by Electric Vehicles specifically while driving during the trip |
TripElectricEnergyUsedWhileIdling | Energy used by Electric Vehicles specifically while idling during the trip |
TripElectricEnergyEconomy | Electric energy economy for the duration of the trip |
TripDetailFuelConsumed | Fuel usage for the trip |