appointmentrequest

This is used to record the need for an appointment request within the system.Each time an appointment is required for an activity a request is entered here with a unique id. A set of possible appointments are then returned by the scheduler and stored in Appointment Offer.

Syntax:

[ DynamicComponentDependency ] appointmentrequest AppointmentRequestName {
[ 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 request.
activity_id String(32) Defines the id of an activity for which an appointment is required.

Optional columns

Column Name Data Type Description Default Value
appointment_template_datetime Date Specifies the base date and time to use when applying the appointment template for this request.
appointment_template_duration Number (minutes by default) Defines the duration for which the appointment template should be applied.
appointment_template_id String(32) Defines the id of the appointment template to be used for this appointment request.
appointment_window_length Number (minutes by default) Defines the length of the appointment slot to be used.
blocking Number (0 = False, 1 = True) Requests that the appointment offer time slots be blocked out to prevent concurrent appointment requests from using them.
granularity Number (minutes by default) Used to specify that returned slots should be rounded to start and finish at granular times.
offer_expiry_datetime Date Specifies the date and time that any offers for the appointment request will expire.
request_datetime Date The time stamp for this request.
slot_usage_rule_set_id String(32) The id of the slot usage rules that should be used with this request.
utilisation_multiplier Double A multiplier for the maximum shift utilisation to limit the amount of time the offers consume in each shift. 


            appointmentrequest AppointmentRequest {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  activity_id,
                  -- optional columns
                     ..                  appointment_template_datetime,
                     ..                  appointment_template_duration,
                     ..                  appointment_template_id,
                     ..                  appointment_window_length,
                     ..                  blocking,
                     ..                  granularity,
                     ..                  offer_expiry_datetime,
                     ..                  request_datetime,
                     ..                  slot_usage_rule_set_id,
                     ..                  utilisation_multiplier
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

AppointmentRequestName

Syntax:

<Identifier>

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