Manage Rules

Rules allow to write VB .NET code to validate data entered in the process file. Based on the rule selection in Mapper, the code will be executed and data in the process file will be validated. Note that the Rules are independent of Queries and Database Connection. If the Rule refers to any query mentioned in Queries page then the data in the process file will be validated with the data stored in Database or SAP table.

Rules section displays the following details in tabular form

Add Rule

Add Rule is used to add new rule to the list. When you select 'Add' a new window will open to enter the basic details of the rule.

• Rule Name: Any user specific name can be set for Rule.
• Active: Active field can be set as 'Yes' or 'No'. On selecting 'Yes' this rule will be applied to records whenever its application request will be sent from Process Runner. If 'No' is selected then the rule will not be applied to records on request sent from Process Runner. No data validation will happen with this option.

All active and inactive rules will be displayed in the Data Governance Rule window in Mapper.

Data Governance Rule window that appears on selecting Data Governance Rule in Mapper. The changes done in Rules page get reflected on selecting Refresh and does not require user to log off and log in to Process Runner.

• Description: This field allows to enter a brief description of the rule. This description will be displayed in Process Runner.
• Rule Code: The VB.NET code for the rule needs to be written in this section to validate the data records. This code will be executed at the time of process execution and data validation will be done. Queries will be executed if required. If you are using standard query then in the rule specify dbTable = iSelectQuery("Queryname%"), the data governance rule will compulsorily be complied and executed for each row of process file in Process Runner. This may have a slight impact on the performance of large files.

If you are using stored procedure then refer the following syntax to refer to particular table or output parameter.

• If stored procedure returns only one table then specify  iSelectQuery("QueryName") in the rule code.
• If stored procedure returns more than one table then in order to refer first table, specify iSelectquery("QueryName")("iTable"). And to refer  the second table, write iSelectquery("QueryName")("iTable1"). Increment the last integer number after iTable to refer more tables.
• If stored procedure returns output parameters then to refer the output parameter, specify iSelectquery("QueryName")("ParameterName"). Do not include @ before the output parameter.
• If stored procedure returns one table along with output parameters then to refer table write iSelectquery("QueryName")("iTable") and refer the above point to refer output parameter.

• Save: The details get saved and the newly added rule is displayed in Rules page.
• Cancel: Closes Add Query window and takes back to Rules screen.

Edit Rule

Select the Edit icon to edit the selected rule in the list.

Admin Info

• Created By: Displays the name of the user who created the data governance rule.
• Created On: Displays the date and time when the rule was added. The time displayed is as  per user time zone setting.
• Changed By: Displays the name of the user who updated the rule.
• Changed On: Displays the date and time when the rule was last updated. The time displayed is as per user time zone setting.

Copy Rule

• Source Rule: Select the existing rule from the drop-down options.
• New Rule Name: Enter the name of the new rule, and then select Create.

Delete Rule

Select the Delete icon to delete selected rule. This option is used to delete the specific Rule ID from the list.