FunctionalSpecs View

Applies to QAComplete 12.75 SaaS, last modified on April 01, 2021

Description

Contains detailed information on requirements.

Dependencies

Columns

ActFinish  :  datetime, allows null: yes

The date when the work on the requirement actually completed.

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

ActHrs  :  decimal (max 18 decimal digits), allows null: yes, default: 0

The actual number of hours spent on the requirement.

ActStart  :  datetime, allows null: yes

The date when the work on the requirement actually started.

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

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, default: 0

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

BusinessRule  :  varchar (max), allows null: yes

The business rule associated with the requirement.

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

Comments  :  varchar (max 8000 chars), allows null: yes

The comments added to the requirement.

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

Date and time when the requirement 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.

DateOpened  :  datetime, allows null: yes

The date and time when the item was opened.

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 the requirement 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), allows null: yes

The description of the requirement.

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

EstFinish  :  datetime, allows null: yes

The date and time the work on the requirement is estimated to finish.

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

EstHrs  :  decimal (max 18 decimal digits), allows null: yes, default: 0

The estimated time it will take to fulfill the requirement, in hours.

EstHrsRemaining  :  decimal (max 18 decimal digits), allows null: yes, default: 0

The estimated number of hours remaining to complete the work on the requirement.

EstStart  :  datetime, allows null: yes

The date and time the work on the requirement is estimated to start.

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

FolderId  :  int, allows null: yes

The ID of the folder where the requirement is located.

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

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

FunctionalSpecId  :  int, allows null: no

The ID of the requirement. It equals FuncSpecId.

FunctSpecId  :  int, allows null: no

The unique item identifier.

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

The group that contains the requirement. 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 FunctSpecGroup in the ValidationType column.

ImportId  :  int, allows null: yes

The ID of the imported batch in which the requirement was imported.

Keywords  :  varchar (max 200 chars), allows null: yes

The keywords associated with the requirement.

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.

NbrEscalations  :  int, allows null: no

The number of times an escalation rule affected the requirement.

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.

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.

OpenedBy  :  int, allows null: yes

The ID of the user who opened the item.

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

An alias for the CompanyName column of the Persons table.

The name of the company where the user works.

OpenedByEmail  :  varchar (max 255 chars), allows null: no

An alias for the Email column of the Persons table.

The email address of the user.

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.

OriginalId  :  int, allows null: yes

The column is reserved for system use only.

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, default: 0

The ID of the user who created the item.

PctComplete  :  tinyint, allows null: yes, default: 0

The percentage of fulfilling the requirement.

QAComplete calculates this value automatically when the user specifies how many hours have been spent on the requirement. To learn more, see Calculation of Percent Complete and Estimated Hours Remaining.

ProjId  :  int, allows null: no

The ID of the project that contains the requirement.

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

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

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

The subgroup that contains the requirement. 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 FunctSpecSGroup in the ValidationType column.

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

The title of the requirement.

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 associated item, in the Last name, First name format.

See Also

FunctionalSpecs Table
Requirements

Highlight search results