USERCOUNT

Always 1; indicates that the row represents one user.

USERTYPEID

Numeric identifier for the user type.

USERID (PK)

Numeric identifier for the user.

USERREV

Revision number for the user.

USERCREATETIME

Date the user was created.

USERACTIVESTATETIME

Most recent date the user was assigned the Active state.

USERDELETESTATETIME

Most recent date the user was assigned the Deleted state.

USERREVTIME

Time of last user revision.

USERNAME

Account name for the user.

RIGHTSGROUPID

Numeric identifier of the rights group to which the user is currently assigned.

RIGHTSGROUP

Name of the rights group to which the user is currently assigned.

USERACTIVESTATE

User is currently activated:

0 - No

1 - Yes

USERADDRESS1

First line of the user address.

USERADDRESS2

Second line of the user address.

USERALTPHONENUMBER

User alternate telephone number.

USERAUTHTYPE

Indicates whether or not the user has authority to reset passwords.

USERCITY

City in which the user address is located.

USERCONFLICT

Used by synchronization to identify sync conflicts.

USERCOUNTRY

Country in which the user address is located.

USERDATEFORMAT

Desired date format for viewable InForm pages for the user.

USERDAYPHONENUMBER

User daytime telephone number.

USERDELETESTATE

Indicates whether the user has been terminated. Options are true or false.

Note: Terminated users remain in the database.

USERDESCRIPTION

Description of the user; for example, user's role in the study.

USERDISPLAYNAME

User name, as displayed in the InForm application window. Maximum length is 63 characters; shorter strings are recommended.

USEREMAILADDRESS

User email address.

USERFAXNUMBER

User fax number.

USERFIRSTNAME

Given name of the user.

USERHOMESCREENURL

Local or external URL identifying the initial screen that appears when a user logs in to the InForm application.

USERIMAGEID

Name of the image file that appears in the InForm application above the user name.

USERLASTNAME

Surname of the user.

USERPOSTALCODE

User postal code.

USERRESETPASSWORD

Set to 1 if a user must reset a password.

USERSTATEPROVINCE

State or province where the user is located.

USERSUBJECTGUID

GUID for the user identifier.

USERLANGID

User preferred language.

USERTITLE

User title.

USERTYPE

User type. For example, Sponsor.

USERMINACTIVESTATETIME

First date when the user was assigned the Active state.

USERMINDELETESTATETIME

First date when the user was assigned the Deleted state.

CREATEDBYUSERID

User ID of the user whose action resulted in the given view row being created.

CREATEDBYDATETIME

Date and time when the view row was created.

MODIFIEDBYUSERID

User ID of the user whose action resulted in the most recent change to data in the given view row.

MODIFIEDDATETIME

Date and time when the data in the view row was most recently updated.