3.4.3.3 DQ Rules Summary

The Data Quality Rule Summary page contains the list of user-defined Data Quality Rules with details such as Name, Status, Folder, Is Executed, Version, Is Grouped, Check Type and Base table.

Refer to the following procedure to view DQ Rules Summary and the relevant details:

1. Click Data Quality Rules, to access the Data Quality Rules Summary.
   The Data Quality Rules Summary page with the following details is displayed.
   • Name - The Unique Identifier Name of the Data Quality Rule.
   • Status - The Approval status of the specific rule.
     • Approval - The Rule is approved and ready for execution. The approved rules can be grouped further for execution.
     • Pending for Approval - The rule requires approval and can be executed only after approval.
     • Draft - A defined rule is set toDraft status until it is submitted for approval by the creator.
     • Rejected - The rejected rules are sent back to the creator with the Approver comments.
   • Folder - The folder associated with the rule.
   • Version - The current active version of the rule.

     When a new definition is created, it will be saved as version 1 and once it is authorized, it will be in Active status. After you modify any DQ Rule and save, it will be saved with version as highest available version +1. For example, if you modify a DQ Rule of version 2 and the highest version available is 4, after you save the definition, its version becomes 5. Only the latest version will be in Active status.

   • Check Type - Select one of the following check types:
     • Single Column Check - define conditions based on individual checks on a single column. For more information, refer to Single Column Data Check Definitions.
     • Multi Column Check - define conditions based on multiple columns of a single base table. These checks are not pre-defined and can be specified (user-defined) as required. For more information, refer to Multi Column Data Check Definitions.
   • Base Table - The base table within the environment, associated with the rule.
   • Created By - The login name of the user who created the rule.
   • Created Date - The rule creation date.
   • Action - Click Action, to view, approve, reject edit, or delete the rule.

   To search for a particular rule, enter the first few letters of the rule name in the Search column.

   You can also sort the rule summary based on the Status, Folder name, check type, record status, Rule name and Select table.

   To sort the Summary based on the Status, click Status in the Search bar, and select the required status.