QueryPlus opens up a window into your AMS database that is perfect for ‘data-scrubbing’. Many AMS databases have missing or inaccurate data that is difficult to impossible to identify through the AMS interface. Some of this missing/inaccurate data has the potential to affect reports, and should be identified and corrected.

There are an almost unlimited number of possibilities for data scrubbing. Technical Bulletin 10, available in the QueryPlus Knowledge Base, is full of suggestions, tips and sample queries to get you started in this very useful endeavor.

Having viewed several AMS databases, the Daily Querier has a suggestion regarding data scrubbing: Don’t try to do it all yourself! Consider hiring a summer intern, or include the name of the CSR (Customer Account Rep Last/First Name) in the query and give each CSR the records he/she is responsible for.