Defines a resource and the costs associated with it. These are what are scheduled by the Dynamic Scheduling Engine.
Syntax:
[ DynamicComponentDependency ] resource ResourceName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] [ UrlPropertySetting ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | Defines a unique id for the Resource. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
resource_type_id | String(32) | Specifies the unique id of the Resource Type | Default |
contact_details | String(256) | Provides contact details for the resource. | |
cost_km | Double | Defines cost per KM travelling for this resource. | |
cost_ph | Double | Defines cost per hour on shift for this resource. | |
cost_phot | Double | Defines cost per hour on shift overtime for this resource. | |
description | String(2000) | Provides a description of the Resource, which may be shown in the Scheduling Workbench | |
first_name | String(40) | Specifies the Resource first name | |
location_id_end | String(32) | Defines the end location id when finishing shift. | |
location_id_start | String(32) | Defines the start location id when logging on to shift. | |
max_travel | Number (minutes by default) | Defines the max travel time away from location start resource will travel. | |
memo | String(2000) | Provides a free format memo field. | |
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. | |
profile_id_travel | String(32) | Specifies the travel profile to be used for this resource. | |
rule_collection_id | String(32) | Specifies the id of the rule collection associated with this resource. | |
separation_model_id | String(32) | Specifies the id of the separation model associated with this resource. | |
shift_cost | Double | Specifies the default cost to apply when using a shift for this resource. | |
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. | |
surname | String(40) | Specifies the Resource name. | |
time_zone | String(32) | Specifies the id of the time zone associated with this resource. | |
travel_cost_model_id | String(32) | Specifies the travel cost model to use for this resource. | |
travel_from | Number (minutes by default) | Specifies the maximum unpaid travel time at end of shift. | |
travel_to | Number (minutes by default) | Specifies the maximum unpaid travel time at start of shift. | |
travel_with_resource_id | String(32) | Specifies the id of the accompanying resource with whom this resource must travel. | |
utilisation | Number | Specifies the maximum amount of time to be scheduled in the shift for the resource. |
resource Resource {{SelectName}} { SELECT .. id, -- optional columns .. resource_type_id, .. contact_details, .. cost_km, .. cost_ph, .. cost_phot, .. description, .. first_name, .. location_id_end, .. location_id_start, .. max_travel, .. memo, .. out_of_region_multiplier, .. profile_id_travel, .. rule_collection_id, .. separation_model_id, .. shift_cost, .. speedfactor, .. surname, .. time_zone, .. travel_cost_model_id, .. travel_from, .. travel_to, .. travel_with_resource_id, .. utilisation FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling Resource.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.