activityproductivetime

This defines periods of productive time for an activity, which are applied against incentives and rules.This is primarily intended for use with automated resource planning.

Syntax:

[ DynamicComponentDependency ] activityproductivetime ActivityProductiveTimeName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
activity_id String(32) Specifies the id of the activity this relates to.
productivity_category_id String(32) Specifies the category of productive time.
start_offset Number (minutes by default) Defines the offset from the visit start that this period of productive time begins.
duration Number (minutes by default) Defines the duration of the productive time. 


            activityproductivetime ActivityProductiveTime {{SelectName}} {
               SELECT
                     ..                  activity_id,
                     ..                  productivity_category_id,
                     ..                  start_offset,
                     ..                  duration
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ActivityProductiveTimeName

Syntax:

<Identifier>

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