Protect the Integrity of Your Database

Your Financial Edge database is the heart of your financial records.  It is very important to have sound policies and procedures prior to data entry as well as having the discipline to check the data periodically to ensure its integrity.  A list of procedures and rules can improve your data’s consistency and quality, and save you time and effort when entering data, preparing reports, and reconciling.

Creating a policies and procedures manual is important to ensure consistency in how you enter and maintain records and perform various functions related to your database.  By documenting rules and guidelines for data entry, organizations can ensure the consistency of their data. Consistent data entry is crucial to the accuracy and validity of reports, summaries, and queries and helps use features of The Financial Edge more efficiently. The manual can also be used as a training guide for new employees and volunteers and as a resource for handling infrequent tasks.

You should also periodically run database maintenance on your Financial Edge database.  A large part of the data maintenance is running the ‘Check Integrity’ utility.  You should run the utility as part of a system check before major changes, such as before a hardware or software upgrade, or after a hardware failure. We recommend you check data integrity weekly if you suspect any problems with the system.

  1. Open the Blackbaud Management Console (Blackbaud Management Console)
  2. Select the appropriate database
  3. Click Maintenance
  4. Click Check Integrity

Utilizing a policies and procedure manual as well as running data integrity checks on your database periodically are great ways to ensure that your database is consistent, accurate and efficient.

You can keep up with us on Twitter by following @bbsupport; we use the hashtag #bbfe when we discuss The Financial Edge. Take a look at our Twitter Guide for more info.




Comments are closed.