IRV_CUR_USER
This view contains the most recent information for each InForm user.
Columns in the IRV_CUR_USER view
IRV_CUR_USER |
IRV_CUR_USER |
---|---|
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. |