targetlevel

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 ] targetlevel TargetLevelName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Specifies the unique identifier for this Target Level
alert_level_id String(32) Defines whether this Target Level is the threshold for an error or warning. Permitted values are: 'ERROR', 'WARNING' or 'OK'.
benefit Double Specifies 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.
target_id String(32) Specifies the identifier of the Target to which this Target Level belongs.

Optional columns

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


            targetlevel TargetLevel {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  alert_level_id,
                     ..                  benefit,
                     ..                  benefit_type,
                     ..                  target_id,
                  -- optional columns
                     ..                  range_end,
                     ..                  range_start
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

TargetLevelName

Syntax:

<Identifier>

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