9.3.2 Creating Match/Merge Ruleset
This topic describes the systematic instructions to create match and merge rulesets.
Note:
To create custom match rulesets, see the Custom Rulesets for Matching section in the OFS Compliance Studio Administration and Configuration Guide.Each Ruleset comprises multiple rules. The Ruleset compares the attributes defined in the rules for the source entity with the target entity. For example, Customer to Customer, Customer to Derived Entity, Derived Entity to Derived Entity, etc.
Every entity has attributes such as email IDs, the date of birth, jurisdiction, etc. To derive a match and create a similarity edge on the graph or merge records in FSDF, you must apply the conditions for these attributes such as match type, scoring method, threshold score, and weightage.
To create a new Ruleset, follow these steps:
- On the Ruleset page, click Add. The page displays as
follows:
- For Match Rules: Create Ruleset fields details
- For Merge Rules: Create Merge Ruleset page details
- Enter the ruleset field values as described in the following table.
Table 9-9 Create a Ruleset
Fields Description Ruleset Name The name of the Ruleset. Note: Ruleset Name field accepts only 255 characters.
Scoring Aggregation Type By default, the maximum scoring aggregation method is selected. This scoring aggregation considers the highest score obtained out of all the rules created for a ruleset. Source The source entity. For example, customer, account, address, etc. Source Filter Source Filter icon is applicable for the Source field. You can filter the records further with Attributes corresponding to the selected Source type. It excludes the records by filtering out based on provided filter criteria and executes the matching rules on the filtered records.
Note: It is an optional step.
Multiple filter criteria are allowed in the filter.
To add filter conditions, follow these steps- Click Source Filter icon. The Add Source entity Filter window is displayed.
- Click Add icon. The Attributes and conditions are displayed.
- Select the attribute, Like (equal to)operator from Attribute Operator drop-down list and enter the corresponding value(s) in the Value text box, respectively.
- Click Save to save the filters.
- Click Delete icon to delete the corresponding filter.
Note:- You can add multiple filter conditions based on the available attributes from the Attribute drop-down list.
- You can enter multiple values for each Attribute in the Value text box with comma-separated.
- The Value field accepts only a comma as a special character. If any of the attributes requires a special character other than a comma is not allowed to filter the records. For example, email ID, DOB, Date, Phone number (if it has a special character).
Target Select the target entity. For example, customer, account, address, etc. Note: This field is applicable for Match Ruleset only.
Target Filter Target Filter icon is applicable for the Target field. You can filter the records further with Attributes corresponding to the selected Target type. It excludes the records by filtering out based on provided filter criteria and executes the matching rules on the filtered records. Note: It is an optional step.
Multiple filter criteria are allowed in the filter. How to add filter conditions is similar to the source filter. See Source Filter description.
Note: If you select the Target as any one of the following, then the only Country attribute is applicable in the Target Filters:- Panama
- Bahamas
- Paradise
- Offshore
- ICIJ- Paradise Address
- ICIJ- Panama Address
- ICIJ- Offshore Address
- ICIJ- Bahamas Address
Description The description of the Ruleset. ER Type The type of data that is to be matched. The values are as follows: - CSA_812
- CSA_8124
- CSA_8125
- CSA_8126
- CSA_8127
- CSA_8128
- Graph (This is applicable if any graphs that are available in the workspace. Graphs could be defined via Graph pipeline)
Note: It is recommended to use CSA_8128 pipeline with Compliance Studio 8128 and BD 8128 and the other pipelines are deprecated.
The lower version pipelines are supported only if you are upgrading to CS 8.1.2.8.0.
Auto Threshold The threshold value for a ruleset. This is cumulative of all the attribute values entered in the Rule for entity match. One stands for 100%.
Enter values from 0 to <=1. Enter a matching percentage above which you want the matches to get into the graph automatically.The threshold scoring logic works in the following way:- A total threshold score of less than 0.7 (70%) must be discarded.
- A total threshold score of more than or equal to 0.8 (80%) must create a similarity match automatically. This is configured using the Automatic Threshold in Ruleset.
Note: The Threshold value must be less than or equal to 1.
Manual Threshold Note: This is applicable only to Match Ruleset. Enter the threshold value for a ruleset. This is cumulative of all the attribute values entered in the Rule for entity match.
One stands for 100%.
Enter values from 0 to <=1. Enter a matching percentage above which you want the matches to get into the graph automatically.
The threshold scoring logic works in the following way:- A total threshold score of less than 0.7 (70%) must be discarded.
- The User must manually decide on a total threshold score between 0.7 (70%) and less than 0.8 (80%). This is configured using the Manual Threshold in the Ruleset.
Note: The Manual Threshold value must be less than the Auto Threshold.
- Click Save to save the Ruleset. You can save the Ruleset with or without creating Rules or click Cancel to cancel.