Table Description
Alert: A piece of information that may be of interest to a User or a set of users. It is not a request for action by the User and therefore there is no action or work to be managed or monitored by a supervisor.

The Workflow Engine creates an Alert whenever a notification associated to an Activity Instance is executed. At the time that the notification is created:

  • an allocation strategy is executed to determine the agent which will receive the Alert.

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 Guide for further information.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::Alert::Entity::Alert::Alert
Controlling File: core\model\Packages\Reference Model\Service Layer\Alert\Alert_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
alertIDkeynoThe unique reference number assigned by the system to an alert record.ALERT_ID SVR_INT64
categorydetails The category of the alert.ACTIVITY_CATEGORY_CODEActivityCategorySVR_STRING<10>
dateCreateddetails The date and time when the alert was created.CURAM_DATETIME SVR_DATETIME
userNamedetailsyesThe name of the user that the alert is sent to.USER_NAME SVR_STRING<64>
recordStatusdetails The status of the alert record (e.g. active or canceled). It should be noted that this field is not currently used in the application as when an alert record is deleted, it is physically removed from the Alert table (and not logically deleted using the details of this field).RECORD_STATUS_CODERecordStatusSVR_STRING<10>
wdoSnapshotdetails An XML string containing the parameters to the subject and body of the alert.WDO_SNAPSHOT_STRING SVR_STRING<3900>
processIDdetails The unique identifier of a workflow process definition containing the activity that was executed to create the alert.PROCESS_ID SVR_INT64
processActivityIDdetails The unique identifier of the workflow process activity that was executed to create the alert.PROCESS_ACTIVITY_ID SVR_INT64
processVersiondetails The version of a workflow process definition containing the activity that was executed to create the alert.PROCESS_VERSION SVR_INT32
processInstanceIDdetails The unique identifier of the process instance associated with the alert.PROCESS_INSTANCE_ID SVR_INT64
overflowInddetails A boolean flag indicating whether or not WDO snapshot data overflows on to the alert WDO overflow table.WDO_OVERFLOW_IND SVR_BOOLEAN
notificationTypedetailsnoThe type of the notification.NOTIFICATION_TYPE SVR_STRING<10>
notificationIDdetails The identifier of the notification.NOTIFICATION_ID SVR_INT64
Foreign Keys (2)
ChildParent
Alert.processInstanceIDProcessInstance.processInstanceID
Alert.userNameUsers.userName
Indices (1)
Index NameAttributes
AlertUserNameIdxuserName
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertPOST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
Method to insert an alert. 
readreadPOST_DATA_ACCESS: yes
Method to return alerts. 
modifymodifyPRE_DATA_ACCESS: yes
Standard Operation 
removeremovePRE_DATA_ACCESS: yes
Method to remove an alert. 
readmultireadmulti   
searchByUserNamensmultiPOST_DATA_ACCESS: yes
READMULTI_INFORMATIONAL: yes
 		Method to return all alerts.SQL
readOverflowIndnsread Returns the overflowInd for the specified alert. 
readProcessInstanceAndActivityIdsnsread Returns the process instance and process activity unique identifiers for the specified alert. 
countByUserNamens Method to count all alerts for the user. see {@link searchByUserName} and {@link searchByUserNameMostRecentFirst} for the equivalent search methods.SQL
Related Pages (6)