IRV_CUR_USER

This view contains the most recent information for each InForm user.

Column Name (Key indicator)	Column Description
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.