ramshifttempmembership

This defines the membership categories to use at different times during a shift template.

Syntax:

[ DynamicComponentDependency ] ramshifttempmembership RAMShiftTempMembershipName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
ram_shift_template_id String(32) The id of the shift template this relates to.
sequence Number Used for ordering purposes.
day_increment Number The number of days into the shift template from which this category applies.
time_increment Number (minutes by default) The time into the shift template from which this category applies.

Optional columns

Column Name Data Type Description Default Value
ram_membership_category_id String(32) The membership category the applies at this time. 


            ramshifttempmembership RAMShiftTempMembership {{SelectName}} {
               SELECT
                     ..                  ram_shift_template_id,
                     ..                  sequence,
                     ..                  day_increment,
                     ..                  time_increment,
                  -- optional columns
                     ..                  ram_membership_category_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMShiftTempMembershipName

Syntax:

<Identifier>

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