ramtargetlevel

RAM_Targets generate Targets in the Scheduling database. Targets define business goals that may be used by the Target-Based Scheduling (TBS) product. Theyare also used internally by the What-If Scenario Explorer (WISE). A Target Level defines a range of values which are to be considered as an error or warning state.

Syntax:

[ DynamicComponentDependency ] ramtargetlevel RAMTargetLevelName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) The identifier of this RAM_Target_Level
benefit Double The benefit of increasing this statistic value by one. Note that statistics which are better when smaller, such as total travel distance, should have a negative value. It is advisable to have a larger value for error ranges than for warning ranges, so as to prioritise the avoidance of errors over the avoidance of warnings. By choosing different benefits for different targets, some targets can be made more important than others.
benefit_type String(32) This must always be 'ADD': which means total target benefits are added together.
ram_alert_level_id String(32) Defines whether this RAM_Target_Level is the threshold for an error or warning. Permitted values are: 'ERROR', 'WARNING' or 'OK'.
ram_target_id String(32) The identifier of the RAM_Target to which this RAM_Target_Level belongs.

Optional columns

Column Name Data Type Description Default Value
range_end Double The end of this range of values
range_start Double The start of this range of values 


            ramtargetlevel RAMTargetLevel {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  benefit,
                     ..                  benefit_type,
                     ..                  ram_alert_level_id,
                     ..                  ram_target_id,
                  -- optional columns
                     ..                  range_end,
                     ..                  range_start
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMTargetLevelName

Syntax:

<Identifier>

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