appointmenttemplate

This enables a pattern of requests to be defined for appointments. The system will automatically create these appointment requestsinternally over the scheduling window.

Syntax:

[ DynamicComponentDependency ] appointmenttemplate AppointmentTemplateName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Defines a unique id for the appointment template.
day_pattern String(7) Specifies the days on which slots should be requested.
number_of_slots Number Defines the maximum number of appointment slots to return.
offer_expiry_window Number (minutes by default) Defines the length of time from the request_datetime on the appointment request after which offers will be expired.

Optional columns

Column Name Data Type Description Default Value
blocking Number (0 = False, 1 = True) Requests that the appointment offer time slots be blocked out to prevent concurrent appointment requests from using them. True
default_template Number (0 = False, 1 = True) Indicates whether this template should be used as the default template on the appointment booking client. False
exclude_to_template_start Number (0 = False, 1 = True) Indicates whether appointment slots should only be offered from the next start point of the template. False
appointment_window_length Number (minutes by default) Specifies the length of the slots that should be returned.
description String(2000) Describes this appointment template.
granularity Number (minutes by default) See granularity on Appointment_Request.
minimum_delay Number (minutes by default) Specifies the minimum amount of time after the current schedule time from which appointments should be offered.
slot_usage_rule_set_id String(32) The id of the slot usage rules that should be used with this template.
start_based Number (0 = False, 1 = True) Defines whether only the activity start time need be within the returned slot, or whether the the entire activity must be scheduled within the slot.
template_start_day_of_week Number Specifies the day of week from which the template should start, with 0=Monday.
template_start_time_of_day Number (minutes by default) Specifies the time of day from which the template should start.
time_zone String(32) Specifies the time zone to use when applying time of day attributes on Appointment Template and Appointment Template Item.
utilisation_multiplier Double Defines a multiplier for the maximum shift utilisation to limit the amount of time the offers consume in each shift. 


            appointmenttemplate AppointmentTemplate {{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 AppointmentTemplate.

AppointmentTemplateName

Syntax:

<Identifier>

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