Table Description
Alert Workflow Data Object Snapshot Overflow : One element of a sequence that, when combined, form the Workflow Data Object snapshot for a Alert.

The Workflow Engine creates a Alert whenever a Notification is delivered. At the time that the Alert is created, the Workflow Engine takes a snapshot of any Workflow Data Object values that are used by the Notification (for example, used in the Notification Subject, or Notification Body). This snapshot is stored as XML data in the wdoSnapshot attribute of the Alert entity. If the XML string exceeds 3900 characters, it is broken up into a sequence of strings, each with a maximum length of 3900 characters. These strings are then stored as overflow records.

When the Workflow Engine attempts to reconstruct the Alerts wdoSnapshot, it reads the wdoSnapshot from the Alert record and appends any associated overflow records.

Example

A workflow (Process Definition) is defined to inform the case supervisor whenever a customers payment details have been modified and send a letter to the customer. The activities defined in your workflow are:

  • notification sent to case supervisor and letter printed.

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.

The system creates and executes the first (automatic) Activity Instance which prints out the letter and sends a notification to the case supervisor. The alert informs the case supervisor that the customer's details have been modified.

Technical Notes

See the Workflow Reference Guide for further information.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::Alert::Entity::Alert::AlertWDOOverflow
Controlling File: core\model\Packages\Reference Model\Service Layer\Alert\Alert_cat.efx
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
alertIDkeynoThe unique reference number for the alert record which the WDO snapshot corresponds to.ALERT_ID SVR_INT64
sequenceNokeynoThe sequence number used when compiling WDO snapshot data from the overflow table.WDO_OVERFLOW_PART_SEQ_NUM SVR_INT32
wdoSnapshotdetails The XML string representing the WDO attributes and their values associated with this WDO.WDO_SNAPSHOT_STRING SVR_STRING<3900>
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsert Inserts a workflow data object snapshot overflow entry for the specified alert. 
getWDOSnapshotnsreadmultiORDER_BY: sequenceNo
Returns the WDO snapshot data stored on this table for the alert specified by the given identifier. 
removeAllEntriesForAlertnsremove Removes all entries for the specified alert. 
Related Pages (5)