In this table all duplicates will be listed.

SELECT * FROM moving_appcustomer_900000.servicedmcore_core_identity_detected_duplicate;

All the Attributes of the duplicates will be listed in this table.

SELECT * FROM moving_appcustomer_900000.servicedmcore_core_identity_detected_duplicate_attribute;

In the detection_rule table you can decide how many attributes need to match and of which coreidentity_type.

SELECT * FROM moving_appcustomer_900000.servicedmcore_core_identity_type_duplicate_detection_rule;

The entries of the detection_rule table can be specified in this table. The detection_threshold specifies how my percet need to match.

SELECT * FROM moving_appcustomer_900000.servicedmcore_core_identity_type_duplicate_detection_rule_entry;

The detection_type determines how the checks are performed.

• Equals = Needs to match exactly

• Phonetic = Matches if it sounds alike (e.g. Meier and Meyer)

SELECT * FROM moving_appcustomer_900000.servicedmcore_duplicate_detection_type;

The Duplicate-Check has to be activated in the Settings.

• Module.DM.IdentityManagement.Setting.EnableCoreIdentityDuplicateCheck

• In the Table setting_setting_value, set the ‘bool_value’ to 1

SELECT * FROM moving_appcustomer_900000.setting_setting;

SELECT * FROM moving_appcustomer_900000.setting_setting_value;