A template for creating an individual rota item.
Syntax:
[ DynamicComponentDependency ] ramshifttemplateitem RAMShiftTemplateItemName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
ram_shift_template_id | String(32) | The shift template that this item belongs to. | |
sequence | Number | Order of item within template. | |
day_increment | Number | Number of days form start date when this shift starts. | |
time_increment | Number (minutes by default) | Time from start date when this shift starts. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
description | String(2000) | A description for this shift template item. | |
duration | Number (minutes by default) | The duration of the shift. Value taken from RAM_Shift_Template if not defined. | |
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 overtime period of the shift. Value taken from RAM_Shift_Template if not defined. | |
ram_shift_category_id | String(32) | The shift category. Value taken from RAM_Shift_Template if not defined. | |
snap_time | Number (minutes by default) | The snap time of the shift. Value taken from RAM_Shift_Template if not defined. | |
split_allowed | Number (0 = False, 1 = True) | Whether shifts created from this template item will allow activities to split across them. | |
split_priority | Number | The split priority to use for shifts created from this template item. |
ramshifttemplateitem RAMShiftTemplateItem {{SelectName}} { SELECT .. ram_shift_template_id, .. sequence, .. day_increment, .. time_increment, -- optional columns .. description, .. duration, .. early_end_leeway, .. late_end_leeway, .. manual_scheduling_only, .. overtime_period, .. ram_shift_category_id, .. snap_time, .. split_allowed, .. split_priority FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMShiftTemplateItem.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.