HP ALM Database Reference
td.TEST_CONFIGS Table

Description

The data to be used in the run of a Test.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key TSC_IDThe record ID.int4  
 TSC_TEST_IDThe TEST.ID.int4  
 TSC_NAMEThe name of the item.varchar255  
 TSC_DESCDescription of the item.varchar16 
 TSC_CREATED_BYThe user name of the user who created this item.varchar60 
 TSC_CREATION_DATEThe server date when this item was created.datetime4 
 TSC_EXEC_STATUS

The result of the most recent run of this configuration.

The values are from the Status custom list.
Typical values are: Not Completed, No Run, Passed, N/A, Failed.

varchar70 
 TSC_VTSThe version time stamp.varchar20  
 TSC_VC_CHECKOUT_USER_NAMEThe user who checked out the item under version control.varchar60 
 TSC_ATTACHMENTA value of Y indicates that the item has at least one attachment.varchar1 
 TSC_USER_01User-defined field.varchar40 
 TSC_DATA_FILTERING

An XML string containing the filter to apply to the data resource.

For example:

<FilterData>
    <Rows><![CDATA[10-20&cd;></Rows>
    <FilterElement>
        <ParameterName><![CDATA[P3&cd;></ParameterName>
        <FilterValue><![CDATA[TLV&cd;></FilterValue>
    </FilterElement>
...
</FilterData>

varchar16 
 TSC_DATA_STATE

The source of the parameter values to be used in this configuration. One of:

0
Static values stored in the TEST_PARAMS Table. If the configuration belongs to a Business Process test, static data is stored in TSC_DATA_OBJ.
1
The Data Resource of the parent Test.
2
The Data Resource of this configuration.
For values 1 and 2, the data is found through the ASSET_RELATIONS Table. The owner type and owner ID point to the parent test or to this configuration and ASR_THE_DATA is Y.
int4  
 TSC_DATA_OBJAn XML string containing static parameter values for Business Process Test configurations.varchar16 

See Also