A particular role required within an overal requirement.
Syntax:
[ DynamicComponentDependency ] ramrequirementrole RAMRequirementRoleName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | A unique id. | |
ram_requirement_id | String(32) | The parent requirement object | |
ram_role_id | String(32) | The role required. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
all_resources | Number (0 = False, 1 = True) | Signifies that this role is required by every resource planned under this requirement. | False |
exclusive_resource | Number (0 = False, 1 = True) | If true, this resource fulfilling this requirement will not be considered for any other requirements | False |
ram_membership_category_id | String(32) | The membership category to which this requirement applies. | |
ram_time_pattern_id | String(32) | The period or periods of time this capacity applies to. | |
sequence | Number | Used for ordering capacities. |
ramrequirementrole RAMRequirementRole {{SelectName}} { SELECT .. id, .. ram_requirement_id, .. ram_role_id, -- optional columns .. all_resources, .. exclusive_resource, .. ram_membership_category_id, .. ram_time_pattern_id, .. sequence FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMRequirementRole.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.