scheduleexceptresponse

This records that an exception has been acknowledged and can be removed from thelist of outstanding exceptions.

Syntax:

[ DynamicComponentDependency ] scheduleexceptresponse ScheduleExceptResponseName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name	Data Type	Description	Default Value
schedule_exception_id	String(32)	Specifies the id of the schedule exception this response is for.
plan_id	Number	Specifies the plan to which the exception response relates.

Optional columns

Column Name	Data Type	Description	Default Value
sequence	Number	A sequence number for this response.	1
acknowledge_expiry_datetime	Date	Specifies the time at which the acknowledgement of the exception should no longer be considered active.
acknowledged	Number (0 = False, 1 = True)	Indicates that the exception is acknowledged.
acknowledgement_comment	String(2000)	Provides the comment recorded against an acknowledgement.
acknowledgement_datetime	Date	Specifies the date and time the acknowledgement was made.
acknowledgement_user_id	String(256)	Specifies the id of the user who acknowledged the exception.
activity_id	String(32)	Defines the activity to which the exception response applies.
resource_id	String(32)	Defines the resource to which the exception response applies.
schedule_exception_type_id	Number	Specifies the type of the exception the response is for.



            scheduleexceptresponse ScheduleExceptResponse {{SelectName}} {
               SELECT
                     ..                  schedule_exception_id,
                     ..                  plan_id,
                  -- optional columns
                     ..                  sequence,
                     ..                  acknowledge_expiry_datetime,
                     ..                  acknowledged,
                     ..                  acknowledgement_comment,
                     ..                  acknowledgement_datetime,
                     ..                  acknowledgement_user_id,
                     ..                  activity_id,
                     ..                  resource_id,
                     ..                  schedule_exception_type_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ScheduleExceptResponseName

Syntax:

<Identifier>

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