activitytype

Describes a type of activity. Many different types of activities may be scheduled andfrom an operational process perspective it is useful to know what type the differentactivities are. At least 1 activity type must be loaded into the DSE. Thedefault will be a type of 'Default'.

Syntax:

[ DynamicComponentDependency ] activitytype ActivityTypeName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] [ UrlPropertySetting ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Defines a unique id for the activity type.

Optional columns

Column Name Data Type Description Default Value
base_value Double Defines the basic marginal value of scheduling this activity compared to not scheduling it. 1000
cost_of_split Double Defines the default cost incurred each time an activity of this type is split. 0
interrupt Number (0 = False, 1 = True) Defines whether activities of this type are allowed to be used to interrupt a splittable activity. False
min_split Number (minutes by default) Defines the minimum on site duration for any visit to a split activity of this type. 01:00:00
priority Number Defines the priority of activities of this type. The greater the number the greater the priority. 1
split_allowed Number (0 = False, 1 = True) Defines whether activities of this type are allowed to be split. False
auto_duration Number (minutes by default) Defines the estimated duration of activities of this type, as determined automatically using the Schedule Archive.
auto_duration_enabled Number (0 = False, 1 = True) Defines whether an auto_duration should be used for this activity type.
calendar_id String(32) Defines the id of the calendar to use when applying SLA times to activities of this type.
colour String(9) Used for display purposes.
contract_id String(32) Specifies the id of the contract that this activity type relates to.
customer String(100) Specifies the customer that this activity type relates to.
description String(2000) Provides a description for this activity type.
do_on_location_incentive Double Specifies how activities at the same location should be scheduled.
duration Number (minutes by default) Defines the standard duration of an activity of this type.
ignore_days_old Number Do not pass activities to the scheduler where the number of days exceeds Activity. date_time_open date.
interrupt_multiplier Double Defines a multiplier that is applied to the cost_of_split of a splittable activity when interrupted by an activity of this type.
interrupt_priority Number Specifies the priority of an activity of this type when considering whether to use it to interrupt a splittable activity. This is compared to the split_minimum_priority on the splittable activity.
maximum_displaceable_priority Number When appointment booking for activities of this type, the engine will attempt to displace any other activities of this priority or less.
reactive Number (0 = False, 1 = True) Used in conjunction with the Schedule Distribution Service to indicate if the activity is reactive.
separation_group_id String(32) Specifies the id of the separation group activities of this type belong to.
service_level String(100) Used for information and reporting only. Has no impact on scheduling.
split_minimum_priority Number Defines the minimum split priority required for an activity of this type to be split into a shift, and the minimum interrupt priority required for another activity to be able to interrupt an activity of this type.
time_zone String(32) Specifies the id of the time zone related to this activity type. 


            activitytype ActivityType {{SelectName}} {
               SELECT
                     ..                  id,
                  -- optional columns
                     ..                  base_value,
                     ..                  cost_of_split,
                     ..                  interrupt,
                     ..                  min_split,
                     ..                  priority,
                     ..                  split_allowed,
                     ..                  auto_duration,
                     ..                  auto_duration_enabled,
                     ..                  calendar_id,
                     ..                  colour,
                     ..                  contract_id,
                     ..                  customer,
                     ..                  description,
                     ..                  do_on_location_incentive,
                     ..                  duration,
                     ..                  ignore_days_old,
                     ..                  interrupt_multiplier,
                     ..                  interrupt_priority,
                     ..                  maximum_displaceable_priority,
                     ..                  reactive,
                     ..                  separation_group_id,
                     ..                  service_level,
                     ..                  split_minimum_priority,
                     ..                  time_zone
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ActivityTypeName

Syntax:

<Identifier>

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