WF_ACTIVITY_INSTS

Stores information about the activity instances.

Columns

Column Name Definition

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

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

DISPLAY_NAME
Function:
The display name for the activity instance.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

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

IN_STACK
Function:
The execution status of the item.
Values:
  • Yes - The item is executed.
  • No - The item is not executed, or it can be executed again.
Data Type:
varchar
Size:
3
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

NAME
Function:
The unique name of the activity, used for internal reference.
Data Type:
nvarchar
Size:
64
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

PENDING
Function:
Indicates whether the activity instance is pending.
Values:
  • Yes - The execution of the activity is pending.
  • No - The execution of the activity is completed.
Data Type:
varchar
Size:
3
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

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

SESSION_
Function:
The number of times the activity instance has been completed or attempted.
Data Type:
Int
Size:
4
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

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

TOKEN_POS
Function:
The status of the activity instance in terms of position.
Values:
  • 0 - NONE. The activity has not been entered.
  • 1 - ENTRY. The process has entered the activity.
  • 2 - EXIT. The process has exited after completing the activity.
  • 3 - EXECUTION. The activity is currently executing.
Data Type:
Int
Size:
4
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

TOKENS
Function:
The number of incoming ports that have arrived.
Data Type:
Int
Size:
4
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_PROC_TRACKINGS 1:n
WF_MAIL_DELIVERABLES 1:n