The Duplication Persons report lists the number of person customers that have duplicate records, categorized by number of duplicates. A bar chart shows the percentage of people that have no duplicates, percentage with one duplicate, and so on.
The report is created based on the following steps:
A concatenated string of organization name and associated identifying address is created. For a person record, a concatenated string of the first, middle, and last name plus the associated identifying address is created.
All records with similar sounding phonetic information are grouped and a count is determined to calculate how many Joe Smiths exist in the system (independent of whether they are captured as Joe or Joseph).
A table is then compiled with a frequency column (meaning the number of times a record is repeated) and a count column that shows how many parties are possible duplicates.