Persons Table

Applies to QAComplete 12.84 SaaS, last modified on July 19, 2021

Description

Stores the users created in QAComplete.

Columns

The table contains the following columns:

UserId  :  int, primary key, allows null: no

The unique identifier of the user.

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 editing.

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 editing.

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 Validation 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.

NbrTimesLogon  :  int, allows null: no, default: 0

The number of times the user logged in.

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.

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 Validation 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.

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.

See Also

Persons View
Setup

Highlight search results