Validation tab
The information is displayed in these sections:
- Table group section: The summary of the number of failed records for each table.
- Rule group section: The summary of the number of failed records for each rule at each table selected in the First section.
- Individual Details section: The individual records which have failed validation for each rule/table selected in the First and Second sections.
The Table group section contains a summation of the tables which are validated. In the validation table (SZ_VALIDATION_LOG), a unique count of each record for each table which has a failed status (validation_rule_status) is also displayed. You can view the total number of failed records for all the tables displayed in this section on the No Failed Records (Total x) header. When you apply filter for the table, the total number of failed records are updated based on the displayed data. The records which have failed in multiple tables are not counted. For example, if a record has a failed validation in 2 tables, is counted only once. You can select multiple rows at a time to display the detailed information in the Rule group and Individual Details sections.
The Rule group section contains a summation of the Rules that are validated for the tables selected in the Table group section. In the validation table (SZ_VALIDATION_LOG), a unique count of each record for each table which has a failed status (validation_rule_status) is also displayed. You can view the total number of failed records for all the Rules/tables displayed in this section, on the No Failed Records (Total x) header. When you apply filter for the Table and/or rule, the total number of failed records are updated based on the displayed data. The records which have failed in multiple Rules/tables are not counted. For example, if a record has a failed validation in two rules, is counted only once.
The Individual Detail section contains the entries detailed information based on the Table/Rule selected in the above sections. You can filter or sort the displayed data by all columns (Table, Record, Rule and Status).
In each section, you can export the Validation Data/Table Data to Excel using the option. The output is based on the section used. If you select the option from the:
- Table group section: The detailed information of the selected rows, that is the data displayed on the Individual Details section (assuming no rows are selected in the middle section) is exported.
- Rule group section: The information displayed on the Individual Details section is exported.
- Individual Details section: The exported data is based on the rows selected in this section.
The Validation Data contains a row for each specific failure/record/table from the SZ_VALIDATION_LOG and SZ_VALIDATION_RULE tables.
The Table Data contains the data for which validation is failed. An additional column is included to display the rule which have failed for this table/record. In each section, you can select any or all rows and use the option. The exported excel file contains a row for each specific table/record combination for the selected table(s) and each table is displayed on a new sheet. At the end of each row, an additional column, ‘Rule’ contains a list of commas separated rules for which the particular table/record failed.