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). An example would be 'ensure that the SLA Hit Rate for Plumbing activities is greater than 95%'. The actual level of the Target is set using Target Levels; whilst the applicability of the Target is determined by any Target Focus rows which are linked to the Target.
Syntax:
[ DynamicComponentDependency ] ramtarget RAMTargetName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | The identifier of this RAM_Target | |
statistic_type_id | Number | The statistic type of this RAM_Target. Statistic Types are defined in the System database. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
description | String(2000) | An optional description of this RAM_Target |
ramtarget RAMTarget {{SelectName}} { SELECT .. id, .. statistic_type_id, -- optional columns .. description FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMTarget.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.