traveltimeweighting

This contains entries for the weighting to be applied at a particular time to the travel time between two points. It is used to describe different travel times through the day. The travel time profile must have been created before data can be sent into the system for the profile.

Syntax:

[ DynamicComponentDependency ] traveltimeweighting TravelTimeWeightingName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Unique identifier.
travel_time_profile_id String(32) The travel time profile identifier
end_time Number (minutes by default) The end time the weighting applies
start_time Number (minutes by default) The start time the travel weighting applies.
weighting Double The multiplier to be applied to the travel time.

Optional columns

Column Name Data Type Description Default Value
day_pattern String(7) The day pattern for when the weighting is applied.
time_zone String(32) The time zone for the weighting 


            traveltimeweighting TravelTimeWeighting {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  travel_time_profile_id,
                     ..                  end_time,
                     ..                  start_time,
                     ..                  weighting,
                  -- optional columns
                     ..                  day_pattern,
                     ..                  time_zone
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling TravelTimeWeighting.

TravelTimeWeightingName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:49.