WF_PROC_INSTS

Description

One of the main tables which contains information about the process instances.

Columns

For the descriptions in this table, the term item refers to a process instance.

Column Name Data Type Size Description
PROC_INST_ID varchar 32 (Primary key) The unique item ID.
PROC_INST_NAME nvarchar 384 The unique process instance name.
DEF_ID varchar 32 (Foreign key to WF_PROC_DEFS table) Represents the ID of the process definition (template).
DEF_NAME nvarchar 256 The name of the process definition.
VERSION nvarchar 16 The version of the process definition (template).
SUPER_PROC_INST_ID varchar 32 The process instance ID of the parent process.
STATUS nvarchar 16

The status of the process instance.

  • Initiated - The process instance has been initiated, but is not yet running.
  • Running - The process instance is active and running.
  • Suspended - The process instance is active, but it is paused, or suspended.
  • Cancelled - The process instance has been cancelled, and is no longer active.
  • Completed - The process instance is no longer active because it has been completed.
STARTED_DATE datetime 8 The date the item started.
DUE_DATE datetime 8 The date the item is due.
COMPLETED_DATE datetime 8 The date the item was completed.
WORK_OBJECT_ID nvarchar 256 The Work Object ID associated with the item.
LAST_SWAP_DATE datetime 8 The last time the process instance was swapped out to free up resources.
LAST_MODIFIED_DATE datetime 8 The date the item was last modified.
LAST_MODIFIED_BY nvarchar 64 The user who last updated, or modified, the item.
LAST_RUNNING_START_TIME datetime 8 The date for which the process instance last started/resumed running.
LAST_RUNNING_END_TIME datetime 8 The date for which the process instance last stopped running.
APPL_NAME nvarchar 256 The name of the application associated with the item.
PROC_INITIATOR nvarchar 64 The person who initiated the process instance.
PROC_INITIATOR_LOC nvarchar 64 The location/IP Address of the person who initiated the process instance.
WORK_OBJECT_INFO nvarchar 1024 Information about the work object for which a process instance has been initiated. It is used mostly for SharePoint based work objects (i.e. list URLs, etc.)
SOURCE_PROC_INST_ID varchar 32 Used for process split and merge.
TARGET_PROC_INST_ID varchar 32 Used for process split and merge.

Relationships

Table Name Relationship
WF_PROC_DEFS n – 1
WF_MANUAL_WORKITEMS 1 – n
WF_AUTO_WORKITEMS 1 – n
WF_EVENTS 1 – n
WF_ACTIVITY_INSTS 1 – n
WF_PROC_TRACKINGS 1 – n
WF_MAIL_DELIVERABLES 1 – n