Table of Contents

Search

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

Data Validation Option User Guide

Data Validation Option User Guide

rs_sv_id_view

rs_sv_id_view

The rs_sv_id_view view contains information about single-table constraints and table pairs that are based on a SQL 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.
sv_id
ID of the SQL view.