Defines a template of slots to consider when requesting appointments. Maps to Appointment_Template in Scheduling Schema.
Syntax:
[ DynamicComponentDependency ] ramappointmenttemplate RAMAppointmentTemplateName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | The id of the appointment template. | |
day_pattern | String(7) | See Appointment_Template in Scheduling Schema | |
number_of_slots | Number | See Appointment_Template in Scheduling Schema | |
offer_expiry_window | Number (minutes by default) | See Appointment_Template in Scheduling Schema |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
blocking | Number (0 = False, 1 = True) | See Appointment_Template in Scheduling Schema | True |
default_template | Number (0 = False, 1 = True) | See Appointment_Template in Scheduling Schema | False |
exclude_to_template_start | Number (0 = False, 1 = True) | See Appointment_Template in Scheduling Schema | False |
appointment_window_length | Number (minutes by default) | See Appointment_Template in Scheduling Schema | |
description | String(2000) | See Appointment_Template in Scheduling Schema | |
granularity | Number (minutes by default) | See Appointment_Template in Scheduling Schema | |
minimum_delay | Number (minutes by default) | See Appointment_Template in Scheduling Schema | |
slot_usage_rule_set_id | String(32) | See Appointment_Template in Scheduling Schema | |
start_based | Number (0 = False, 1 = True) | See Appointment_Template in Scheduling Schema | |
template_start_day_of_week | Number | See Appointment_Template in Scheduling Schema | |
template_start_time_of_day | Number (minutes by default) | See Appointment_Template in Scheduling Schema | |
time_zone | String(32) | See Appointment_Template in Scheduling Schema | |
utilisation_multiplier | Double | A multiplier for the maximum shift utilisation to limit the amount of time the offers consume in each shift. |
ramappointmenttemplate RAMAppointmentTemplate {{SelectName}} { SELECT .. id, .. day_pattern, .. number_of_slots, .. offer_expiry_window, -- optional columns .. blocking, .. default_template, .. exclude_to_template_start, .. appointment_window_length, .. description, .. granularity, .. minimum_delay, .. slot_usage_rule_set_id, .. start_based, .. template_start_day_of_week, .. template_start_time_of_day, .. time_zone, .. utilisation_multiplier FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMAppointmentTemplate.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.