ReleaseStats Table

Applies to QAComplete 12.70 SaaS, last modified on January 11, 2021

Description

Stores detailed release statistics based on the linked items (project plans, agile tasks, requirements, or defects).

Columns

The table contains the following columns:

FKID  :  int, allows null: no, default: Auto Filled: Key to Releases table.

The ID of the related item.

D_ActFinish  :  datetime, allows null: yes

The date when the work on the related defects actually completed.

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

D_ActHrs  :  decimal (max 18 decimal digits), allows null: yes

The actual number of hours spent on all the related defects.

D_ActStart  :  datetime, allows null: yes

The date when the work on the related defects actually started.

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

D_EstFinish  :  datetime, allows null: yes

The date and time the work on the related defects 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.

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

The estimated number of hours needed to fix all the related defects.

D_EstHrsRemaining  :  decimal (max 18 decimal digits), allows null: yes

The estimated number of hours remaining to fix all the related defects.

D_EstStart  :  datetime, allows null: yes

The date and time the work on the related defects 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.

FS_ActFinish  :  datetime, allows null: yes

The date when the related requirements actually completed.

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

FS_ActHrs  :  decimal (max 18 decimal digits), allows null: yes

The actual number of hours spent on the related requirements.

FS_ActStart  :  datetime, allows null: yes

The date when the work on the requirements actually started.

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

FS_EstFinish  :  datetime, allows null: yes

The date and time the work on the related requirements 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.

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

The estimated number of hours needed to fulfill all the related requirements.

FS_EstHrsRemaining  :  decimal (max 18 decimal digits), allows null: yes

The estimated number of hours remaining to fulfill the related requirements.

FS_EstStart  :  datetime, allows null: yes

The date and time the work on the related requirements 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.

NbrBuilds  :  int, allows null: yes

The number of release builds.

NbrDefects  :  int, allows null: yes

The number of linked defects.

NbrIterations  :  int, allows null: yes

The number of release iterations.

NbrLinkedTests  :  int, allows null: yes

The number of linked tests.

NbrProjectPlans  :  int, allows null: yes, default:

Then number of linked project plans.

NbrProjectPlanTasks  :  int, allows null: yes

The number of tasks in the related project plans.

NbrQuickTasks  :  int, allows null: yes

The number of linked agile tasks.

NbrRequirements  :  int, allows null: yes

The number of linked requirements.

NbrTestCases  :  int, allows null: yes

The number of linked legacy test cases.

NbrTests  :  int, allows null: yes

The number of tests linked to the related requirements.

NbrTestSets  :  int, allows null: yes

The number of linked test sets.

PPT_ActFinish  :  datetime, allows null: yes

The date when the work on the related project plans actually completed.

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

PPT_ActHrs  :  decimal (max 18 decimal digits), allows null: yes

The actual number of hours spent on all the tasks of the related project plans.

PPT_ActStart  :  datetime, allows null: yes

The date when the work on the related project plans actually started.

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

PPT_EstFinish  :  datetime, allows null: yes

The date and time the work on the related project plans 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.

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

The estimated number of hours needed to complete all the tasks of the related project plans.

PPT_EstHrsRemaining  :  decimal (max 18 decimal digits), allows null: yes

The estimated number of hours remaining to complete all the tasks of the related project plans.

PPT_EstStart  :  datetime, allows null: yes

The date and time the work on the related project plans 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.

QT_ActFinish  :  datetime, allows null: yes

The date when the work on the related agile tasks actually completed.

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

QT_ActHrs  :  decimal (max 18 decimal digits), allows null: yes

The actual number of hours spent on the related agile tasks.

QT_ActStart  :  datetime, allows null: yes

The date when the work on agile tasks actually started.

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

QT_EstFinish  :  datetime, allows null: yes

The date and time the work on the related agile tasks 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.

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

The estimated number of hours needed to complete all the related agile tasks.

QT_EstHrsRemaining  :  decimal (max 18 decimal digits), allows null: yes

The estimated number of hours remaining to work on the related agile tasks.

QT_EstStart  :  datetime, allows null: yes

The date and time the work on the related agile tasks 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.

TC_ActFinish  :  datetime, allows null: yes

The date when the work on the related test cases actually completed.

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

TC_ActHrs  :  decimal (max 18 decimal digits), allows null: yes

The actual number of hours spent on all the related test cases.

TC_ActStart  :  datetime, allows null: yes

The date when the work on the related test cases actually started.

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

TC_EstFinish  :  datetime, allows null: yes

The date and time the work on the related test cases 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.

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

The estimated number of hours needed to complete all the related test cases.

TC_EstHrsRemaining  :  decimal (max 18 decimal digits), allows null: yes

The estimated number of hours remaining to complete all the related test cases.

TC_EstStart  :  datetime, allows null: yes

The date and time the work on the related test cases 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.

See Also

Releases Table
Releases

Highlight search results