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.