|
Quality Center Database |
|
|
Quality Center Database |
Instances of design tests in test sets.
A test can be used more than once in a test set. Each use is an instance. This table stores the position (order) of each instance and some data about the instance.
Multiple values for fields are maintained in the TESTCYCL_MULTIVALUE Table.
| Column Name | Description | Datatype | Length | Allow Nulls |
|
|---|---|---|---|---|---|
 |
TC_TESTCYCL_ID | The record ID. | Integer | 4 | |
| TC_CYCLE_ID | The CYCLE.CY_CYCLE_ID of the test set containing this test. | Integer | 4 | ||
| TC_TEST_ID | The TEST.TS_TEST_ID of the design test of which this is an instance. | Integer | 4 | ||
| TC_CYCLE | For backward compatibility. Field may be removed in future version. | VarChar | 255 | 
|
|
| TC_TEST_ORDER | The order in which the test instance appears within the test set in the user interface. | Integer | 4 |
|
|
| TC_STATUS | The status of the last run of the test
instance. The values are from the Status custom list.
Typical values are: Not Completed, No Run, Passed, N/A, Failed. |
VarChar | 70 |
|
|
| TC_TESTER_NAME | The user name of the person responsible for running the test. | VarChar | 60 |
|
|
| TC_EXEC_DATE | The date on which the test was last executed. | DBTimeStamp | 4 |
|
|
| TC_EXEC_TIME | The time at which the test was last executed. | VarChar | 10 |
|
|
| TC_PLAN_SCHEDULING_DATE | The date on which the tester plans to next run the test. | DBTimeStamp | 4 |
|
|
| TC_PLAN_SCHEDULING_TIME | The time at which the tester plans to next run the test. | VarChar | 10 |
|
|
| TC_HOST_NAME | The name or IP address of the host server on which the test is planned to be executed. | VarChar | 50 |
|
|
| TC_EPARAMS | The application-dependant configuration string created by the testing tool. | LongVarChar | 16 |
|
|
| TC_ATTACHMENT | A value of Y indicates thethe test instance has at least one attachment. | VarChar | 1 |
|
|
| TC_USER_01 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_02 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_03 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_04 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_05 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_06 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_07 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_08 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_09 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_10 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_11 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_12 | User-defined field. | VarChar | 40 |
|
|
| TC_TEST_VERSION | For backward compatibility. This field may be removed in future version | Integer | 4 |
|
|
| TC_TESTCYCLE_VER_STAMP | The revision number of this record. Increments each time the record is updated. | Integer | 4 |
|
|
| TC_EXEC_EVENT_HANDLE | The actions to be executed in response to various test set execution events. This field is in a proprietary format. | LongVarChar | 16 |
|
|
| TC_VTS | The time this record was last updated according to the database server clock. | VarChar | 20 |
|
|
| TC_TEST_INSTANCE | The number of this test instance inside the cycle. This field enables several test instances with the same TC_TEST_ID to reside within the same test set. | Integer | 4 | ||
| TC_USER_13 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_14 | User-defined field. User-defined field. | VarChar | 40 |
|
|
| TC_USER_15 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_16 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_17 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_18 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_19 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_20 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_21 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_22 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_23 | User-defined field. | VarChar | 40 |
|
|
| TC_USER_24 | User-defined field. | VarChar | 40 |
|
|
| TC_OS_CONFIG | For future use. | VarChar | 40 |
|
|
| TC_ACTUAL_TESTER | The user who last executed this test instance. | VarChar | 60 |
|
|
| TC_DATA_OBJ | An XML string containing parameter values for Business Process Test iterations. | LongVarChar | 16 |
|
|
| TC_ITERATIONS | Contains information about the BPT test iterations that will be performed when executing this test. Theformat is: <total defined iterations>;<first iteration>;<last iteration>. If all defined iterations are to be run, the field may be empty. | VarChar | 255 |
|
|
| TC_ASSIGN_RCYC | The RELEASE_CYCLES.RCYC_ID of the release cycle with which the test instance is associated. | Integer | 4 |
|
| Index | Primary | Unique |
|---|---|---|
| TC_PRIMARYKEY |
|
|
| TC_TESTCYCLE_IDX |
|
|
| TC_ACTUAL_TESTER_LWR_IDX | ||
| TC_ASSIGN_RCYC_IDX | ||
| TC_STATUS_LWR_IDX | ||
| TC_TEST_ID_IDX | ||
| TC_TESTER_NAME_LWR_IDX |
| Trigger | Description |
|---|---|
| AUTR_363696399_TESTCYCL |
Copyright 2002-2007 Mercury Interactive Corporation. |
|
Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com |