additionalattribute

This is used to hold additional attributes that are not used in the scheduling but need to be displayed within the schedulingsoftware to provide additional end user information. Additional attributescan be added for either activities, resources or locations. Additional_Attribute should be used in preference to Additional_Attributes since this gives the external system a higher degree of control over the additional attributes.This attribute should be used moderately.

Syntax:

[ DynamicComponentDependency ] additionalattribute AdditionalAttributeName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Defines a unique id for the attribute.
data_type String(10) Specifies the data type to be used for sorting and filtering.
label String(100) Defines a label descriptor to be shown next to value.
sequence Number Defines the sequence in which the labels and values should appear on the screen or be processed.

Optional columns

Column Name Data Type Description Default Value
activity_id String(32) Specifies the id of the activity this relates to.
domain_type_id String(32) Defines the id of the domain of values to be used for validating input into this additional attribute.
label_value String(2000) Specifies the value of the attribute.
location_id String(32) Specifies the id of the location this relates to.
resource_id String(32) Specifies the id of the resource this relates to. 


            additionalattribute AdditionalAttribute {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  data_type,
                     ..                  label,
                     ..                  sequence,
                  -- optional columns
                     ..                  activity_id,
                     ..                  domain_type_id,
                     ..                  label_value,
                     ..                  location_id,
                     ..                  resource_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

AdditionalAttributeName

Syntax:

<Identifier>

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