WF_REG_USERS

USER_NAME_UPCASE

Function:

The name of the registered user in all uppercase letters.

Data Type:

nvarchar

Size:

256

Can Be Null:

No

Primary Key:

Yes

Foreign Key:

No

ALIAS

Function:

Specifies an alias name for the user.

Data Type:

nvarchar

Size:

32

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

DEPARTMENT

Function:

The department for the registered user.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

DISABLED

Function:

Specifies whether the user is disabled.

Values:

• Yes - The registered user is disabled.
• No - The registered user is enabled (Default value).

Data Type:

varchar

Size:

3

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

EMAIL_ADDRESS

Function:

The email address of the registered user.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

FULL_NAME

Function:

The full name of the registered user.

Data Type:

nvarchar

Size:

256

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

LEVEL

Function:

Specifies the level of the user in the organization.

Data Type:

nvarchar

Size:

8

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

LOCALE

Function:

The locale for the registered user.

Values:

An ISO language or locale code — for example, en-US for US English.

Data Type:

nvarchar

Size:

32

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

MANAGER

Function:

The manager of this registered user.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

ONLINE_CONTACT

Function:

Reserved for future use. Represents the chat client account.

Data Type:

nvarchar

Size:

64

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

REF_ID

Function:

Stores the RefID of the image value saved in WF_LARGE_BINARIES.

Data Type:

varchar

Size:

32

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

REGISTERED_DATE

Function:

The date the user was registered.

Data Type:

datetime

Size:

8

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

TITLE

Function:

The title for the registered user.

Data Type:

nvarchar

Size:

64

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

UAL_EXPIRATION_DATE

Function:

The date and time the user's floating license session expires.

Data Type:

datetime

Size:

8

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

UAL_NEVER_EXPIRES

Function:

Specifies whether the user license is set to expire.

Data Type:

varchar

Size:

3

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

USER_NAME

Function:

The name of the registered user as it was entered (can include both uppercase and lowercase characters).

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

USER_ORG_INFO

Function:

Information about the user's organization.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No