This defines what skills are linked to a resource with a time dependency. Suchskills would typically be periods of certification to undertake a particular type ofwork. This can also be used for team resources where the individual resources within the team are subject to change.
Syntax:
[ DynamicComponentDependency ] resourceskillavail ResourceSkillAvailName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
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. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
availability_id | String(32) | Specifies the unique id for the Availability. | |
availability_pattern_id | String(32) | Specifies the unique id for the Availability Pattern. | |
proficiency | Double | If specified, this overrides the resource's proficiency in this skill during the defined period. |
resourceskillavail ResourceSkillAvail {{SelectName}} { SELECT .. resource_id, .. skill_id, -- optional columns .. availability_id, .. availability_pattern_id, .. proficiency FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling ResourceSkillAvail.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.