ALM Project Database Reference
td.TEST_CONFIGS Table
Description
The data to be used in the run of a Test.
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
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. If the item is not checked out, this field is blank.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  
Indexes
Triggers
TriggerDescription
AUTR1916707492_TEST_CONFIGS 
Objects that depend on td.TEST_CONFIGS
 Database ObjectObject TypeDescriptionDep Level
AUTR1916707492_TEST_CONFIGS triggerAUTR1916707492_TEST_CONFIGSTrigger 1
td.V_TESTSET_REQ_COVER viewtd.V_TESTSET_REQ_COVERView 1
Objects that td.TEST_CONFIGS 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
See Also