WF_PROC_TRACKINGS

Tracks how a process instance moves from one step to the next.

Columns

Column Name Definition

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

DATE_OCCURRENCE
Function:
The date the action occurred.
Data Type:
datetime
Size:
8
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

EVENT_NAME
Function:
The name of the event that describes the action of the connector — for example, Promote.
Data Type:
nvarchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

FROM_ID
Function:
The activity instance ID for the source activity. This is the activity at the start of a connector.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
  • WF_ACTIVITY_INSTS - n:1

LINK_NAME
Function:
The display name for the connector in the process model.
Data Type:
nvarchar
Size:
128
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

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

SENDER
Function:
The user name of the person who performed the action — for example, pearl\administrator.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

TO_ID
Function:
The activity instance ID for the link target. This is the activity at the end of a connector.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
  • WF_ACTIVITY_INSTS - n:1

Relationships

Table Name Relationship
WF_PROC_INSTS n:1
WF_ACTIVITY_INSTS n:n