WF_EVENTS

Stores information about events and their statuses.

Columns

Column Name Definition

EVENT_ID
Function:
The unique ID for the event.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
Yes
Foreign Key:
No

END_DATE
Function:
The date the event ended.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

EVENT_NAME
Function:
The name of the event.
Values:
  • CreateProcessInstance - Creates the process instance.
  • StartProcessInstance - Starts the process instance (Changes the status of the process instance from Initiated to Running).
  • PromoteProcessInstance - Moves the process instance forward.
  • CancelProcessInstance - Cancels the process instance.
  • TerminateProcessInstance - Cleans up the process instance from memory.
  • SuspendProcessInstance - Suspends the process instance.
  • ResumeProcessInstance - Resumes the suspended process instance.
  • RollbackProcessInstance - Rolls back or forward the process instance.
  • RollbackActivityInstance - Resets the activity instance.
  • CompleteWorkItem - Marks the task as completed.
  • AssignWorkItem - Assigns the task to you from a pool (from New to Assigned).
  • UndoAssignWorkItem - Releases the assigned task for another user into the pool.
  • CancelWorkItem - Cancels the task.
  • ReassignWorkItem - Reassigns the task to other participant.
  • CreateWorkItem - Creates a task.
  • CompleteProcedure - Marks an automatic work item completed.
  • CancelProcedure - Cancels an automatic work item.
  • MigrateProcessInstance - Migrates the process instance to a different version.
  • SplitProcessInstance - Splits the process instance into two.
  • MergeProcessInstance - Merges the process instance.
  • CreateProcessDefinition - Creates a process model.
  • CheckinProcessDefinition - Saves all changes made to the process model since the last check in.
  • CheckoutProcessDefinition - Checks out the process model.
  • UndoCheckoutProcessDefinition - Reverts the changes made to the process model.
  • ReleaseProcessDefinition - Publishes the process model.
  • DeleteProcessDefinition - Deletes the process model.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

PARAMS_XML

Function:
The XML string that contains parameters about the event, such as WORKITEMID, ActivityInstID, or UserID.
Values:
An XML string that is based on the event.
Data Type:
ntext
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PROC_INST_ID
Function:
The process instance ID associated with the event.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
  • WF_PROC_INSTS - n:1

SENDER
Function:
The person who sent the event.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

SENT_DATE
Function:
The date the event was sent.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

STATUS
Function:
The status of the event.
Values:
  • Sent - The event was sent to AgilePoint Server for processing.
  • Failed - The event failed to process.
  • Processed - The event processed successfully.
  • Cancelled - The event was cancelled.
  • Deferred - The event does not need to be sent immediately.
Data Type:
nvarchar
Size:
16
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
WF_PROC_INSTS n:1