Validations View

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

Description

Contains detailed information on choice lists.

Dependencies

Columns

AppCode  :  varchar (max 100 chars), allows null: no

The type of the application. agSP corresponds to QAComplete SaaS; agSPEnt corresponds to QAComplete On-Premises.

Code  :  varchar (max 100 chars), allows null: no

The value of the choice list.

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.

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.

Description  :  varchar (max 300 chars), allows null: no

The description of the choice list value.

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

The column is reserved for system use only.

Grouping1  :  varchar (max 30 chars), allows null: yes

The column is reserved for system use only.

Grouping2  :  varchar (max 15 chars), allows null: yes

The column is reserved for system use only.

IsActive  :  char (max 1 char), allows null: no

Indicates whether the choice list is active.

IsNonStandard  :  char (max 1 char), allows null: yes, default: N

The column is reserved for system use only.

NbrFiles  :  int, allows null: yes

The number of files attached to the item.

NbrNotes  :  int, allows null: yes

The number of notes attached to the item.

ProjId  :  int, allows null: no

The ID of the project that contains the item.

SortOrder  :  int, allows null: no, default: (0)

The ordinal number of the choice list value. Or 0, if the values are sorted alphabetically.

UpdateUserId  :  int, allows null: no

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

ValidationId  :  int, allows null: no

The unique numeric identifier of the item.

ValidationType  :  varchar (max 30 chars), allows null: no

The type of the validations. Depends on the related module and on the name of the related choice list.

See Also

Validations Table
Crossmodules

Highlight search results