ramunavailcategory

Defines various categories for why a resource may be unavailable, e.g. holiday, sickness.

Syntax:

[ DynamicComponentDependency ] ramunavailcategory RAMUnavailCategoryName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name	Data Type	Description	Default Value
id	String(32)	A unique id.
require_location	Number (0 = False, 1 = True)	If a location is required for unavailability periods in this category.

Optional columns

Column Name	Data Type	Description	Default Value
interrupt	Number (0 = False, 1 = True)	Determines if an unavailability in this category is allowed to interrupt a splittable activity.	False
colour	String(9)	The colour to use when displaying unavailability of this category
description	String(2000)	A description of this category.
duration_granularity	Number (minutes by default)	The blocks of time that this unavailability can be taken in (e.g. 1/2 day for holidays)
minimum_duration	Number (minutes by default)	The minimum amount of time an unavailability in this category may last for.



            ramunavailcategory RAMUnavailCategory {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  require_location,
                  -- optional columns
                     ..                  interrupt,
                     ..                  colour,
                     ..                  description,
                     ..                  duration_granularity,
                     ..                  minimum_duration
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMUnavailCategoryName

Syntax:

<Identifier>

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