ramcalendar

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. Links to Calendar in the Scheduling Schema.

Syntax:

[ DynamicComponentDependency ] ramcalendar RAMCalendarName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique id.

Optional columns

Column Name Data Type Description Default Value
description String(2000) A description for 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.


            ramcalendar RAMCalendar {{SelectName}} {
               SELECT
                     ..                  id,
                  -- optional columns
                     ..                  description,
                     ..                  time_zone
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMCalendarName

Syntax:

<Identifier>


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