|
Quality Center Database |
|
|
Quality Center Database |
Version control table for tests.
Details of the design test from the test plan module.
A test plan subject is a conceptual unit of testing. A subject acts as a folder for other subjects and for tests. The folder structure for test plan subjects is in the ALL_LISTS Table where test folders are descended from the record where ALL_LISTS.AL_DESCRIPTION = 'Subject'. The link from the TEST record to the test folder is the TS_SUBJECT field.
To see test coverage of requirements, use the REQ_COVER Table.
Design tests are linked to design steps with DESSTEPS.DS_TEST_ID.
Tests are linked to test sets in the TESTCYCL Table.
Tests are linked to test runs with RUN.RN_TEST_ID.
Tests are linked to actual run parameter values with the STEP_PARAMS, RUN, and CYCLE tables where To_number(STEP_PARAMS.SP_KEY) = RUN.RN_RUN_ID AND TEST.TS_TEST_ID = RUN.RN_TEST_ID AND RUN.RN_CYCLE_ID = CYCLE.CY_CYLE_ID.
Multiple values for fields are maintained in the TEST_MULTIVALUE Table.
For table relationships, , see the Test Plan Module Overview.
| Column Name | Description | Datatype | Length | Allow Nulls |
|
|---|---|---|---|---|---|
 |
TS_TEST_ID | The TEST.TS_TEST_ID of the item under version control. | Integer | 4 | |
| TS_NAME | The name of the test. | VarChar | 255 | 
|
|
| TS_STEPS | The number of design steps in the test. | Integer | 4 |
|
|
| TS_PATH | The path of this test relative to
the Tests directory in the server repository, whether on the file
system or in a database.
This is the location for automatic scripts linked to the test. To get the script files, use the Open Test Architecture API. |
VarChar | 255 |
|
|
| TS_SUBJECT | The ALL_LISTS.AL_ITEM_ID of the test plan subject folder in which the test resides. | Integer | 4 |
|
|
| TS_STATUS | The test’s current status.
The values are from the Plan Status custom list. |
VarChar | 70 |
|
|
| TS_RESPONSIBLE | The user responsible for implementing the test. | VarChar | 60 |
|
|
| TS_CREATION_DATE | The date on which the test was created. | DBTimeStamp | 4 |
|
|
| TS_DESCRIPTION | A description of the test. | LongVarChar | 16 |
|
|
| TS_TYPE | The type of test. For a description of possible test types, see The Quality Center Open Test Architecture API Reference . | VarChar | 70 |
|
|
| TS_TIMEOUT | For backward compatibility. Field may
be removed in future version.
For backward compatibility. Field may be removed in future version. |
Integer | 4 |
|
|
| TS_ATTACHMENT | A value of Y indicates that the test has at least one attachment. | VarChar | 1 |
|
|
| TS_RUNTIME_DATA | For backward compatibility. Field may be removed in future version. | VarChar | 255 |
|
|
| TS_USER_01 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_02 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_03 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_04 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_05 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_06 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_07 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_08 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_09 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_10 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_11 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_12 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_HR_01 | TS_USER_HR_01 to TS_USER_HR_06 are for backward compatibility. Fields may be removed in future version. | Integer | 4 |
|
|
| TS_ESTIMATE_DEVTIME | The time estimated to develop the test. | Integer | 4 |
|
|
| TS_TEST_VER_STAMP | The revision number of this record. Increments each time the record is updated. | Integer | 4 |
|
|
| TS_EXEC_STATUS | The execution status of the test. The
values are from the Status custom list. Typical values are: Not Completed, No Run, Passed, N/A, Failed. |
VarChar | 70 |
|
|
| TS_TEMPLATE | A value of Y indicates that this test is a template test. | VarChar | 1 |
|
|
| TS_STEP_PARAM | For backward compatibility. Field may be removed in future version. | Integer | 4 |
|
|
| TS_VTS | The version time stamp of the last record update according to the database server clock. | VarChar | 20 |
|
|
| TS_VC_CUR_VER | The last checked-in version of the test. Used by the Version Control engine. | VarChar | 50 |
|
|
| TS_USER_13 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_14 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_15 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_16 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_17 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_18 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_19 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_20 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_21 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_22 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_23 | User-defined field. | VarChar | 40 |
|
|
| TS_USER_24 | User-defined field. | VarChar | 40 |
|
|
| TS_TEXT_SYNC | For internal use. Do not change data. | VarChar | 1 |
|
|
| TS_DEV_COMMENTS | Developer's comment. | LongVarChar | 16 |
|
|
| |
TS_VC_USER_NAME | The user who locked the entity. | VarChar | 60 |
| Index | Primary | Unique |
|---|---|---|
| VCTS_PRIMARYKEY |
|
|
| TS_VC_USER_NAME_IDX | ||
| VCTS_EXEC_STATUS_LWR_IDX | ||
| VCTS_NAME_LWR_IDX | ||
| VCTS_PATH_INDEX | ||
| VCTS_RESPONSIBLE_LWR_IDX | ||
| VCTS_STATUS_LWR_IDX | ||
| VCTS_SUBJECT_IDX |
Copyright 2002-2007 Mercury Interactive Corporation. |
|
Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com |
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at webmaster@systemmanager.forsenergy.ru to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log.
Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.