Build the rule condition

Build conditions for this rule as follows:

  1. On the Conditions tab, click Add/Edit Rule Conditions to build the rule conditions. A pop-up window is displayed with the Select Objects tab open by default.
  2. On the Select Objects tab , select the primary object. This is the object on which the exception count will be based. Only one primary object may be selected for a rule. For this rule, the primary object would be 'Vendor Master'.
  3. Select the other objects that will participate in the rule condition. For this rule, the other object would be 'OFAC Name'.
  4. Click the Build Conditions tab. You may want to build your rule with just one group or multiple groups. A group is a set of conditions. Each group can have one or more conditions separated by an operator. Two or more groups are separated using the operator AND or OR. During analysis, all the conditions in the first group are evaluated sequentially and then the conditions in the second group depending on the operator.
  5. Under Value Set 1 click Select Value.  Use the autosuggest box or browse for the tables and fields required.
  6. For this rule, select the table Vendor Master.
  7. Select the field Vendor Name 1.
  8. Right click Select operator and select Fuzzy matches.
  9. Under Value Set 2, click Select Value.  Use the autosuggest box or browse for the tables and fields required.
  10. For this rule, select the table OFAC Name.
  11. Select the field Name 1.
  12. Right click on Condition 1 and click Add Condition. The second condition gets added with the operator AND. Right Click the operator AND to change it to operator OR.

    Similarly add values and operators  for other conditions in the rule as explained in the table below:

    Condition Number Value Set 1 Operator Value Set 2
    Condition 2 Vendor Master ~ Vendor Name 1 Fuzzy matches OFAC Name ~ Name 2
    Condition 3 Vendor Master ~ Vendor Name 1 Fuzzy matches OFAC Name ~ OFAC AKA Name Reference ~ First Name
    Condition 4 Vendor Master ~ Vendor Name 1 Fuzzy matches OFAC Name ~ OFAC AKA Name Reference ~ Last Name
    Condition 5 Vendor Master ~ Vendor Name 2 Fuzzy matches OFAC Name ~ Name 1
    Condition 6 Vendor Master ~ Vendor Name 2 Fuzzy matches OFAC Name ~ Name 2
    Condition 7 Vendor Master ~ Vendor Name 2 Fuzzy matches OFAC Name ~ OFAC AKA Name Reference ~ First Name
    Condition 8 Vendor Master ~ Vendor Name 2 Fuzzy matches OFAC Name ~ OFAC AKA Name Reference ~ Last Name
  13. Right click on Condition 8 and click Add Condition. The next condition gets added with the operator AND. Add another group of conditions with the operator AND as in the table below:
    Condition Number Value Set 1 Operator Value Set 2
    Condition 1 Vendor Master ~ Vendor Name 1 Is none of

    NULL

    EMPTY

    Condition 2 Vendor Master ~ Vendor Name 2 Is none of

    NULL

    EMPTY

  14. Click Save.

    When data is analyzed using this rule, all names that are similar to OFAC SDN listed names are displayed as exceptions.