travelcostmodel

Travel cost models allow for a more detailed definition of how costs should be applied to each journey made by a resource. This allows the DSE to intelligently select when it is appropriate for a resource to carry out a longer journey, or to travel a significant distance from their base location.

Syntax:

[ DynamicComponentDependency ] travelcostmodel TravelCostModelName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name	Data Type	Description	Default Value
id	String(32)	Specifies the unique identifier for this Travel Cost Model.

Optional columns

Column Name	Data Type	Description	Default Value
cost_km	Double	Defines the default cost to apply for each kilometre travelled.	0.25
description	String(2000)	Provides a description for this travel cost model.
maximum_journey_time	Number (minutes by default)	Specifies the maximum allowed length of any single journey.
maximum_shift_travel_time	Number (minutes by default)	Specifies the maximum total travel allowed in a shift.
maximum_travel_home_time	Number (minutes by default)	Specifies the maximum distance from home that a resource is allowed to travel to.
travel_from_charge_proportion	Double	Specifies the proportion of the usual travel cost that should be applied during the 'travel from' period.
travel_to_charge_proportion	Double	Specifies the proportion of the usual travel cost that should be applied during the 'travel to' period.



            travelcostmodel TravelCostModel {{SelectName}} {
               SELECT
                     ..                  id,
                  -- optional columns
                     ..                  cost_km,
                     ..                  description,
                     ..                  maximum_journey_time,
                     ..                  maximum_shift_travel_time,
                     ..                  maximum_travel_home_time,
                     ..                  travel_from_charge_proportion,
                     ..                  travel_to_charge_proportion
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

TravelCostModelName

Syntax:

<Identifier>

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