ALM Project Database Reference
td.STEP Table
Description
Test steps performed during a test instance run.
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ST_IDThe record ID.int4   
 ST_RUN_IDThe RUN.RN_RUN_ID of the test instance run to which this step belongs.int4   
 ST_STEP_NAMEThe name of the test step.varchar255  
 ST_STATUS

The status of the test step.

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

varchar70  
 ST_EXECUTION_DATEThe date on which the test step was executed.datetime4  
 ST_EXECUTION_TIMEThe time at which the test step was executed.varchar10  
 ST_DESCRIPTIONThe step description.varchar16  
 ST_EXPECTEDThe expected result of the test step.varchar16  
 ST_ACTUALThe actual result of the test step.varchar16  
 ST_PATHThe folder of the test script containing the test step.varchar255  
 ST_LINE_NOThe line number on which the step appears in the test script.int4  
 ST_USER_01User-defined field.varchar40  
 ST_USER_02User-defined field.varchar40  
 ST_USER_03User-defined field.varchar40  
 ST_USER_04User-defined field.varchar40  
 ST_USER_05User-defined field.varchar40  
 ST_USER_06User-defined field.varchar40  
 ST_STEP_ORDERThe order in which the step appears within the test.int4  
 ST_DESSTEP_IDThe DESSTEPS.DS_ID of the design step on which the test step is based.int4  
 ST_ATTACHMENTA value of Y indicates that the step has at least one attachment.varchar1  
 ST_TEST_IDThe TEST.TS_TEST_ID of the test to which the step belongs.int4  
 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.

int4  
 ST_LEVELThe depth in the manual runner tree. Tests in the root are level 0.int4  
 ST_EXTENDED_REFERENCE

For backward compatibility. Field may be removed in future version.

varchar50  
 ST_COMPONENT_DATA

For backward compatibility. Field may be removed in future version.

varchar16  
 ST_PARENT_IDThe 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.int4  
 ST_BPTA_CONDITIONThe business process run condition in XML.varchar16  
 ST_REL_OBJ_IDIf the step represents a BPTEST_TO_COMPONENT entity, the BPTEST_TO_COMPONENTS.BC_ID.int4  
 ST_BPT_PATHThe 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.varchar16  
 ST_BPT_FACET_TYPEFor internal use.varchar255  
Indexes
IndexDescriptionPrimaryUnique
ST_PRIMARYKEY 
ST_RUN_IDX  
ST_TEST_ID_IDX   
STEP_IDX3   
See Also