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 |