ramtempoperationusage

Defines the current usage of the specified class for this activity and operation.

Syntax:

[ DynamicComponentDependency ] ramtempoperationusage RAMTempOperationUsageName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
ram_activity_template_id String(32) The identifier of the activity template.
ram_operation_id String(32) The identifier of the operation.
ram_usage_class_id String(32) The identifier for the class of usage.
last_recorded_usage Double The last recorded usage (at the start of the scheduling period).

Optional columns

Column Name Data Type Description Default Value
last_recorded_usage_datetime Date The time of the last recorded usage 


            ramtempoperationusage RAMTempOperationUsage {{SelectName}} {
               SELECT
                     ..                  ram_activity_template_id,
                     ..                  ram_operation_id,
                     ..                  ram_usage_class_id,
                     ..                  last_recorded_usage,
                  -- optional columns
                     ..                  last_recorded_usage_datetime
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMTempOperationUsageName

Syntax:

<Identifier>

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