Contacts View

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

Description

Contains detailed information on contacts.

Dependencies

Columns

AssignedToName  :  varchar (max 78 chars), allows null: yes

The name of the user to whom the associated item is assigned, in the Last name, First name format.

AssigneeUserId  :  int, allows null: yes

The ID of the user to whom the contact is assigned.

CellPhone  :  varchar (max 25 chars), allows null: yes

The cell phone number of the contact.

CompanyName  :  varchar (max 50 chars), allows null: yes

The name of the company that relates to the contact.

ContactId  :  int, allows null: no

The unique item identifier of the contact.

ContactPerson  :  varchar (max 50 chars), allows null: no

The name of the contact.

ContactType  :  varchar (max 100 chars), allows null: yes

The type of the contact based on a choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal ContactType in the ValidationType column.

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.

Date1stContact  :  datetime, allows null: yes

The date when the first contact with the person was made.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateCallBack  :  datetime, allows null: yes

The date to call the contact again.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateCreated  :  datetime, allows null: yes, 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.

DateLastEscalated  :  datetime, allows null: yes

The date when the associated item was last affected by an escalation rule.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: yes, 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.

Description  :  varchar (max 1000 chars), allows null: yes

The description of the contact.

This column corresponds to a field that can be available for Rich Text Feature.

Email  :  varchar (max 255 chars), allows null: yes

The e-mail address of the contact.

Fax  :  varchar (max 25 chars), allows null: yes

The fax number of the contact.

FolderId  :  int, allows null: yes

The ID of the folder where the item is located.

FolderName  :  varchar (max 511 chars), allows null: yes

The name of the folder where the associated item is located.

HomePhone  :  varchar (max 25 chars), allows null: yes

The home phone number of the contact.

ImportId  :  int, allows null: yes

If the item was imported, it is the ID of the imported batch.

LastEscalationRule  :  varchar (max 100 chars), allows null: yes

The name of the escalation rule that last affected the associated item.

LastEscalationRuleId  :  int, allows null: yes

The ID of the escalation rule that last affected the associated item.

NbrAddresses  :  int, allows null: no

Shows the number of associated addresses.

NbrEscalations  :  int, allows null: no

Shows the number of escalation rules that affected the item.

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.

NbrFilesNotSecured  :  int, allows null: yes

The column is reserved for system use only.

NbrNotes  :  int, allows null: yes

The number of notes attached to the associated item.

NotesDescription  :  varchar (max), allows null: yes

An alias for the LatestNotes column of the ExtendedAttributes table.

A description of the latest note attached to the associated item.

OtherPhone  :  varchar (max 25 chars), allows null: yes

Other phone number of the contact.

OutlookId  :  varchar (max 100 chars), allows null: yes

The column is not used.

OwnerName  :  varchar (max 78 chars), allows null: yes

The name of the user who owns the associated item, in the Last name, First name format.

OwnerUserId  :  int, allows null: yes

The ID of the user who owns the contact.

Pager  :  varchar (max 25 chars), allows null: yes

The pager number of the contact.

PrimaryAddress  :  varchar (max 1000 chars), allows null: yes

The contact’s primary address.

This column corresponds to a field that can be available for Rich Text Feature.

ProjId  :  int, allows null: yes

The ID of the project that contains the item.

Status  :  varchar (max 100 chars), allows null: yes

The status of the contact based on a choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal ContactStatus in the ValidationType column.

Title  :  varchar (max 255 chars), allows null: yes

The title of the contact.

UpdateUserId  :  int, allows null: yes

The ID of the user who last updated the item.

UserName  :  varchar (max 78 chars), allows null: yes

The name of the user who last updated the associated item, in the Last name, First name format.

Website  :  varchar (max 255 chars), allows null: yes

The web site address of the contact.

WorkPhone  :  varchar (max 25 chars), allows null: yes

The work phone number of the contact.

See Also

Addresses Table
Contacts

Highlight search results