Description
Contains detailed information on users.
Dependencies
Columns
ADSearchValue : nvarchar (max), allows null: yes
The search value of the Active Directory service (used only in the On-Premises version).
CellPhone : varchar (max 25 chars), allows null: yes
The cell phone number of the user.
Comments : varchar (max 255 chars), allows null: yes
The comments added to the user’s profile.
This column corresponds to a field that can be available for Rich Text Feature.
CompanyName : varchar (max 50 chars), allows null: yes
The name of the company where the user works.
ContactPerson : varchar (max 50 chars), allows null: yes
This column is not used.
Custom1..Custom10 : varchar (max 8000 chars), allows null: yes
The values of custom fields 1 - 10.
These columns correspond to fields that can be available for Rich Text Feature.
Custom11..Custom90 : varchar (max 100 chars), allows null: yes
The values of custom fields 11 through 90.
DateCreated : datetime, allows null: no, default: Current date and time
The date and time when the item was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateFirstLogon : datetime, allows null: yes
The date and time the user first logged in.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateLastLogon : datetime, allows null: yes
The date the time the user last logged in.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateOfAnniv : datetime, allows null: yes
This column is not used.
DateUpdated : datetime, allows null: no, default: Current date and time
The date and time when the item was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
Discount : decimal (max 10 decimal digits), allows null: yes
This column is not used.
Email : varchar (max 255 chars), allows null: no
The email address of the user.
Email2 : varchar (max 255 chars), allows null: yes
This column is not used.
Fax : varchar (max 25 chars), allows null: yes
The fax number of the user.
FirstName : varchar (max 25 chars), allows null: no
The first name of the user.
Grouping : varchar (max 30 chars), allows null: yes, default: None
The group that contains the user. Group names are specified in a choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal PersonsGroup in the ValidationType column.
HomePhone : varchar (max 25 chars), allows null: yes
The home phone number of the user.
ImportId : int, allows null: yes
The ID of the imported batch in which the user was imported.
IsActive : char (max 1 char), allows null: yes
Indicates whether the user is active.
IsADAccount : nvarchar (max 1 char, or 4 bytes), allows null: yes
Indicates whether the user logs in using the Active Directory service (used only in the On-Premises version).
IsLoggedOn : char (max 1 char), allows null: yes
Indicates whether the user is logged in.
IsSecurityAdmin : char (max 1 char), allows null: yes
Indicates whether the user is a security administrator.
IsSelected : char (max 1 char), allows null: yes, default: N
This column is not used.
LastName : varchar (max 25 chars), allows null: no
The last name of the user.
LogonAttempts : int, allows null: yes
This column is not used.
MI : varchar (max 25 chars), allows null: yes
The middle initial of the user.
NbrAddresses : int, allows null: yes
The number of the attached user addresses.
NbrEvents : int, allows null: yes
The number of events attached to the associated item.
NbrFiles : int, allows null: yes
The number of files attached to the associated item.
NbrNotes : int, allows null: yes
The number of notes attached to the associated item.
NbrTimesLogon : int, allows null: no, default: 0
The number of times the user logged in.
NbrVariables : int, allows null: yes
The number of the user’s custom variables.
Newsletters : varchar (max 8000 chars), allows null: yes
This column is not used.
OtherPhone : varchar (max 25 chars), allows null: yes
The number of an unspecified phone.
Pager : varchar (max 25 chars), allows null: yes
The pager number of the user.
Password : nvarchar (max 255 chars, or 512 bytes), allows null: yes
The encrypted password of the user.
PersonName : varchar (max 78 chars), allows null: no
The name of the user, in the Last name, First name format.
PrimaryDeptId : int, allows null: yes, default: 0
The column is reserved for system use only.
SpouseName : varchar (max 50 chars), allows null: yes
This column is not used.
SubGrouping : varchar (max 30 chars), allows null: yes, default: None
The name of the subgroup that contains the user. Subgroup names are specified in a choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal PersonsSubGroup in the ValidationType column.
TimeZoneCode : varchar (max 100 chars), allows null: yes, default: GMT-07 Mountain (US/Canada)
The time zone where the user is located.
Title : varchar (max 100 chars), allows null: yes
The title of the user record.
UpdateUserId : int, allows null: no
The ID of the user who last updated the item.
UserId : int, allows null: no
The unique identifier of the user.
UserName : varchar (max 78 chars), allows null: no
The name of the user who last updated the item, in the Last name, First name format.
WebSite : varchar (max 255 chars), allows null: yes
The address of the user’s web site.
WebSite2 : varchar (max 255 chars), allows null: yes
The column is reserved for system use only.
WorkPhone : varchar (max 25 chars), allows null: yes
The work phone number of the user.
This is a helper table that stores user variables.