The default TestStand schema logs common subproperties of all steps to this table.

Table 14. STEP_RESULT Table Schema
Column Name Data Type Description
ID Primary Key Unique value that identifies each entry in the table. For Microsoft Access and Microsoft SQL Server, the default process model assumes that this column increments automatically. For Oracle, the default process model uses an Oracle SQL sequence to generate a unique number.
UUT_RESULT Foreign Key Unit Under Test (UUT) ID from the UUT_RESULT table that associates the step result with a UUT.
STEP_PARENT Foreign Key ID of the parent sequence call step result when the step is a step in a subsequence.
STEP_NAME String Name of the step.
STEP_TYPE String Name of the step type.
STEP_GROUP String Step group that contains the step. The value is "Main", "Setup", or "Cleanup".
STEP_INDEX Number Zero-based position of the step in the step group.
STEP_ID String Unique ID of the step.
Note This Step_ID property is not the same as the TS.StepId used to report test results.
STATUS String Status of the step.
REPORT_TEXT String Report text of the step.
ERROR_CODE Number Error code when the step status is Error.
ERROR_MESSAGE String Error message when the step status is Error.
CAUSED_SEQFAIL Boolean Indicates whether the step failure caused the sequence to fail.
MODULE_TIME Number Number of seconds the step module took to execute.
TOTAL_TIME Number Number of seconds the step took to execute, including module execution and all step options, such as preconditions, expressions, post actions, and module loading.
NUM_LOOPS Number Number of loops the step executed, if any.
NUM_PASSED Number Number of loops the step returned with a status of Passed, if any.
NUM_FAILED Number Number of loops the step returned with a status of Failed, if any.
ENDING_LOOP_INDEX Number The loop index after executing the ending loop.
LOOP_INDEX Number The value of the loop index for an iteration of the step.
INTERACTIVE_EXENUM Number Number TestStand assigns to an interactive execution. The number is unique with respect to all other interactive executions in the current TestStand session. TestStand adds this property only when you run the step interactively.
ORDER_NUMBER Number The order in which the step executed within the execution.