HP ALM Database Reference
td.STEP_PARAMS Table

Description

The values of the parameters in the TEST_PARAMS Table.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key SP_IDThe record ID.int4  
 SP_ENTITYThe name of the table containing the entity for which the parameter value was created. For example, DESSTEPS, TESTCYCL, TEST_CONFIGS, or RUN.varchar40  
 SP_OWNER_IDThe record ID in the table specified by SP_ENTITY.int4 
 SP_KEY

Obsolete. Replaced by SP_OWNER_ID. Retained in schema for backwards compatibility.

The string representation of the record ID of the instance to which the parameter belongs in the table specified by SP_ENTITY .

varchar40 
 SP_TEST_PARAM_IDThe TEST_PARAMS.TP_ID of the parameter.int4 
 SP_PARAM_NAME

Obsolete. Retained in schema for backwards compatibility.

The parameter name.

varchar255  
 SP_PARAM_VALUEObsolete. Replaced by SP_PARAM_ACTUAL_VALUE. Retained in schema for backwards compatibility.The parameter value.varchar255 
 SP_PARAM_ACTUAL_VALUEThe parameter value. The value can be any stringvarchar16 
 SP_ORIGIN_TEST

The TEST.TS_TEST_ID of the design test from which the step is derived.

If no design test exists, -1.

int4 
 SP_VALUE_FROM_ENTITY

Obsolete. Retained in schema for backwards compatibility.

varchar40 
 SP_VALUE_FROM_KEY

Obsolete. Retained in schema for backwards compatibility.

varchar50 
 SP_REF_COUNT

Obsolete. This information is is the TEST_PARAMS Table. Retained in schema for backwards compatibility.

The number of steps in which this parameter is used. Applies only to Test entities.

int4 
 SP_ASSIGNED_BY

Obsolete. Retained in schema for backwards compatibility.

varchar40 
 SP_ASSIGN_DATE

Obsolete. Retained in schema for backwards compatibility.

datetime4 
 SP_ASSIGN_TIME

Obsolete. Retained in schema for backwards compatibility.

varchar12 
 SP_VC_USER_NAMEThe name of the item.varchar60 

See Also