resourcetypeskill

This defines what skills are linked to resource types. When determining what skillsa resource has a union of the skills between resource skills and resource type skillsshould be made.

Syntax:

[ DynamicComponentDependency ] resourcetypeskill ResourceTypeSkillName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

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

Optional columns

Column Name	Data Type	Description	Default Value
proficiency	Double	Defines the proficiency level of the resource type in the given skill. 1 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.



            resourcetypeskill ResourceTypeSkill {{SelectName}} {
               SELECT
                     ..                  resource_type_id,
                     ..                  skill_id,
                  -- optional columns
                     ..                  proficiency
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ResourceTypeSkillName

Syntax:

<Identifier>

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