activityoperationusage

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

Syntax:

[ DynamicComponentDependency ] activityoperationusage ActivityOperationUsageName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
activity_id String(32) The identifier of the (repeatable) activity.
operation_id String(32) The identifier of the operation.
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 


            activityoperationusage ActivityOperationUsage {{SelectName}} {
               SELECT
                     ..                  activity_id,
                     ..                  operation_id,
                     ..                  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 ActivityOperationUsage.

ActivityOperationUsageName

Syntax:

<Identifier>

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