Project Data Tables Database > td Schema : td.STEP Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
ST_ID | The record ID. | int | 4 | ||||
ST_RUN_ID | The RUN.RN_RUN_ID of the test instance run to which this step belongs. | int | 4 | ||||
ST_STEP_NAME | The name of the test step. | varchar | 255 | ||||
ST_STATUS | The status of the test step. The values are from the Status custom list. | varchar | 70 | ||||
ST_EXECUTION_DATE | The date on which the test step was executed. | datetime | 4 | ||||
ST_EXECUTION_TIME | The time at which the test step was executed. | varchar | 10 | ||||
ST_DESCRIPTION | The step description. | varchar | 16 | ||||
ST_EXPECTED | The expected result of the test step. | varchar | 16 | ||||
ST_ACTUAL | The actual result of the test step. | varchar | 16 | ||||
ST_PATH | The folder of the test script containing the test step. | varchar | 255 | ||||
ST_LINE_NO | The line number on which the step appears in the test script. | int | 4 | ||||
ST_USER_01 | User-defined field. | varchar | 40 | ||||
ST_USER_02 | User-defined field. | varchar | 40 | ||||
ST_USER_03 | User-defined field. | varchar | 40 | ||||
ST_USER_04 | User-defined field. | varchar | 40 | ||||
ST_USER_05 | User-defined field. | varchar | 40 | ||||
ST_USER_06 | User-defined field. | varchar | 40 | ||||
ST_STEP_ORDER | The order in which the step appears within the test. | int | 4 | ||||
ST_DESSTEP_ID | The DESSTEPS.DS_ID of the design step on which the test step is based. | int | 4 | ||||
ST_ATTACHMENT | A value of Y indicates that the step has at least one attachment. | varchar | 1 | ||||
ST_TEST_ID | The TEST.TS_TEST_ID of the test to which the step belongs. | int | 4 | ||||
ST_OBJ_ID | The type of manual step when running test manually. The values are: 0 - Test, 1 - Test iteration, 2 - Group, 3 - Group iteration, 4- Inner Component, 5 - Leaf Component, 6 - Component iteration, 7 - Component Step, 8 - Test instance iteration. | int | 4 | ||||
ST_LEVEL | The depth in the manual runner tree. Tests in the root are level 0. | int | 4 | ||||
ST_EXTENDED_REFERENCE | For backward compatibility. Field may be removed in future version. | varchar | 50 | ||||
ST_COMPONENT_DATA | For backward compatibility. Field may be removed in future version. | varchar | 16 | ||||
ST_PARENT_ID | The record ID of the parent node in the tree. For a component step, for example, the ID of the component that includes the step, which is also the parent node of the step in the manual runner tree. | int | 4 | ||||
ST_BPTA_CONDITION | The business process run condition in XML. | varchar | 16 | ||||
ST_REL_OBJ_ID | If the step represents a BPTEST_TO_COMPONENT entity, the BPTEST_TO_COMPONENTS.BC_ID. | int | 4 | ||||
ST_BPT_PATH | The highest level node has path AAA. Each child node down the tree inherits the parent path and adds three letters,where the current level numeration is concatenated to the inherited path. For example, the child requirements of the first node (AAA) have paths of AAAAAA, AAAAAB, AAAAAC, and so on. The characters V and W are not used. | varchar | 16 | ||||
ST_BPT_FACET_TYPE | For internal use by HP. | varchar | 255 |
Index | Description | Primary | Unique |
---|---|---|---|
ST_PRIMARYKEY | |||
ST_RUN_IDX | |||
ST_TEST_ID_IDX | |||
STEP_IDX3 |