Common Types of Rule Statements Overview

Verify the accuracy of business data

Define a rule statement that compares input data to a reference table.

Use the rule statement to verify that the business data is accurate. For example, define a rule statement to verify that a product description table uses the current product codes.

Standardize business data values

Define a rule statement that searches for values that you specify and replaces them with other values.

Use the rule statement to verify that the business data follows a standard format. For example, define a rule statement to verify that financial data does not use currency symbols. The rule statement replaces the currency symbols with agreed abbreviations for the currency names.

Improve the usability of business data

Define a rule statement that removes redundant characters and redundant strings.

Use the rule statement to ensure that users and software applications can read the business data correctly. For example, define a rule statement to delete character spaces at the start and end of a data fields.

Use data values to discover information about business users

Define rule statements that correlate information from different inputs. Use different rule statements to analyze the inputs and connect the inputs with AND logic. For example, define rule statements to link different facts about customers and improve the customer service to the customers.

Use data values to verify a business policy

Define a rule statement that verifies that the business follows a stated policy.

Use the rule statement to define an expression that represents the policy.

Update data values to match business standards

Define a rule statement that adds characters to data values so that the values meet the current business standards.

Use the rule statement to define an expression that updates the values.