ramproject

Defines known projects that resources are required to work on

Syntax:

[ DynamicComponentDependency ] ramproject RAMProjectName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique id.

Optional columns

Column Name Data Type Description Default Value
description String(2000) A description for this project.
exclusive_resource Number (0 = False, 1 = True) Whether the project requires a single resource to work on all child projects (SCHEME only)
maximum_elapsed_time Number (minutes by default) The maximum time the project is allowed to take.
ram_division_id String(32) What division is the project in.
ram_parent_project_id String(32) The parent project (parent projects must be of type SCHEME).
ram_project_template_id String(32) The project template this project was generated from.
ram_project_type_id String(32) The type of project, one of [FLEXIBLE, FIXED, SCHEME].
ram_role_id String(32) The role that this project requires
ram_time_pattern_id String(32) The available times for the project (for fixed projects this defines the time the project must happen) 


            ramproject RAMProject {{SelectName}} {
               SELECT
                     ..                  id,
                  -- optional columns
                     ..                  description,
                     ..                  exclusive_resource,
                     ..                  maximum_elapsed_time,
                     ..                  ram_division_id,
                     ..                  ram_parent_project_id,
                     ..                  ram_project_template_id,
                     ..                  ram_project_type_id,
                     ..                  ram_role_id,
                     ..                  ram_time_pattern_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling RAMProject.

RAMProjectName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:49.