The other data mart views usually provide easier access to detailed data, as this table does not provide direct access to information like the name of a test. The key of this table is the combination of the columns TestID, ExecutionPlanID, BuildID, and TestRunID.
| Row | Description |
|---|---|
| TestID | Identifier of the test. |
| ExecutionPlanID | Identifier of the execution plan. |
| BuildID | Identifier of the build. |
| TestRunID | Identifier of the test run. |
| ExecutionRunID | Identifies in which execution run this result was generated. |
| StatusID | Status of this test run (see TM_TestDefStatusNames). |
| EDRStatusID | Status of this execution run. For additional information, see TM_TestDefStatusNames. For example, status 7 = pending manual run, status 10 = pending automated run. |
| ReasonID | Reason for the status of this test run (see TM_ResultStatusReasons). Can be null. |
| PassedCount | Sum of all passed tests, which is 0 or 1 for common tests and can be more for package test roots. |
| FailedCount | Sum of all failed tests, which is 0 or 1 for common tests and can be more for package test roots. |
| NotExecutedCount | Sum of all not-executed tests, which is 0 or 1 for common tests and can be more for package test roots. |
| ProjectID | ID of the project that this row belongs to. |
| TestStartTime | Time when the test run started (UTC). |
| ExecutionStartTime | Time when the execution run started (UTC). |
| TestDurationInMilliseconds | Duration of the test run in milliseconds. |
| IsBlocked | Flags the test run as blocked/unblocked |
| DbChangedAt | Time when this row was last updated by the reporting data mart. |