ramrota

A mapping of shifts to resources, and people to teams, for a period of time.

Syntax:

[ DynamicComponentDependency ] ramrota RAMRotaName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name	Data Type	Description	Default Value
id	String(32)	A unique id.
ram_rota_type_id	String(32)	The type of this rota.

Optional columns

Column Name	Data Type	Description	Default Value
modified	Number (0 = False, 1 = True)	Shows whether modifications have been made to a working rota since the last save.	False
auto_generation_complete	Number (0 = False, 1 = True)	If the rota is auto generated, this indicates if the generation is complete.
description	String(2000)	A description for this rota.
end_datetime	Date	The end of the period covered by the rota.
last_retrieved_update_id	Number	The id of the last retrieved update from the master rota (for WORKINGSET rotas only)
ram_rota_id	String(32)	The parent rota.
start_datetime	Date	The start of the period covered by this rota.
user_id	String(256)	The user this rota belongs to.



            ramrota RAMRota {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  ram_rota_type_id,
                  -- optional columns
                     ..                  modified,
                     ..                  auto_generation_complete,
                     ..                  description,
                     ..                  end_datetime,
                     ..                  last_retrieved_update_id,
                     ..                  ram_rota_id,
                     ..                  start_datetime,
                     ..                  user_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMRotaName

Syntax:

<Identifier>

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