Share this page
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | SP_ID | The record ID. | int | 4 | |||
| SP_ENTITY | The name of the table containing the entity for which the parameter value was created. For example, DESSTEPS, TESTCYCL, TEST_CONFIGS, or RUN. | varchar | 40 | ||||
| SP_OWNER_ID | The record ID in the table specified by SP_ENTITY. | int | 4 |  | |||
| SP_KEY | Obsolete. Replaced by SP_OWNER_ID. Retained in schema for backwards compatibility. Was: The string representation of the record ID of the instance to which the parameter belongs in the table specified by SP_ENTITY . | varchar | 40 | | |||
| SP_TEST_PARAM_ID | The TEST_PARAMS.TP_ID of the parameter. | int | 4 | | |||
| SP_PARAM_NAME | Obsolete. Retained in schema for backwards compatibility. Was: The parameter name. | varchar | 255 | ||||
| SP_PARAM_VALUE | Obsolete. Replaced by SP_PARAM_ACTUAL_VALUE. Retained in schema for backwards compatibility. Was: The parameter value. | varchar | 255 | | |||
| SP_PARAM_ACTUAL_VALUE | The parameter value. The value can be any string | varchar | 16 | | |||
| SP_ORIGIN_TEST | The TEST.TS_TEST_ID of the design test from which the step is derived. If no design test exists, -1. | int | 4 | | |||
| SP_VALUE_FROM_ENTITY | Obsolete. Retained in schema for backwards compatibility. | varchar | 40 | | |||
| SP_VALUE_FROM_KEY | Obsolete. Retained in schema for backwards compatibility. | varchar | 50 | | |||
| SP_REF_COUNT | Obsolete. This information is is the TEST_PARAMS Table. Retained in schema for backwards compatibility. Was: The number of steps in which this parameter is used. Applies only to Test entities. | int | 4 | | |||
| SP_ASSIGNED_BY | Obsolete. Retained in schema for backwards compatibility. | varchar | 40 | | |||
| SP_ASSIGN_DATE | Obsolete. Retained in schema for backwards compatibility. | datetime | 4 | | |||
| SP_ASSIGN_TIME | Obsolete. Retained in schema for backwards compatibility. | varchar | 12 | | |||
| SP_VC_USER_NAME | The user who checked out the item under version control. If the item is not checked out, this field is blank. | varchar | 60 | |
| Index | Description | Primary | Unique |
|---|---|---|---|
| STEP_PARAMS_IX1 | |||
| STEP_PARAMS_IX2 | |||
| STEP_PARAMS_PK | | |
Related Objects
