Used to specify that a resource has a particular skill.
Syntax:
[ DynamicComponentDependency ] ramresourceskill RAMResourceSkillName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
ram_resource_id | String(32) | The resource this applies to. | |
ram_skill_id | String(32) | The skill this applies to. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
expiry_datetime | Date | A time after which the resource will no longer have the skill. | |
last_used_datetime | Date | The last time the resource used the skill - used in conjunction with Skill.max_unused_duration | |
proficiency | Double | The proficiency of the resource in this skill. |
ramresourceskill RAMResourceSkill {{SelectName}} { SELECT .. ram_resource_id, .. ram_skill_id, -- optional columns .. expiry_datetime, .. last_used_datetime, .. proficiency FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMResourceSkill.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.