TestCases Table

Applies to QAComplete 12.93 SaaS, last modified on November 01, 2021

Description

The table stores test cases used in the legacy Test Cases module.

Columns

The table contains the following columns:

TestCaseId  :  int, primary key, allows null: no

The unique numeric identifier of the test case.

ProjId  :  int, allows null: no

The ID of the project that contains the test case.

ActFinish  :  datetime, allows null: yes

The date when the work on the test case 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 task.

ActStart  :  datetime, allows null: yes

The date when the work on the test case actually started.

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

ActualResults  :  varchar (max), allows null: yes

The actual results of performing the steps as compared to the expected results.

This column corresponds to a field that can be available for rich editing.

AssigneeUserId  :  int, allows null: yes, default: 0

The ID of the user to whom the test case is assigned.

AutomationScriptUNC  :  varchar (max 255 chars), allows null: yes

The column is reserved for system use only.

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

The date and time when the test case 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.

DefectId  :  int, allows null: yes

This column is not used.

EstFinish  :  datetime, allows null: yes

The date and time the work on the test case 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 needed to finish the test case, in hours.

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

The estimated number of hours remaining to finish the work on the test case.

EstStart  :  datetime, allows null: yes

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

ExpectedResults  :  varchar (max), allows null: yes

The expected results of performing the steps.

This column corresponds to a field that can be available for rich editing.

FolderId  :  int, allows null: yes

The ID of the folder where the item is located.

FunctSpecId  :  int, allows null: yes

This column is not used.

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

The group that contains the test case. 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 TCGroup in the ValidationType column.

ImportId  :  int, allows null: yes

The ID of the imported batch in which the test case was imported.

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

The keywords associated with the test case.

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

Ther percentage of test case completion.

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

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

The status of the test case based on the choice list. The values of this choice list are stored in the Validation table. They correspond to the items whose values equal TestCaseStatus in the ValidationType column.

Steps  :  varchar (max), allows null: yes

The steps to be performed in the test case.

This column corresponds to a field that can be available for rich editing.

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

The subgroup that contains the test case. 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 TCSubGroup in the ValidationType column.

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

The title of the test case.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

TestCases View
Legacy Test Management

Highlight search results