ramresourcetype

Used to specify shared type information for resources.

Syntax:

[ DynamicComponentDependency ] ramresourcetype RAMResourceTypeName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique id.
ram_resource_class_id String(32) The classification of this resource type.

Optional columns

Column Name Data Type Description Default Value
cost_km Double The distance cost to use for this resource. 0.25
cost_ph Double The hourly cost to use for this resource. 20
cost_phot Double The overtime cost to use for this resource. 30
hire_cost Double The cost of hiring a new resource of this type - for use with WISE. 4000
out_of_region_multiplier Double The out of region multiplier to use for this resource. 0
release_cost Double The cost of releasing a new resource of this type - for use with WISE. 4000
speedfactor Double A multiplier to apply to all travels for this resource. 1
travel_from Number (minutes by default) The travel allowed beyond the end of shift for this resource. 00:00:00
travel_to Number (minutes by default) The travel allowed before the start of shift for this resource. 00:00:00
utilisation Number The default maximum shift utilisation allowed for this resource. 100
description String(2000) A description for this resource type.
max_travel Number (minutes by default) The maximum travel time allowed for this resource.
profile_id String(32) The profile to use for travel calculations for this resource.
ram_location_id_end String(32) The end location for resources of this type
ram_location_id_start String(32) The start location for resources of this type
ram_rule_collection_id String(32) The rules to apply against shifts for resources of this type.
ram_shift_template_set_id String(32) The shift template set that can be used to generate shifts for resources of this type.
ram_travel_cost_model_id String(32) The travel cost model to use for resources of this type.
separation_model_id String(32) Specifies the id of the separation model associated with resources of this type. 


            ramresourcetype RAMResourceType {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  ram_resource_class_id,
                  -- optional columns
                     ..                  cost_km,
                     ..                  cost_ph,
                     ..                  cost_phot,
                     ..                  hire_cost,
                     ..                  out_of_region_multiplier,
                     ..                  release_cost,
                     ..                  speedfactor,
                     ..                  travel_from,
                     ..                  travel_to,
                     ..                  utilisation,
                     ..                  description,
                     ..                  max_travel,
                     ..                  profile_id,
                     ..                  ram_location_id_end,
                     ..                  ram_location_id_start,
                     ..                  ram_rule_collection_id,
                     ..                  ram_shift_template_set_id,
                     ..                  ram_travel_cost_model_id,
                     ..                  separation_model_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMResourceTypeName

Syntax:

<Identifier>

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