activitysla

Assigns an SLA of a given type to an activity. An activity of class CALL or BREAK that falls within the scheduling window must have an Activity_SLA for it to be considered by the scheduler.Unless stated otherwise, the system will attempt to schedule the start of the activity within the defined SLA period.

Syntax:

[ DynamicComponentDependency ] activitysla ActivitySLAName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
activity_id String(32) Specifies the id of the activity this relates to.
sla_type_id String(32) Specifies the id of the SLA type this relates to.
datetime_start Date Defines the date and time at which the SLA begins for this activity.

Optional columns

Column Name Data Type Description Default Value
priority Number Defines the uniqueness of the SLA. 1
start_based Number (0 = False, 1 = True) Defines whether the start of the activity must be scheduled within the defined SLA period. True
datetime_end Date Defines the date time at which the SLA ends for this activity. Must be after Time Start. 


            activitysla ActivitySLA {{SelectName}} {
               SELECT
                     ..                  activity_id,
                     ..                  sla_type_id,
                     ..                  datetime_start,
                  -- optional columns
                     ..                  priority,
                     ..                  start_based,
                     ..                  datetime_end
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ActivitySLAName

Syntax:

<Identifier>

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