A template for creating rota items.
Syntax:
[ DynamicComponentDependency ] ramshifttemplate RAMShiftTemplateName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | A unique id. | |
duration | Number (minutes by default) | The default duration to use for rota items. | |
ram_shift_category_id | String(32) | The shift category. | |
recurrence_days | Number | The number of days over which the pattern will repeat. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
precedence | Double | The order of precedence of this template. | 1 |
repeat_preference | Double | Indicates a preference for using this template repeatedly for a resource. | 1 |
split_allowed | Number (0 = False, 1 = True) | Whether splittable activities can be split across this shift. | True |
description | String(2000) | A description for this pattern | |
early_end_leeway | Number (minutes by default) | If the resource logs on early it is assumed they also finish early up to this amount. | |
late_end_leeway | Number (minutes by default) | If the resource logs on late it is assumed they also finish late up to this amount. | |
manual_scheduling_only | Number (0 = False, 1 = True) | Specifies that this shift should not have activities automatically scheduled into it by the DSE. | |
overtime_period | Number (minutes by default) | The default overtime period to use for rota items. | |
ram_utilisation_template_id | String(32) | The utilisation template to use to determine utilisation. | |
shift_cost | Double | The cost of scheduling any activities in the shift. | |
snap_time | Number (minutes by default) | The default snap time to use for rota items. | |
split_priority | Number | The priority required to allow activities to be split into this shift. | |
start_day | Number | The day of the week this pattern must start on | |
utilisation | Number | The maximum utilisation allowed for rota items. |
ramshifttemplate RAMShiftTemplate {{SelectName}} { SELECT .. id, .. duration, .. ram_shift_category_id, .. recurrence_days, -- optional columns .. precedence, .. repeat_preference, .. split_allowed, .. description, .. early_end_leeway, .. late_end_leeway, .. manual_scheduling_only, .. overtime_period, .. ram_utilisation_template_id, .. shift_cost, .. snap_time, .. split_priority, .. start_day, .. utilisation FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMShiftTemplate.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.