Description
Test sets.
Remarks
The test set tree is maintained in the CYCL_FOLD Table.
Test sets are linked to tests in the TESTCYCL Table.
Test sets are linked to test runs with RUN.RN_CYCLE_ID.
Multiple values for fields are maintained in the CYCLE_MULTIVALUE Table.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CY_CYCLE_ID | The ID of the test set record. | int | 4 | |||
| CY_CYCLE | The test set name assigned by the creator of the test set. | varchar | 255 |  | |||
| CY_OPEN_DATE | The date the test set was opened. | datetime | 4 | | |||
| CY_CLOSE_DATE | The date the test set was closed. | datetime | 4 | | |||
| CY_STATUS | The current status of the test set: Open or Closed. | varchar | 70 | | |||
| CY_DESCRIPTION | The information entered in the Execution Flow tab in the user interface. Includes execution dependencies (conditions) and comments. | varchar | 16 | | |||
| CY_CYCLE_VER_STAMP | The revision number of this record. Increments each time the record is updated. | int | 4 | | |||
| CY_COMMENT | A description of the test set. | varchar | 16 | | |||
| CY_ATTACHMENT | Indicates whether the test set has any attachments: Y or N. | varchar | 1 | | |||
| CY_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 | | |||
| CY_MAIL_SETTINGS | The mailing actions in response to various test set execution events. This field is in a proprietary format. | varchar | 16 | | |||
| CY_REPORT_SETTINGS | Report notification settings. | varchar | 16 | | |||
| CY_USER_01 | User-defined field. | varchar | 40 | | |||
| CY_USER_02 | User-defined field. | varchar | 40 | | |||
| CY_USER_03 | User-defined field. | varchar | 40 | | |||
| CY_USER_04 | User-defined field. | varchar | 40 | | |||
| CY_USER_05 | User-defined field. | varchar | 40 | | |||
| CY_USER_06 | User-defined field. | varchar | 40 | | |||
| CY_VTS | The version time stamp. Indicates the time this record was updated according to the database server clock. | varchar | 20 | | |||
| CY_OS_CONFIG | For backward compatibility. Field may be removed in future version. | varchar | 40 | | |||
| CY_FOLDER_ID | The CYCL_FOLD.CF_ITEM_ID of the folder containing the test set. | int | 4 | | |||
| CY_ORDER_ID | int | 4 | | ||||
| CY_CYCLE_CONFIG | For backward compatibility. Field may be removed in future version. | varchar | 16 | | |||
| CY_REQUEST_ID | For backward compatibility. Field may be removed in future version. | int | 4 | | |||
| CY_TEXT_SYNC | For internal use. Do not change data. | varchar | 1 | | |||
| CY_ASSIGN_RCYC | The RELEASE_CYCLES.RCYC_ID of the release cycle with which the test set is associated. | int | 4 | | |||
| CY_PINNED_BASELINE | The BASELINES.BL_ID of the baseline to which this item is pinned. | int | 4 | | |||
| CY_SUBTYPE_ID | An EST_ID from the ENTITY_SUBTYPES Table where the EST_ENTITY_TABLE_NAME is TEST or CYCLE. The default is hp.qc.test-set.default | varchar | 100 | | |||
| CY_DYNAMIC_DATA | For internal use by HP. | varchar | 16 | | |||
| CY_ENVIRONMENT | The ID of the td.ENVIRONMENTS Table | int | 4 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| CY_FOLDER_IDX | | ||
| CY_FOLDER_NAME_IDX | | ||
| CY_PRIMARYKEY | | |
Triggers
| Trigger | Description |
|---|---|
| AUTR64594118_CYCLE |
Objects that depend on td.CYCLE
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | AUTR64594118_CYCLE | Trigger | 1 | |
 | td.V_TESTSET_REQ_COVER | View | 1 |
Objects that td.CYCLE 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.ENVIRONMENTS | Table | Testing environments. | 1 |
| td.RELEASE_CYCLES | Table | Details of cycles. A release can contain a number of cycles. | 1 |
See Also