Verifying that data values conform to business regulations
To verify that the business follows a stated policy, define a rule statement that applies an expression to key data columns.
For example, you might configure a rule statement that validates mortgage loan applications for a mortgage broker. The mortgage broker refuses any loan application that requires the applicant to repay more than twenty-five percent of their salary each month. The rule statement tests the monthly repayment amount against an expression that calculates the salary percentage.
1Select a rule set in a rule specification.
2In the rule set properties, click Rule Logic.
3Click Add Rule Statement.
4Select an input for the rule statement.
- If the rule specification does not contain an input that you can use, create an input. Configure the input properties to represent the type of column that contains the business data.
Note: The input represents the monthly repayment amount on the mortgage loan.
5Select an operator to validate the results of the condition analysis.
- To identify input values that are greater than twenty-five percent of another value, select the following operator:
is greater than
6Select the type of condition to apply to the input.
- To define an expression to test the input data, select the following condition type:
function
7Configure the condition to apply an expression to the input data. The expression uses an input that represents the monthly salary of the loan applicant.
- Open the Define Condition dialog box, and select Input.
- Select the float or the integer data type.
- In the Value 1 field, select the input column that represents the monthly salary data.
- Add a value field under the current value.
- Enter the number 4 in the Value 2 field.
- Select the division sign [ / ] to indicate that the expression divides the first value by the second value.
- Click OK.
8Select the type of action to apply to the data that satisfies the condition logic.
- To return a string value, select the following action type:
string value
9Enter the value that the action returns. For example, enter DENY_LOAN.