HP ALM Database Reference
td.RUN Table

Description

Execution records for test instances.

Remarks

Multiple values for fields are maintained in the RUN_MULTIVALUE Table.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
 RN_TESTCYCL_IDThe TESTCYCL.TC_TESTCYCL_ID of the test instance.int4  
 RN_CYCLE_IDThe CYCLE.CY_CYCLE_ID of the test set containing the test instance.int4  
 RN_TEST_IDThe TEST.TS_TEST_ID of the design test from which the instance is derived.int4  
 RN_TEST_CONFIG_IDThe TEST_CONFIGS.TSC_ID of the configuration used in the run.int4  
Primary Key RN_RUN_IDThe record ID.int4  
 RN_RUN_NAMEThe name assigned to the test run by the tester.varchar255 
 RN_EXECUTION_DATEThe date on which the test instance run was performed.datetime4 
 RN_EXECUTION_TIMEThe time at which the run was performed according to the database server clock.varchar10 
 RN_HOSTThe name or IP address of the host server on which the test was executed.varchar50 
 RN_STATUSThe values are from the Status custom list.
Typical values are: Not Completed, No Run, Passed, N/A, Blocked, and Failed.
varchar70 
 RN_DURATIONThe duration of the test run in seconds.int4 
 RN_DRAFT'Y' indicates a draft run.varchar1 
 RN_TESTER_NAMEThe user name of the person who last executed the test.varchar60 
 RN_ITERS_PARAMS_VALUESAn XML string containing the values of the parameters of all iterations of the run. This field is populated by QuickTest Professional.varchar16 
 RN_ITERS_SUM_STATUSAn XML string containing the summary of the run's iteration statuses.varchar16 
 RN_PATHThe path of this run relative to the test directory (TEST.TS_PATH) in the server repository.varchar255 
 RN_USER_01User-defined field.varchar40 
 RN_USER_02User-defined field.varchar40 
 RN_USER_03User-defined field.varchar40 
 RN_USER_04User-defined field.varchar40 
 RN_USER_05User-defined field.varchar40 
 RN_USER_06User-defined field.varchar40 
 RN_USER_07User-defined field.varchar40 
 RN_USER_08User-defined field.varchar40 
 RN_USER_09User-defined field.varchar40 
 RN_USER_10User-defined field.varchar40 
 RN_USER_11User-defined field.varchar40 
 RN_USER_12User-defined field.varchar40 
 RN_TEST_VERSIONObsolete. This field may be removed in a future version.int4 
 RN_ATTACHMENTA value of Y indicates that the run has at least one attachment.varchar1 
 RN_RUN_VER_STAMPThe revision number of this record. Increments each time a the record is updated.int4 
 RN_VTSThe version time stamp. Indicates the time according to the database server clock at which this record was last updated.varchar20 
 RN_CYCLEFor backward compatibility. Field may be removed in future version.varchar255 
 RN_TEST_INSTANCEThe number of this instance of the design test inside the cycle. If the test is run individually, this field will still show which instance was selected to run.int4  
 RN_OS_NAMEThe name of the operating system on which the test run is running. The value is from the Operating System custom list.varchar70 
 RN_OS_SPInformation about the operating system of the computer on which current run was executed.varchar70 
 RN_OS_BUILDInformation about the operating system of the computer on which current run was executed.varchar70 
 RN_VC_LOKEDBYThe name of the user who locked the test in Version Control engine.varchar255 
 RN_VC_STATUSThe version control status of the test instance at the time of execution. The value is from the VC Status custom list. Typical values are checked_out, checked_in, or Read_only.varchar50 
 RN_VC_VERSIONObsolete. Replaced by RN_VC_VERSION_NUMBER.varchar50 
 RN_OS_CONFIGFor future use.varchar40 
 RN_ASSIGN_RCYCThe RELEASE_CYCLES.RCYC_ID of the release cycle with which the run is associated.int4 
 RN_BPTA_CHANGE_DETECTED

Status of Business Process Test for SAP

1 - No change detected

2 - Change status is unknown

3 - Change detected

int4 
 RN_BPTA_CHANGE_AWARENESS

Y if change detection mode enabled for this run. Applies to Business Process Test for SAP.

varchar1 
 RN_VC_VERSION_NUMBERThe version number of the TEST used for this run.int4 
 RN_PINNED_BASELINEThe BASELINES.BL_ID of the baseline to which this item is pinned.int4 
 RN_BPT_STRUCTURE varchar16 
 RN_STATE

A value of the  'Run State' project list indicating the current state of the Run.  As delivered, the values of the list are Finished, Initializing, Run Failure, Running, and Stopping.

varchar100 
 RN_COMMENTSComments.varchar16 
 RN_SUBTYPE_ID varchar100 
 RN_TEXT_SYNCFor internal use. Do not change data.varchar1 

See Also