WF_DELEGATIONS

Description

Contains information about the delegation rules.

Columns

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

Column Name	Data Type	Size	Description
DELEGATION_ID	varchar	32	(Primary key) The unique item ID.
FROM_USER	nvarchar	64	The task participant who originated the item.
TO_USER	nvarchar	64	The task participant who is receiving the item.
STATUS	nvarchar	16	The status of the item.
START_DATE	datetime		The date the item started.
END_DATE	datetime		The date the item ends.
CREATED_DATE	datetime		The date the item was created.
CREATED_BY	nvarchar	64	The user who created the item.
DESCRIPTION	nvarchar	512	A free text description of the item.
REC_WEEKDAYS_STRING	varchar	16	The weekday code of the delegation, Monday=1, Tuesday=2,… Saturday=6, Sunday=0. If Tuesday and Friday, string will be '25'
LAST_UPDATED_DATE	datetime		The date the item was last updated.
LAST_UPDATED_BY	nvarchar	16	The user who last updated, or modified, the item.
CANCELLED_DATE	datetime		The date the item was canceled.
CANCELLED_BY	nvarchar	64	The user who canceled the item.
PROC_DEF_IDS	varchar	4000	A list of process definition IDs associated with the item.

Relationships

Table Name	Relationship
WF_REG_USERS	1 – n