HP ALM Database Reference
td.TESTCYCL Table

Description

Instances of design tests in test sets.

Remarks

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.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key TC_TESTCYCL_IDThe record ID.int4  
 TC_CYCLE_IDThe CYCLE.CY_CYCLE_ID of the test set containing this test.int4  
 TC_TEST_IDThe TEST.TS_TEST_ID of the design test of which this is an instance.int4  
 TC_TEST_CONFIG_IDThe TEST_CONFIGS.TSC_ID of the configuration used by this test instance.int4  
 TC_CYCLEFor backward compatibility. Field may be removed in future version.varchar255 
 TC_TEST_ORDERThe order in which the test instance appears within the test set in the user interface.int4 
 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.

varchar70 
 TC_TESTER_NAMEThe user name of the person responsible for running the test.varchar60 
 TC_EXEC_DATEThe date on which the test was last executed.datetime4 
 TC_EXEC_TIMEThe time at which the test was last executed.varchar10 
 TC_PLAN_SCHEDULING_DATEThe date on which the tester plans to next run the test.datetime4 
 TC_PLAN_SCHEDULING_TIMEThe time at which the tester plans to next run the test.varchar10 
 TC_HOST_NAMEThe name or IP address of the host server on which the test is planned to be executed.varchar50 
 TC_EPARAMSThe application-dependant configuration string created by the testing tool.varchar16 
 TC_ATTACHMENTA value of Y indicates that the test instance has at least one attachment.varchar1 
 TC_USER_01User-defined field.varchar40 
 TC_USER_02User-defined field.varchar40 
 TC_USER_03User-defined field.varchar40 
 TC_USER_04User-defined field.varchar40 
 TC_USER_05User-defined field.varchar40 
 TC_USER_06User-defined field.varchar40 
 TC_USER_07User-defined field.varchar40 
 TC_USER_08User-defined field.varchar40 
 TC_USER_09User-defined field.varchar40 
 TC_USER_10User-defined field.varchar40 
 TC_USER_11User-defined field.varchar40 
 TC_USER_12User-defined field.varchar40 
 TC_TEST_VERSIONFor backward compatibility. This field may be removed in a future version.int4 
 TC_TESTCYCLE_VER_STAMPThe revision number of this record. Increments each time the record is updated.int4 
 TC_EXEC_EVENT_HANDLEThe actions to be executed in response to various test set execution events. This field is in a proprietary format.varchar16 
 TC_VTSThe time this record was last updated according to the database server clock.varchar20 
 TC_TEST_INSTANCEThe 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.int4  
 TC_USER_13User-defined field.varchar40 
 TC_USER_14User-defined field. User-defined field.varchar40 
 TC_USER_15User-defined field.varchar40 
 TC_USER_16User-defined field.varchar40 
 TC_USER_17User-defined field.varchar40 
 TC_USER_18User-defined field.varchar40 
 TC_USER_19User-defined field.varchar40 
 TC_USER_20User-defined field.varchar40 
 TC_USER_21User-defined field.varchar40 
 TC_USER_22User-defined field.varchar40 
 TC_USER_23User-defined field.varchar40 
 TC_USER_24User-defined field.varchar40 
 TC_OS_CONFIGFor future use.varchar40 
 TC_ACTUAL_TESTERThe user who last executed this test instance.varchar60 
 TC_DATA_OBJAn XML string containing parameter values for Business Process Test iterations.varchar16 
 TC_ITERATIONSContains 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.varchar255 
 TC_ASSIGN_RCYCThe RELEASE_CYCLES.RCYC_ID of the release cycle with which the test instance is associated.int4 
 TC_PINNED_BASELINEThe Baselines.BL_ID of the baseline to which this test instance is pinned.int4 
 TC_SUBTYPE_ID varchar100 

See Also