activitystatus

This is used to assign a particular activity status to an activity after its initial load. As an activity goes through its life cycle the status needs to be updated. An Activity must always have at least one Activity Status. When an Activity is created and it is unallocated then the Activity Status should be created as unallocated. If a resource is allocated then the appropriate status is used and resource id applied. Should activity duration change then the Activity Status will be updated.

Syntax:

[ DynamicComponentDependency ] activitystatus ActivityStatusName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
activity_id String(32) Specifies the id of the activity this relates to.
date_time_status Date Defines the date and time the status took effect in the real world.
date_time_stamp Date Defines the date and time at which the record was created

Optional columns

Column Name Data Type Description Default Value
status_id Number Describes the current status of activity. 0
visit_id Number Defines the visit the status change relates too. 1
fixed Number (0 = False, 1 = True) Defines whether the resource is to be fixed to this activity False
commit_sort_date_time Date The time at which the activity is intended to start.
commit_sort_value Double Defines the committed status order of activities.
date_time_earliest Date Defines the earliest time a committed activity can be done.
date_time_fixed Date Specifies the date and time the activity is fixed to start at.
duration Number (minutes by default) Defines the current duration of the Activity
expected_arrival_time Date Sets the expected arrival time for an activity.
highlight String(100) Defines whether the activity should be highlighted in the exception window on the Scheduling Workbench. Text used in this field will be displayed.
memo String(2000) Provides general information about the activity and this status to be displayed.
reason String(200) Provides details about manual allocation.
reason_value String(40) Specifies the Entry.value used as the reason.
resource_id String(32) Defines the resource allocated to the activity for this status.
source Number Provides details about where the change to the status originated from. 


            activitystatus ActivityStatus {{SelectName}} {
               SELECT
                     ..                  activity_id,
                     ..                  date_time_status,
                     ..                  date_time_stamp,
                  -- optional columns
                     ..                  status_id,
                     ..                  visit_id,
                     ..                  fixed,
                     ..                  commit_sort_date_time,
                     ..                  commit_sort_value,
                     ..                  date_time_earliest,
                     ..                  date_time_fixed,
                     ..                  duration,
                     ..                  expected_arrival_time,
                     ..                  highlight,
                     ..                  memo,
                     ..                  reason,
                     ..                  reason_value,
                     ..                  resource_id,
                     ..                  source
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ActivityStatusName

Syntax:

<Identifier>

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