NameDescriptionTypeAdditional information
sys_service_id

The service ID of the score

unsigned integer

None.

score_period

The period of the score

ScorePeriod

None.

score_type

The type of the score

ScoreType

None.

sys_service_id_type_period

The hash used in dynamoDB

string

None.

start_date

The start date of this scoring period

date

None.

end_date

The end date of this scoring period

date

None.

last_journey_end_time

The end time of the last journey in this scoring period

date

None.

journey_count

The number of journeys taken into account in this score

unsigned integer

None.

distance

The distance traveled in meters for this score period

unsigned integer

None.

duration

The duration of travel in seconds for this score period

unsigned integer

None.

overall_score

The overall score for the score_type

unsigned integer

None.

urban_score

The overall night time score

unsigned integer

None.

urban_distance

The distance traveled in meters on urban roads in this score period

unsigned integer

None.

urban_duration

The duration of travel in seconds on urban roads in this score period

unsigned integer

None.

night_time_score

The overall night time score

unsigned integer

None.

night_time_distance

The distance traveled in meters on night time roads

unsigned integer

None.

night_time_duration

The duration of travel in seconds at night time in this score period

unsigned integer

None.

idling_score

The idling score

unsigned integer

None.

idling_duration

The duration in seconds of idling in this score period

unsigned integer

None.

longest_idling_instance

The duration of the longest single idling instance in seconds in this score period

unsigned integer

None.

speed_ideal

The ideal road speed in mph

decimal number

None.

speed_exceeded

The number of mph the speed was exceeded by

decimal number

None.

speed_score

The speeding score

unsigned integer

None.

speeding_event_count

The number of speeding events in this scoring period

unsigned integer

None.

speeding_duration

The time spent speeding in seconds

unsigned integer

None.

max_speed

The maximum speed observed during this scoring period

decimal number

None.

speed_15_count

unsigned integer

None.

speed_45_count

unsigned integer

None.

speed_55_count

unsigned integer

None.

speed_65_count

unsigned integer

None.

speed_20_count

The number of speeding events in a 20 mph zone

unsigned integer

None.

speed_30_count

The number of speeding events in a 30 mph zone

unsigned integer

None.

speed_40_count

The number of speeding events in a 40 mph zone

unsigned integer

None.

speed_50_count

The number of speeding events in a 50 mph zone

unsigned integer

None.

speed_60_count

The number of speeding events in a 60 mph zone

unsigned integer

None.

speed_70_count

The number of speeding events in a 70 mph zone

unsigned integer

None.

acceleration_score

The acceleration score

unsigned integer

None.

acceleration_event_count

The total acceleration events

unsigned integer

None.

acceleration_level_1_events

The total number of level 1 acceleration events

unsigned integer

None.

acceleration_level_2_events

The total number of level 2 acceleration events

unsigned integer

None.

acceleration_level_3_events

The total number of level 3 acceleration events

unsigned integer

None.

acceleration_max

The maximum acceleration in kilometers per hour per seconds seen in this scoring period

decimal number

None.

deceleration_score

The deceleration score

unsigned integer

None.

deceleration_event_count

The total deceleration events

unsigned integer

None.

deceleration_level_1_events

The total number of level 1 deceleration events

unsigned integer

None.

deceleration_level_2_events

The total number of level 2 deceleration events

unsigned integer

None.

deceleration_level_3_events

The total number of level 3 deceleration events

unsigned integer

None.

deceleration_max

The maximum deceleration in kilometers per hour per seconds seen in this scoring period

decimal number

None.

local_start_date

The local start date of a journey score

date

None.

local_end_date

The local end date of a journey score

date

None.

timezone

The timezone the journey ended in for a journey score

string

None.

idling_event_count

The number of idling events

unsigned integer

None.

extended_idling_event_count

The number of extended idling events

unsigned integer

None.

distance_score

The distance score

unsigned integer

None.

high_distance_journeys

Number of high distance journeys

unsigned integer

None.

low_distance_journeys

Number of low distance journeys

unsigned integer

None.

combined_distance

The combined distance traveled

unsigned integer

None.

extra_urban_distance

The extra urban distance traveled

unsigned integer

None.

ideal_fuel_used

The fuel used in litre if the fuel score was 100 percent

decimal number

None.

actual_fuel_used

The actual fuel used in litre when taking the score into account

decimal number

None.