shifttypebreak

This allows a shift break to be defined for a shift type, rather than defining each break individually.

Syntax:

[ DynamicComponentDependency ] shifttypebreak ShiftTypeBreakName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Defines a unique id for the shift type break.
duration Number (minutes by default) Defines the duration of the break.
earliest_start_offset Number (minutes by default) Defines the earliest offset from the start of the shift at which the break may start.
latest_start_offset Number (minutes by default) Defines the latest offset from the start of the shift at which the break may start.
shift_type_id String(32) Specifies the id of the shift type the break relates to.


            shifttypebreak ShiftTypeBreak {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  duration,
                     ..                  earliest_start_offset,
                     ..                  latest_start_offset,
                     ..                  shift_type_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ShiftTypeBreakName

Syntax:

<Identifier>


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