Used to specify a period of time that a resource has a particular skill.
Syntax:
[ DynamicComponentDependency ] ramresourceskillavail RAMResourceSkillAvailName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | Unique guid id | |
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 |
---|---|---|---|
ram_time_pattern_id | String(32) | The period or periods of time when the resource will have the skill. |
ramresourceskillavail RAMResourceSkillAvail {{SelectName}} { SELECT .. id, .. ram_resource_id, .. ram_skill_id, -- optional columns .. ram_time_pattern_id FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMResourceSkillAvail.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.