resourcetype

Defines types of resources to be used in the scheduling. Used to define default valuesfor resources of a specified type. If values are not specified in the sourcetype then they must be specified on the resource.

Syntax:

[ DynamicComponentDependency ] resourcetype ResourceTypeName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] [ UrlPropertySetting ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Specifies the unique id for the Resource Type.

Optional columns

Column Name Data Type Description Default Value
cost_km Double Defines the cost per KM travelling. 0.25
cost_ph Double Defines the cost per hour on shift. 20
cost_phot Double Defines the cost per hour on shift overtime. 30
out_of_region_multiplier Double Defines a multiplier to be applied to the value of any activities done by a resource outside his/her region.  So a value of 0 means that activities cannot be done outside the region, whereas a value of 1 means that activities may freely be done outside the region and are just as likely to be chosen as ones inside the region. 0
utilisation Number Defines the maximum amount of time to be scheduled in the shift for all the resources of this type. 100
description String(2000) Provides a description for the resource type.
hire_cost Double Defines the cost of hiring resources of this type.  If not provided then no new resources can be included for planning.
location_id_end String(32) Specifies the end location id when finishing shift.
location_id_start String(32) Specifies the start location id when logging on to shift.
max_travel Number (minutes by default) Specifies the max travel time away from the start location a resource will travel.
profile_id_travel String(32) Specifies the travel profile to be used for this resource type.
release_cost Double The cost of releasing a resource of this type. If not provided the APCS will not release any resources of this type.
relocation_cost Double Specifies the cost of relocating a resource of this type. If not provided a resource of this type cannot be relocated.
rule_collection_id String(32) Specifies the id of the rule collection associated with resources of this type.
separation_model_id String(32) Specifies the id of the separation model associated with resources of this type.
shift_cost Double Defines the one off cost of a resource being given work in a shift. Can be overridden at Resource and Shift levels.
speedfactor Double Defines the proportion of any travel time approximation made by the DSE. If this is set to 0.5, the DSE assumes half its estimated travel time as the actual travel time. If it is set to 2, the DSE assumes twice its estimated travel time.
time_zone String(32) Specifies the id of the time zone associated with resources of this type.
travel_cost_model_id String(32) Specifies the travel cost model to use for resources of this type.
travel_from Number (minutes by default) Provides the maximum unpaid travel time at end  of shift.
travel_to Number (minutes by default) Provides the maximum unpaid travel time at start of shift. 


            resourcetype ResourceType {{SelectName}} {
               SELECT
                     ..                  id,
                  -- optional columns
                     ..                  cost_km,
                     ..                  cost_ph,
                     ..                  cost_phot,
                     ..                  out_of_region_multiplier,
                     ..                  utilisation,
                     ..                  description,
                     ..                  hire_cost,
                     ..                  location_id_end,
                     ..                  location_id_start,
                     ..                  max_travel,
                     ..                  profile_id_travel,
                     ..                  release_cost,
                     ..                  relocation_cost,
                     ..                  rule_collection_id,
                     ..                  separation_model_id,
                     ..                  shift_cost,
                     ..                  speedfactor,
                     ..                  time_zone,
                     ..                  travel_cost_model_id,
                     ..                  travel_from,
                     ..                  travel_to
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ResourceTypeName

Syntax:

<Identifier>

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