Description
Instances of design tests in test sets.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | TC_TESTCYCL_ID | The record ID. | int | 4 | |||
| TC_CYCLE_ID | The CYCLE.CY_CYCLE_ID of the test set containing this test. | int | 4 | ||||
| TC_TEST_ID | The TEST.TS_TEST_ID of the design test of which this is an instance. | int | 4 | ||||
| TC_TEST_CONFIG_ID | The TEST_CONFIGS.TSC_ID of the configuration used by this test instance. | int | 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. | int | 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. | datetime | 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. | datetime | 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. | varchar | 16 | | |||
| TC_ATTACHMENT | A value of Y indicates that the 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 a future version. | int | 4 | | |||
| TC_TESTCYCLE_VER_STAMP | The revision number of this record. Increments each time the record is updated. | int | 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. | varchar | 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. | int | 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. | varchar | 16 | | |||
| TC_ITERATIONS | Contains information about the BPT test iterations that will be performed when executing this test. The format 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. | int | 4 | | |||
| TC_PINNED_BASELINE | The Baselines.BL_ID of the baseline to which this test instance is pinned. | int | 4 | | |||
| TC_SUBTYPE_ID | The type of the test that was run. | varchar | 100 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| TC_ASSIGN_RCYC_IDX | |||
| TC_PRIMARYKEY | | | |
| TC_STATUS_LWR_IDX | |||
| TC_TEST_CONFIG_ID_IDX | |||
| TC_TEST_ID_IDX | |||
| TC_TESTCYCLE_CVR_IDX | |||
| TC_TESTCYCLE_IDX | | ||
| TC_TESTER_NAME_LWR_IDX | |||
| TC_VTS_IDX | |
Triggers
| Trigger | Description |
|---|---|
| AUTR_363696399_TESTCYCL |
Objects that depend on td.TESTCYCL
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | AUTR_363696399_TESTCYCL | Trigger | 1 |
Objects that td.TESTCYCL depends on
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | td.AUDIT_LOG | Table | Events on which history is recorded. | 1 |
| td.AUDIT_PROPERTIES | Table | Details of the changes recorded in the AUDIT_LOG table. | 1 |
| td.BASELINES | Table | Baseline records. | 1 |
| td.RELEASE_CYCLES | Table | Details of cycles. A release can contain a number of cycles. | 1 |
See Also