shift

This provides the shift for a resource and details the start/end location of theshift. Shifts are used to determine what planned availability there is for aresource.

Syntax:

[ DynamicComponentDependency ] shift ShiftName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Optional columns

            shift Shift {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  start_datetime,
                  -- optional columns
                     ..                  cost_km,
                     ..                  cost_ph,
                     ..                  cost_phot,
                     ..                  description,
                     ..                  early_end_leeway,
                     ..                  end_datetime,
                     ..                  late_end_leeway,
                     ..                  location_id_end,
                     ..                  location_id_start,
                     ..                  manual_scheduling_only,
                     ..                  max_travel,
                     ..                  overtime_period,
                     ..                  profile_id_travel,
                     ..                  resource_id,
                     ..                  resource_type_id,
                     ..                  shift_cost,
                     ..                  shift_type_id,
                     ..                  snap_time,
                     ..                  split_allowed,
                     ..                  split_priority,
                     ..                  travel_cost_model_id,
                     ..                  travel_from,
                     ..                  travel_to,
                     ..                  travel_with_resource_id,
                     ..                  utilisation
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ShiftName

Syntax:

<Identifier>

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