WF_ASSIGNED_OBJECTS

Description

Contains information about assignment object for a user role.

Columns

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

Column Name	Data Type	Size	Description
ROLE_NAME	nvarchar	64	(Foreign key to WF_ROLES table) The uppercase name of the role.
ASSIGNEE	nvarchar	128	The person who is assigned to the role.
ASSIGNEE_TYPE	varchar	32	The type of the assignment such as: User.
CREATED_DATE	datetime	8	The date the item was created.
CREATED_BY	nvarchar	64	The user who created the item.
OBJECT_ID	varchar	32	The unique ID of the object.
OBJECT_TYPE	varchar	128	The type of object.
CLIENT_DATA	nvarchar	1024	The client data for the item.

Relationships

Table Name	Relationship
WF_ROLES	n – 1