ExtendedAttributes Table

Applies to QAComplete 12.80 SaaS, last modified on April 20, 2021

Description

The table contains additional information for other records on other core tables, in a one-to-one relationship. For example, a record on the Tests table will have one record on the ExtendedAttributes table.

Not all columns are used by all modules.

Columns

The table contains the following columns:

ExtendedAttributeId  :  int, primary key, allows null: no, default: Auto filled unique identifier

The unique numeric identifier of the item.

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 associated item is assigned.

ClosedBy  :  int, allows null: yes

The ID of the user who closed the associated item.

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

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

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.

EntityCode  :  varchar (max 100 chars), allows null: no, default: Module name of the related record

The name of the module that contains the associated item.

You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.

FKId  :  int, allows null: no, default: Unique identifier of the related record (1:1 relationship)

The unique numeric identifier of the associated item.

FolderId  :  int, allows null: yes

The numeric identifier of the folder where the associated item is located.

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

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

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.

LatestNotes  :  varchar (max), allows null: yes

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

NbrEscalations  :  int, allows null: yes

The number of times an escalation rule affected the associated 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.

NbrTasks  :  int, allows null: yes

The number of tasks attached to the associated item.

OpenedBy  :  int, allows null: yes

The ID of the user who added the associated item.

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

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

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 associated item.

ResolvedBy  :  int, allows null: yes

The ID of the user who resolved the associated item.

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

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

UpdateUserId  :  int, allows null: yes

The ID of the user who last updated the associated 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.

See Also

Attachments Table
Crossmodules

Highlight search results