Document toolboxDocument toolbox

14.1 sp209_peak_travel_times

This table specifies the peak travel factor for various times of the day for each journey type.


 

Table Definition

Field
Type
Default
Nullable
journey_typenumber(3)  (error)
start_timedate  (error)
end_timedate (tick)
travel_factornumber(2,1) (error)

Keys 

primary key (journey_type, start_time) 
foreign key (journey_type) references 14.1 sp263_journey_types (journey_type)

Column Descriptions

FieldDescription
journey_type

Journey type identifier. 

start_timeStart time – only time of day is used. Uses Region Time Zone. 
end_timeEnd time – only time of day is used. Uses Region Time Zone.
travel_factorPeak travel factor to be applied for journeys commencing between start_time and end_time.