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 varchar32 (Primary key) The unique item ID.
EVENT_NAMEvarchar32

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.

STATUSnvarchar16
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_IDvarchar32 (Foreign key to WF_PROC_INSTS table) The process instance ID.
SENDER nvarchar64 Represents the person who sent the item.
SENT_DATE datetime8 The date the event was sent.
END_DATEdatetime8 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