WF_PROC_TRACKINGS

Description

This table keeps track of the history of how a process moves from one step to another.

Columns

For the descriptions in this table, the term item refers to an action.

Column Name Data Type Size Description
PROC_INST_IDvarchar32 (Foreign key to WF_PROC_INSTS table) The process instance ID.
FROM_ID varchar32 (Foreign key to WF_ACTIVITY_INSTS table) Represents the activity instance ID that the link is from.
TO_ID varchar32 (Foreign key to WF_ACTIVITY_INSTS table) Represents the activity instance ID that the link is to.
LINK_NAME nvarchar128 The display name specified to the link in the process template.
EVENT_NAMEnvarchar32 The name of the event that describes the action of the link, for example: Promote.
DATE_OCCURRENCE datetime8 Represents the date the action occurred.
SENDER nvarchar64 The user credential of the person who performed the action - e.g. pearl\administrator.

Relationships

Table Name Relationship
WF_PROC_INSTS n – 1
WF_ACTIVITY_INSTS n – n