IRV_USER_REVS

This view contains user revision information.

Column Name	Description
USERTYPEID	User thing type ID
USERID	User ID
USERREV	User revision number
ENTEREDBY	User ID who made the change.
ENTEREDDATE	Date when the change happened
ENTEREDREASON	Reason for the change
TRANSACTIONID	Transaction ID for the change
USERNAME	User Name
USERACTIVESTATE	User active state. 1 active, NULL inactive.
USERADDRESS1	User address1
USERADDRESS2	User address 2
USERALTPHONENUMBER	User alter phone number
USERANSWER	Answer to challenge question.
USERAUTHTYPE	Reserved field
USERCITY	User city
USERCONFLICT	Reserved field
USERCOUNTRY	User country
USERDATEFORMAT	Internal date format map
USERDAYPHONENUMBER	User day time phone number
USERDELETESTATE	User terminated. 1 yes. NULL not.
USERDESCRIPTION	User description
USERDISPLAYNAME	User display name
USEREMAILADDRESS	User email
USERFAXNUMBER	User fax
USERFIRSTNAME	User first name
USERHINTQUESTION	User 1pws hint question.
USERHOMESCREENURL	User’s InForm home screen URL
USERIMAGEID	User image ID
USERLANGID	User language ID
USERLASTNAME	User last name
USERPOSTALCODE	User postal code
USERRESETPASSWORD	User has to reset pwd on first logon. 1 yes, NULL no.
USERSTATEPROVINCE	User state province
USERSUBJECTGUID	Internal user GUID
USERTITLE	User title
USERTYPE	User type. 1: site user 2: sponser user 3: support user 4: integration user
CREATEDDATETIME	Date and time when the view row was created.
CREATEDBYUSERID	User ID of the user whose action resulted in the given view row being created.
MODIFIEDDATETIME	Date and time when the data in the view row was most recently updated.
MODIFIEDBYUSERID	User ID of the user whose action resulted in the most recent change to data in the given view row.