Table Description
Suspended Activity: The activity instances that have been suspended as a result of the suspension of an associated Process Instance.

When a Workflow Process Instance is suspended, any currently executing activities are allowed to complete. New Activity Instances are created and immediately suspended.

This table stores the activity instance details for all currently suspended activities associated with a suspended workflow Process Instance .

Example

You define a workflow (Process Definition) to allow correspondence to be sent to customers whenever their payment details change. The activities defined in your workflow are:

  • system prints out a letter (automatic);
  • User puts the letter in an envelope and posts it (manual); and
  • 'End Process' (a necessary step to end the workflow which is mandated by the Process Definition Tool).

Person John Smith's payment details change due to an increase in rates. This increase raises an event which causes the Workflow Engine to enact your workflow and create a Process Instance. As soon as the Process Instance is started, administrator Ronan Rooney realizes that the printer is not working. He suspends the process before it executes the 'system prints out a letter' activity. A suspended activity record is added for this Activity Instance, and the Process Instance ceases to continue.

At a later time the problems with the printer are resolved and administrator Ronan Rooney resumes the Process Definition. All suspended activity records associated with the suspended Process Instance are read from this table and resumed.

Technical Notes

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Attributes (7)
AttributeKeyNullableDescriptionDDL Type
activityInstanceIDYesNoThe identifier of the activity instance.SVR_INT64
processInstanceIDYesNoThe identifier of the process instance.SVR_INT64
processID  The identifier of the process definition.SVR_INT64
processVersion  The process definition version.SVR_INT32
activityID  The identifier of the activity.SVR_INT64
iterationID  An Activity contained within a loop may have multiple instances (one for each iteration of the loop) - this ID allows them to be distinguished from one another.SVR_INT64
lastWritten   SVR_DATETIME
Foreign Keys (3)
ChildParent
SuspendedActivity.activityInstanceIDActivityInstance.activityInstanceID
SuspendedActivity.processInstanceIDProcessInstance.processInstanceID
SuspendedActivity.iterationIDIteration.iterationID
Indices (2)
Index NameAttributes
ProcInstIDIndexprocessInstanceID
IND_207986147iterationID
Related Pages (6)