WF_ASSIGNED_OBJECTS

Stores information about the assigned objects for a role.

Columns

Column Name Definition

ASSIGNEE
Function:
The user or group assigned to the role.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ASSIGNEE_TYPE
Function:
The type of assignment.
Values:
  • User - A user name.
  • Group - A group name.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

CREATED_BY
Function:
The user who created the assigned object.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

CREATED_DATE
Function:
The date the assigned object was created.
Data Type:
datetime
Size:
8
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

OBJECT_ID
Function:
The unique ID of the object.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

OBJECT_TYPE
Function:
The type of object.
Values:
All
Data Type:
varchar
Size:
128
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ROLE_NAME
Function:
The uppercase name of the role.
Data Type:
nvarchar
Size:
128
Can Be Null:
No
Primary Key:
No
Foreign Key:
  • WF_ROLES - n:1

Relationships

Table Name Relationship
WF_ROLES n:1