WF_ROLES

NAME_UPCASE

Function:

The name of the role in all uppercase letters.

Data Type:

nvarchar

Size:

64

Can Be Null:

No

Primary Key:

Yes

Foreign Key:

No

CREATED_BY

Function:

The user who created the role.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

CREATED_DATE

Function:

The date the role was created.

Data Type:

datetime

Size:

8

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

DESCRIPTION

Function:

A free text description for the role.

Data Type:

nvarchar

Size:

2048

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

ENABLED

Function:

Indicates whether the role is enabled.

Values:

• Yes - The role is enabled.
• No - The role is disabled.

Data Type:

varchar

Size:

3

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

LAST_MODIFIED_BY

Function:

The user who last updated, or modified, the role.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

LAST_MODIFIED_DATE

Function:

The date the role was last modified.

Data Type:

datetime

Size:

8

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

NAME

Function:

The name of the role.

Data Type:

nvarchar

Size:

128

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

RIGHT_FLAGS

Function:

A sequence of Yes or No flags that represent the access rights assigned to the role.

Values:

The values Y or N indicate whether an access right is assigned.

NNYNYNNYYYYYNNNNNNNNNNNYNNNNNYYNYYYNYYYNYYN NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNYNNNNN NYNNYNNNYYNNNNNNNNNYNNNYNNNNNNNNNNNNNNNNNNN NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

Data Type:

varchar

Size:

256

Can Be Null:

No

Primary Key:

No

Foreign Key:

No