WF_EVENTS

Description

This table keeps tracks of individual events and statuses.

Columns

For the descriptions in this table, the term item refers to an event.

Column Name Data Type Size Description
EVENT_ID varchar 32 (Primary key) The unique item ID.
EVENT_NAME varchar 32

The name of the event.

CreateProcessInstance: Create process instance.

StartProcessInstance: Start process instance ( status of process instance from 'Initiated' to 'Running'.

PromoteProcessInstance: Move process instance forward.

CancelProcessInstance: Cancel process instance.

TerminateProcessInstance: Clean up process instance from memory.

SuspendProcessInstance: Suspend process instance.

ResumeProcessInstance: Resume suspended process instance.

RollbackProcessInstance: Rollback or forward process instance.

RollbackActivityInstance: Reset activity instance.

CompleteWorkItem: Mark work item completed.

AssignWorkItem: Take assignment of a work item in a pool (from 'New' to 'Assigned').

UndoAssignWorkItem: Put work item back into the pool.

CancelWorkItem: Cancel work item.

ReassignWorkItem: Reassign work item to other participant.

CreateWorkItem: Create work item.

CompleteProcedure: Mark an automatic work item completed.

CancelProcedure: Cancel an automatic work item.
STATUS nvarchar 16
The status of the event.
  • Sent - Indicates event has been sent to engine for processing.
  • Failed - Indicates event failed to process.
  • Processed - Indicates event has been processed successfully.
  • Canceled - Indicates event was canceled.
  • Deferred - Indicates event does not need to be sent immediately.
PROC_INST_ID varchar 32 (Foreign key to WF_PROC_INSTS table) The process instance ID.
SENDER nvarchar 64 Represents the person who sent the item.
SENT_DATE datetime 8 The date the event was sent.
END_DATE datetime 8 The date the item ends.
PARAMS_XML ntext The XML string that contains parameters about the event such as: WORKITEMID, ActivityInstID, UserID, etc.

Relationships

Table Name Relationship
WF_PROC_INSTS n – 1