Run the Full Duplicate Constituent Search Process

You can run the full duplicate search process to compare and identify possible duplicate constituent records in your database. After you run a full search, you can reduce the time required for subsequent searches by running the incremental process, which compares only those records that were added or updated since the last search process was run. The first run of an incremental search process will take as long as the full search process.

Note: The search results include constituent records with updates to these personal information fields: Last name, First name, Middle name, Title, Suffix, Nickname, Maiden name, Martial status, Birth date, Gender, Social Security Number, Is inactive, Gives anonymously, Website, Image. Results also include constituents with updates to these contact information fields: Do not mail, Do not email, Do not phone, Primary address, Primary phone, and Primary email. At the database level, these are changes to the CONSTITUENT table and primary entries on the ADDRESS, PHONE, and EMAILADDRESS tables.

Tip: Has your organization upgraded to service pack 36 or higher? It enables you to use a code table of user-defined gender values. If you've upgraded, this new gender field is used instead of the old one for handling potential duplicate constituents.