ramactivitytype

Defines a type used to group activities together that share scheduling specific information.

Syntax:

[ DynamicComponentDependency ] ramactivitytype RAMActivityTypeName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique id.

Optional columns

Column Name Data Type Description Default Value
base_value Double The base value of activities of this type. 1000
cost_of_split Double See Activity_Type in Scheduling Schema 0
duration Number (minutes by default) The default duration to use for activities of this type. 01:00:00
interrupt Number (0 = False, 1 = True) See Activity_Type in Scheduling Schema False
minimum_split Number (minutes by default) See Activity_Type in Scheduling Schema 01:00:00
priority Number See Activity_Type in Scheduling Schema 1
split_allowed Number (0 = False, 1 = True) See Activity_Type in Scheduling Schema False
supply_locations Number (0 = False, 1 = True) Determines whether the RPL needs to supply locations for activities using this activity type. False
auto_duration_enabled Number (0 = False, 1 = True) Determines if an auto_duration should be used for this activity.
colour String(9) See Activity_Type in Scheduling Schema
customer String(100) The customer that this activity type relates to.
description String(2000) A description for this type of activity.
do_on_location_incentive Double See Activity_Type in Scheduling Schema
ignore_days_old Number Defines when an activity should be ignored due to being too old.
interrupt_multiplier Double See Activity_Type in Scheduling Schema
interrupt_priority Number See Activity_Type in Scheduling Schema
maximum_displaceable_priority Number See Activity_Type in Scheduling Schema
ram_calendar_id String(32) The calendar which applies to the SLAs of activities of this type.
ram_contract_id String(32) The contract related to activities of this type.
ram_sla_template_id String(32) The SLA template to use for activities of this type.
reactive Number (0 = False, 1 = True) Used in conjunction with the DDS to indicate if the activity is reactive.
separation_group_id String(32) Specifies the id of the separation group that activities of this type belong to.
service_level String(100) The service level for the activity. Used for information and reporting only. Has no impact on scheduling.
split_minimum_priority Number See Activity_Type in Scheduling Schema 


            ramactivitytype RAMActivityType {{SelectName}} {
               SELECT
                     ..                  id,
                  -- optional columns
                     ..                  base_value,
                     ..                  cost_of_split,
                     ..                  duration,
                     ..                  interrupt,
                     ..                  minimum_split,
                     ..                  priority,
                     ..                  split_allowed,
                     ..                  supply_locations,
                     ..                  auto_duration_enabled,
                     ..                  colour,
                     ..                  customer,
                     ..                  description,
                     ..                  do_on_location_incentive,
                     ..                  ignore_days_old,
                     ..                  interrupt_multiplier,
                     ..                  interrupt_priority,
                     ..                  maximum_displaceable_priority,
                     ..                  ram_calendar_id,
                     ..                  ram_contract_id,
                     ..                  ram_sla_template_id,
                     ..                  reactive,
                     ..                  separation_group_id,
                     ..                  service_level,
                     ..                  split_minimum_priority
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMActivityTypeName

Syntax:

<Identifier>

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