ramresource

A person or team against which activities can be scheduled.

Syntax:

[ DynamicComponentDependency ] ramresource RAMResourceName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

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

Optional columns

Column Name Data Type Description Default Value
contact_details String(256) Contact details for the resource (phone number etc)
cost_km Double The distance cost to use for this resource.
cost_ph Double The hourly cost to use for this resource.
cost_phot Double The overtime cost to use for this resource.
dataset_id_parent String(32) Used internally to keep datasets updated when transferring resources.
description String(2000) A description of the resource.
first_name String(64) The first name of the resource.
max_travel Number (minutes by default) The maximum travel time allowed for this resource.
memo String(2000) A memo comment against this resource.
out_of_region_multiplier Double The out of region multiplier to use for this resource.
profile_id String(32) The profile to use for travel calculations for this resource.
ram_location_id_end String(32) The default end location ofr shifts for this resource.
ram_location_id_start String(32) The default start location for shifts for this resource.
ram_position_id String(32) The id of the position attributed to this resource.
ram_resource_class_id String(32) The classification of this resource.
ram_rule_collection_id String(32) The rules to apply against shifts for this resource.
ram_shift_template_set_id String(32) The set of shift templates that can be used to plan shifts for this resource.
ram_travel_cost_model_id String(32) The travel cost model to use for this resource.
separation_model_id String(32) Specifies the id of the separation model associated with this resource.
speedfactor Double A multiplier to apply to all travels for this resource.
surname String(64) The surname of the resource.
time_zone_id String(32) The default time zone to use when creating rota items for this resource.
travel_from Number (minutes by default) The travel allowed beyond the end of shift for this resource.
travel_to Number (minutes by default) The travel allowed before the start of shift for this resource.
utilisation Number The default maximum shift utilisation allowed for this resource. 


            ramresource RAMResource {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  ram_resource_type_id,
                  -- optional columns
                     ..                  contact_details,
                     ..                  cost_km,
                     ..                  cost_ph,
                     ..                  cost_phot,
                     ..                  dataset_id_parent,
                     ..                  description,
                     ..                  first_name,
                     ..                  max_travel,
                     ..                  memo,
                     ..                  out_of_region_multiplier,
                     ..                  profile_id,
                     ..                  ram_location_id_end,
                     ..                  ram_location_id_start,
                     ..                  ram_position_id,
                     ..                  ram_resource_class_id,
                     ..                  ram_rule_collection_id,
                     ..                  ram_shift_template_set_id,
                     ..                  ram_travel_cost_model_id,
                     ..                  separation_model_id,
                     ..                  speedfactor,
                     ..                  surname,
                     ..                  time_zone_id,
                     ..                  travel_from,
                     ..                  travel_to,
                     ..                  utilisation
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMResourceName

Syntax:

<Identifier>

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