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

rs_av_id_view

rs_av_id_view

The rs_av_id_view view contains information about single-table constraints and table pairs that are based on an aggregate view. The view contains the run-time and test result information for each version of a single-table constraint or table pair.
The view might contain duplicate IDs. You can use SELECT DISTINCT to avoid duplicate IDs.
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 run of a given single-table constraint or table pair. Contains one of the following values:
  • 0. Not latest.
  • 1. Latest.
tr_start_time
Start time of the single-table constraint or table pair test. Time is represented as the number of milliseconds since 1970 UTC.
tr_start_timestamp
Start time of the single-table constraint or table pair test. The time corresponds to the millisecond value in the tr_start_time column and appears in standard date time form.
ti_id
ID of the test installation. Do not use 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 test.
tp_rs_result
Single-table constraint or table pair result. Contains one of the following values:
  • -2. Error.
  • -1. No results.
  • 0. Fail.
  • 1. Pass.
av_id
ID of the aggregate view.