shiftpattern

This enables a pattern of shifts to be defined for either a Resource or ResourceType. The system will automatically create these shifts over the scheduling window based upon values within Shift Type and Shift Pattern.

Syntax:

[ DynamicComponentDependency ] shiftpattern ShiftPatternName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name	Data Type	Description
id	String(32)	Specifies the unique identifier for the shift pattern.
period_end_datetime	Date	Specifies the end date and time for the pattern to be applied.
period_start_datetime	Date	Specifies the starting date and time for the pattern to be applied.
shift_type_id	String(32)	Specifies the type of shift to be created from the day_pattern.

Optional columns

Column Name	Data Type	Description	Default Value
day_pattern	String(7)	Specifies a seven character string indicating each day of the week the default shift should apply too.	YYYYYNN
start_time	Number (minutes by default)	Specifies the time each day specified in day_pattern when the shift starts.	08:00:00
description	String(2000)	Provides a description of the Shift Pattern, which may be shown in the Scheduling Workbench
resource_id	String(32)	Specifies the resource to which the shift pattern should be applied.
resource_type_id	String(32)	Specifies the resource type to which the shift pattern should be applied.
split_allowed	Number (0 = False, 1 = True)	Indicates whether activities are allowed to be split into the shifts created from Shift.
time_zone	String(32)	Defines the UTC time zone code to be used for start_time and day_pattern.
travel_with_resource_id	String(32)	Specifies the id of the resource this resource must travel with.



            shiftpattern ShiftPattern {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  period_end_datetime,
                     ..                  period_start_datetime,
                     ..                  shift_type_id,
                  -- optional columns
                     ..                  day_pattern,
                     ..                  start_time,
                     ..                  description,
                     ..                  resource_id,
                     ..                  resource_type_id,
                     ..                  split_allowed,
                     ..                  time_zone,
                     ..                  travel_with_resource_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ShiftPatternName

Syntax:

<Identifier>

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