HP ALM 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 NullsDefault
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_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_ID varchar100 

See Also