Defines an amount of time or number of resources required for a project tempate and an associated alert level.
Syntax:
[ DynamicComponentDependency ] ramprojecttemplatelevel RAMProjectTemplateLevelName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | A unique id. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
description | String(100) | A description of the project level. | |
from_hours_required | Double | The minimum number of hours required for the project to be at this level. | |
from_resource_count | Number | The minimum number of resources required for the project to be at this level. | |
ram_alert_level_id | String(32) | The id of the alert level associated with this project level. | |
ram_project_template_id | String(32) | The project template id. |
ramprojecttemplatelevel RAMProjectTemplateLevel {{SelectName}} { SELECT .. id, -- optional columns .. description, .. from_hours_required, .. from_resource_count, .. ram_alert_level_id, .. ram_project_template_id FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMProjectTemplateLevel.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.