ramshifttempitembreak

A template for creating a break within a rota item.

Syntax:

[ DynamicComponentDependency ] ramshifttempitembreak RAMShiftTempItemBreakName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique id.
earliest_start Number (minutes by default) The earliest time into the shift when the break can start.
ram_shift_template_id String(32) The shift template this belongs to.
sequence Number The sequence of the item this applies to.

Optional columns

Column Name Data Type Description Default Value
duration Number (minutes by default) The duration of the break.
latest_start Number (minutes by default) The latest time into the shift when the break can start.
ram_activity_type_id String(32) The activity type to use for the break. 


            ramshifttempitembreak RAMShiftTempItemBreak {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  earliest_start,
                     ..                  ram_shift_template_id,
                     ..                  sequence,
                  -- optional columns
                     ..                  duration,
                     ..                  latest_start,
                     ..                  ram_activity_type_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMShiftTempItemBreakName

Syntax:

<Identifier>

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