Limits the total amount of resource time that can be used during the slot available times, when making offers for an appointment request.
Syntax:
[ DynamicComponentDependency ] slotusagerule SlotUsageRuleName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
minimum_start_offset | Number (minutes by default) | The minimum offset from the current schedule time to the slot start time at which this rule will apply. | |
slot_usage_rule_set_id | String(32) | The id of the rule set that this rule relates to. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
maximum_utilisation | Double | The maximum utilisation permitted for offers made in this slot. | |
minimum_free_time | Number (minutes by default) | The minimum amount of free time required in order for offers to be made in this slot. |
slotusagerule SlotUsageRule {{SelectName}} { SELECT .. minimum_start_offset, .. slot_usage_rule_set_id, -- optional columns .. maximum_utilisation, .. minimum_free_time FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling SlotUsageRule.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.