ramtargetfocus

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 Focus defines a filterwhich constrains the applicability of the Target. If there are several Target Focus entries for a Target, then they must all be satisfied in order for the Target to be applicable.

Syntax:

[ DynamicComponentDependency ] ramtargetfocus RAMTargetFocusName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) The identifier of this RAM_Target_Focus
object_name String(32) Defines a table column to which the filter applies. For Activity_Type or Resource_Type, this must be 'id'; for Activity it may be 'customer' or 'service_level'.
ram_target_id String(32) The identifier of the RAM_Target to which this RAM_Target_Focus applies.
table_name String(40) Defines a data table to which the filter applies. This must be 'Activity', 'Activity_Type' or 'Resource_Type'.

Optional columns

Column Name Data Type Description Default Value
object_value String(100) The filter value to apply. 


            ramtargetfocus RAMTargetFocus {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  object_name,
                     ..                  ram_target_id,
                     ..                  table_name,
                  -- optional columns
                     ..                  object_value
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMTargetFocusName

Syntax:

<Identifier>

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