How can I find and clean up duplicate client records in my WebCATS database, and prevent future duplicates from occurring?
Duplicate records negatively affect the integrity of your database. For example, for DLA-funded centers, duplicates can cause you to overstate your total number of initial counseling sessions on the DLA 1806 report. For SBA-funded centers reporting to EDMIS, duplicate client records are particularly troublesome because not only will you be overstating your client count and understating your extended engagement client count, but cleaning up duplicates is impossible for data that was submitted to EDMIS in prior fiscal years. There are other complications of duplicate records in addition to reporting complications. Duplicate records lead to confusion for your users (which client record should I be working with?). They also make it difficult to piece together a complete history of a client’s activity because information is spread across multiple client records instead of being available in one location. How do duplicate records get introduced into your database in the first place? Outreach
Related Questions
- AY Mail deletes all duplicates addresses automaticaly, how do I keep all the different records I have for duplicate addresses?
- How can I find and clean up duplicate client records in my WebCATS database, and prevent future duplicates from occurring?
- Are there any duplicate records in the corporations database?
