Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: Glossary

Data Validation Option User Guide

Data Validation Option User Guide

results_id_view

results_id_view

The results_id_view view contains overall results for all tests in a single-table constraint or table pair. This view aggregates test-level information from the results_summary_view view.
The following table describes the view columns:
View Column
Description
tr_id
Test run ID for all tests associated with the single-table constraint or table pair. Increments for each test run.
tr_is_latest
Indicates whether this is the latest test run for the single-table constraint or table pair. Contains one of the following values:
  • 0. Not latest.
  • 1. Latest.
tr_start_time
Start time of the test run. Time is represented as the number of milliseconds since 1970 UTC.
tr_start_timestamp
Start time of the test run. The time corresponds to the millisecond value in the tr_start_time column and appears in standard date time form.
ti_id
ID for test installation. Do not include in reports.
tp_obj_id
ID of the single-table constraint or table pair.
tp_version
Version of the single-table constraint or table pair.
tp_user_id
User ID of the person who ran the tests.
tp_rs_result
Result of all tests in the single-table constraint or table pair. Contains one of the following values:
  • -2. Error.
  • -1. No results.
  • 0. Fail.
  • 1. Pass.