WF_PROC_INSTS

Stores information about a process instance.

Columns

Column Name Definition

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

APPL_NAME
Function:
The name of the app associated with the process instance.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

COMPLETED_DATE
Function:
The date the process instance was completed.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

DEF_ID
Function:
The ID for the process model.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
  • WF_PROC_DEFS - n:1

DEF_NAME
Function:
The name of the process model.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

DUE_DATE
Function:
The date the process instance is due.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

EXECUTION_BEHAVIOR
Function:
Specifies whether an app is a process-based app or a form-based app.
Values:
  • 0 - Standard. A process-based app.
  • 1 - NotInstantiable. A form-based app.
  • 2 - Interactive. The process is interactive, which means it is event based.
Data Type:
Int
Size:
4
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_BY
Function:
The user who last updated, or modified, the process instance.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_DATE
Function:
The date the process instance was last modified.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_RUNNING_END_TIME
Function:
The date the process instance last stopped running.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_RUNNING_START_TIME
Function:
The date the process instance last started or resumed running.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_SWAP_DATE
Function:
The date the process instance was last swapped.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PROC_INITIATOR
Function:
The person who initiated the process instance.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PROC_INITIATOR_LOC
Function:
The location of the person who initiated the process instance.
Data Type:
nvarchar
Size:
64
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PROC_INST_NAME
Function:
The process instance name.
Data Type:
nvarchar
Size:
384
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

SOURCE_PROC_INST_ID
Function:
Used for process split and merge.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

STARTED_DATE
Function:
The date the process instance started.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

STATUS
Function:
The status of the process instance.
Values:
  • 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.
Data Type:
nvarchar
Size:
16
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

SUPER_PROC_INST_ID
Function:
The process instance ID for the parent process.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

TARGET_PROC_INST_ID
Function:
Used for process split and merge.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

TOPLEVEL_PROC_INST_ID
Function:
The process instance ID for a parent process.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

VERSION
Function:
The version of the process model.
Data Type:
nvarchar
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

WORK_OBJECT_ID
Function:
The Work Object ID associated with the process instance.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

WORK_OBJECT_INFO
Function:
Information about the task from which a process instance has been initiated. It is used mostly for SharePoint-based tasks — for example, a list URLs.
Data Type:
nvarchar
Size:
1024
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

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