availability

This is used to record periods of time when either activities, activity types,locations and location types have access or are available for use in scheduling.In many cases locations and activities will have the same availability times and in this case the availabilities can be recorded against the activity type or location type. This is also used to define slots of availability for Appointment Request.

Syntax:

[ DynamicComponentDependency ] availability AvailabilityName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Defines a unique id for the availability.
datetime_end Date Specifies end of availability period.
datetime_start Date Specifies start of availability period.

Optional columns

Column Name Data Type Description Default Value
activity_id String(32) Defines the id of the activity this relates to.
activity_type_id String(32) Defines the id of the activity type this relates to.
appointment_request_id String(32) Appointment offer id
availability_type String(32) Defines the type of availability.
available Number (0 = False, 1 = True) Defines whether the the period between the specified times is to be treated as available.
location_id String(32) Defines the id of the location this relates to.
location_type_id String(32) Defines the id of the location type this relates to.
start_based Number (0 = False, 1 = True) Enforce availability against start time of activity or total duration of activity. 


            availability Availability {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  datetime_end,
                     ..                  datetime_start,
                  -- optional columns
                     ..                  activity_id,
                     ..                  activity_type_id,
                     ..                  appointment_request_id,
                     ..                  availability_type,
                     ..                  available,
                     ..                  location_id,
                     ..                  location_type_id,
                     ..                  start_based
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

AvailabilityName

Syntax:

<Identifier>

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