A rule to validate rotas against.
Syntax:
[ DynamicComponentDependency ] ramrule RAMRuleName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | A unique id. | |
ram_rule_type_id | String(32) | The type of rule. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
global | Number (0 = False, 1 = True) | Should this rule be applied globally? | False |
description | String(2000) | A description for the rule. | |
ram_membership_category_id | String(32) | The membership category this rule applies to. | |
ram_shift_category_id | String(32) | The shift category this rule applies to. |
ramrule RAMRule {{SelectName}} { SELECT .. id, .. ram_rule_type_id, -- optional columns .. global, .. description, .. ram_membership_category_id, .. ram_shift_category_id FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMRule.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.