This defines a calendar which can be applied to the SLAs of an activity. The slopes on the SLA will only apply during active calendar periods. The calendar consists of a weekly availability pattern, defined as Calendar_Item rows, plus overrides for particular days, e.g. bank holidays. These are defined as Special_Day and Special_Day_Item rows.
Syntax:
[ DynamicComponentDependency ] calendar CalendarName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | Defines a unique id for the calendar. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
description | String(2000) | Provides a description of the calendar. | |
time_zone | String(32) | The time zone to use when applying the calendar. If not supplied the local server time zone will be used. |
calendar Calendar {{SelectName}} { SELECT .. id, -- optional columns .. description, .. time_zone FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling Calendar.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:48.