AD_Users

USERID

Unique identifier for the user.

USERACTIVE

Has the user been activated?

Yes or No.

LASTNAME

Last name of the user.

FIRSTNAME

First name of the user.

MIDDLENAME

Middle name of the user.

CUSTOMURL

URL of the Custom Homepage. (Can be NULL.)

ROLEID

Unique identifier of the role.

ROLENAME

Name of the role.

RECEIVEEMAIL

Has the user chosen to receive emails?

Yes or No.

USERCOUNTRYCODE

Code of the country where the user is located.

USERCOUNTRYTEXT

Text name of the country where the user is located.

USERTIMEZONE

Time zone of the user:

• Eastern Standard Time.
• Central Standard Time.
• Pacific Standard Time.
• Central European Standard Time.
• E. European Standard Time.
• GMT Standard Time.
• Mountain Standard Time.
• China Standard Time.
• Tokyo Standard Time.

USERPHONE

The phone number of the user (max=20; alphanumeric)

USERDATEFORMAT

Preferred date format:

• 1—Day/Month/Year:Hour:Minute:Second
• 2—Month/Day/Year Hour:Minute:Second
• 3—Year/Month/Day Hour:Minute:Second

USERNAMESORT

Order of first and last user and patient names:

• Firstname-Lastname
• Lastname-Firstname

USERNUMBERFORMAT

Preferred number format:

• Normal (12345)
• Thousands Separator (12,345)

USERCURRENCYFORMAT

Type of currency:

• U.S. dollar
• Japanese yen
• Chinese renminbi (RMB)

USEREMAIL

Email address of the user.

MEMORABLEQUESTION

Memorable question that helps to identify the user when the user recalls or changes a password.

MEMORABLEANSWER

Answer to the memorable question that helps to identify the user when the user recalls or changes a password.

LANID

Identifier of the language, enabling you to filter the view by language.