resourceskill

This defines what skills are linked to a resource. When determining what skills aresource has a union of the skills between resource skills and resource typeskills must be made.

Syntax:

[ DynamicComponentDependency ] resourceskill ResourceSkillName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
resource_id String(32) Specifies the unique id for the Resource.
skill_id String(32) Specifies the unique id for the Skill.

Optional columns

Column Name Data Type Description Default Value
proficiency Double Specifies the level of the resource's proficiency in the given skill. is normal speed; 0.5 is half as quick; 2 is twice as quick. A value of 0 is equivalent to the resource not having the skill. 


            resourceskill ResourceSkill {{SelectName}} {
               SELECT
                     ..                  resource_id,
                     ..                  skill_id,
                  -- optional columns
                     ..                  proficiency
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ResourceSkillName

Syntax:

<Identifier>

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