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_bad_records_view

rs_bad_records_view

The rs_bad_records_view view contains information about bad records for tests. You can join this view with the results_summary_view view based on the tr_id and tc_index columns to get bad records associated with a single-table constraint, table pair, or test run.
For each single-table constraint, the *_a columns in the view contain information about the table on which the single-table constraint is based. The *_b columns are null for single-table constraints.
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.
tc_index
ID of the test in a single-table constraint or table pair.
tc_rs_br_key_a,
tc_rs_br_key_b
Key of the bad record.
tc_rs_br_value_a,
tc_rs_br_value_b
Value that does not meet the test condition.
tc_rs_br_value_delim_a, tc_rs_br_value_delim_b
String value with leading and trailing delimiters that indicate the presence of whitespace.
tc_rs_br_value_difference
Difference in value for numeric data.
tc_rs_br_value_diff_perc
Percentage of difference in value for numeric data. Data Validation Option uses the following formula to calculate the percentage of difference:
(<larger value> - <smaller value>) ÷ <larger value> * 100