FunctionalSpecs Table

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

Description

Stores the requirements specified in all the projects.

Columns

The table contains the following columns:

FunctSpecId  :  int, primary key, allows null: no

The unique item identifier.

ProjId  :  int, allows null: no

The ID of the project that contains the requirement.

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.

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

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

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.

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

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.

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

OpenedBy  :  int, allows null: yes

The ID of the user who opened the item.

OriginalId  :  int, allows null: yes

The column is reserved for system use only.

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.

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

See Also

FunctionalSpecs View
Requirements

Highlight search results