shift

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

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,
                     ..                  rule_collection_id,
                     ..                  shift_cost,
                     ..                  shift_cut_off,
                     ..                  shift_type_id,
                     ..                  shift_visit_cost,
                     ..                  snap_time,
                     ..                  split_allowed,
                     ..                  split_priority,
                     ..                  travel_cost_model_id,
                     ..                  travel_from,
                     ..                  travel_to,
                     ..                  travel_with_resource_id,
                     ..                  utilisation,
                     ..                  vehicle_id
               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 2025-10-22 16:02.