Data Hygiene Queries

Neil Hunter

Hi Everyone I'm looking to improve the quality of the data we hold in RE and I run the queries to identify and pick up some errors in order to address the issues below: 1. Remove/fix all email addresses without @ in it 2. Remove/fix all email address without a

JoAnn Strommen

Neil Hunter:
Hi Everyone I'm looking to improve the quality of the data we hold in RE and I run the queries to identify and pick up some errors in order to address the issues below: 1. Remove/fix all email addresses without @ in it 2. Remove/fix all email address without a

Neil, here's a few others that I run, some not as often as others.

• 
  
  blank zip code
  
  
• 
  
  blank primary addressee/salutation
  
  
• 
  
  blank spouse add/sal
  
  
• 
  
  blank org contact add/sal
  
  
• 
  
  blank country (find that once in a while the default gets erased when entering data)
  
  
• 
  
  blank required attribute: source of record
  
  
• 
  
  no address marked for send mail but "no valid address" box is unchecked
  
  

For gifts,

• 
  
  blank gift constituency
  
  
• 
  
  gift receipt equals not receipted (should all be receipted or do not receipt for us)
  
  
• 
  
  blank gift code (gift code required for some funds)
  
  

There's a few others that are probably even more specific to our org.  Hopefully this gives you some ideas.

Gina Gerhard

JoAnn Strommen:

Neil, here's a few others that I run, some not as often as others.

• 
  
  blank zip code
  
  
• 
  
  blank primary addressee/salutation
  
  
• 
  
  blank spouse add/sal
  
  
• 
  
  blank org contact add/sal
  
  
• 
  
  blank country (find that once in a while the default gets erased when entering data)
  
  
• 
  
  blank required attribute: source of record
  
  
• 
  
  no address marked for send mail but "no valid address" box is unchecked
  
  

For gifts,

• 
  
  blank gift constituency
  
  
• 
  
  gift receipt equals not receipted (should all be receipted or do not receipt for us)
  
  
• 
  
  blank gift code (gift code required for some funds)
  
  

There's a few others that are probably even more specific to our org.  Hopefully this gives you some ideas.

There's a previous post entitled 'Best Practice for Database Cleansing' that has a lot of information as well. http://forums.blackbaud.com/forums/p/15375/151064.aspx#151064

Neil Hunter

Gina Gerhard:
There's a previous post entitled 'Best Practice for Database Cleansing' that has a lot of information as well. http://forums.blackbaud.com/forums/p/15375/151064.aspx#151064

Thank you both for your replies. These shall be a great help.