ALM Project Database Reference
td.CYCLE Table
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 NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CY_CYCLE_IDThe ID of the test set record.int4   
 CY_CYCLEThe test set name assigned by the creator of the test set.varchar255  
 CY_OPEN_DATEThe date the test set was opened.datetime4  
 CY_CLOSE_DATEThe date the test set was closed.datetime4  
 CY_STATUSThe current status of the test set: Open or Closed.varchar70  
 CY_DESCRIPTIONThe information entered in the Execution Flow tab in the user interface. Includes execution dependencies (conditions) and comments.varchar16  
 CY_CYCLE_VER_STAMPThe revision number of this record. Increments each time the record is updated.int4  
 CY_COMMENTA description of the test set.varchar16  
 CY_ATTACHMENTIndicates whether the test set has any attachments: Y or N.varchar1  
 CY_EXEC_EVENT_HANDLEThe actions to be executed in response to various test set execution events. This field is in a proprietary format.
varchar16  
 CY_MAIL_SETTINGSThe mailing actions in response to various test set execution events. This field is in a proprietary format.varchar16  
 CY_REPORT_SETTINGSReport notification settings.varchar16  
 CY_USER_01User-defined field.varchar40  
 CY_USER_02User-defined field.varchar40  
 CY_USER_03User-defined field.varchar40  
 CY_USER_04User-defined field.varchar40  
 CY_USER_05User-defined field.varchar40  
 CY_USER_06User-defined field.varchar40  
 CY_VTSThe version time stamp. Indicates the time this record was updated according to the database server clock.varchar20  
 CY_OS_CONFIGFor backward compatibility. Field may be removed in future version.varchar40  
 CY_FOLDER_ID

The CYCL_FOLD.CF_ITEM_ID of the folder containing the test set.

int4  
 CY_ORDER_ID int4  
 CY_CYCLE_CONFIGFor backward compatibility. Field may be removed in future version.varchar16  
 CY_REQUEST_IDFor backward compatibility. Field may be removed in future version.int4  
 CY_TEXT_SYNC

For internal use. Do not change data.

varchar1  
 CY_ASSIGN_RCYCThe RELEASE_CYCLES.RCYC_ID of the release cycle with which the test set is associated.int4  
 CY_PINNED_BASELINEThe BASELINES.BL_ID of the baseline to which this item is pinned.int4  
 CY_SUBTYPE_IDAn EST_ID from the ENTITY_SUBTYPES Table where the EST_ENTITY_TABLE_NAME is  TEST or  CYCLE. The default is hp.qc.test-set.defaultvarchar100  
 CY_DYNAMIC_DATA

For internal use.

varchar16  
 CY_ENVIRONMENTThe ID of the td.ENVIRONMENTS Tableint4  
Indexes
IndexDescriptionPrimaryUnique
CY_FOLDER_IDX  
CY_FOLDER_NAME_IDX  
CY_PRIMARYKEY 
Triggers
TriggerDescription
AUTR64594118_CYCLE 
Objects that depend on td.CYCLE
 Database ObjectObject TypeDescriptionDep Level
AUTR64594118_CYCLE triggerAUTR64594118_CYCLETrigger 1
td.V_TESTSET_REQ_COVER viewtd.V_TESTSET_REQ_COVERView 1
Objects that td.CYCLE depends on
 Database ObjectObject TypeDescriptionDep Level
td.AUDIT_LOG tabletd.AUDIT_LOGTableEvents on which history is recorded.1
td.AUDIT_PROPERTIES tabletd.AUDIT_PROPERTIESTableDetails of the changes recorded in the AUDIT_LOG table.1
td.BASELINES tabletd.BASELINESTableBaseline records.1
td.ENVIRONMENTS tabletd.ENVIRONMENTSTableTesting environments.1
td.RELEASE_CYCLES tabletd.RELEASE_CYCLESTableDetails of cycles. A release can contain a number of cycles.1
See Also