bulletin














Protect Your Credibility

Maintaining the integrity of your Elite database is a mission critical responsibility. A loss or absence of data integrity can cost your firm time and money and can damage your accounting department's credibility. Many firms assume if their system is up and no error messages are being encountered, the database is fine. Unfortunately, this isn't always true.

What could go wrong?

Database integrity can be compromised by a number of contributing factors. Among these are:

- Data Conversion Shortcuts
- Application Software Bugs
- Direct Altering of the Database via SQL tools
- Mismatched software versions
- Botched Upgrades
- Rogue Custom Programs

Get an Elite Checkup

The key to protecting your data against software bugs or human error is to do a thorough check of the integrity of your Elite system at least once a year. An annual data integrity audit is the only way you can be sure that the information in your reports and inquiry system is accurate. Elite provides utilities and tools to assist you in performing this task, but interpreting the results and fixing the errors can require experience and skill.

If you are unfamiliar with the integrity utilities, or would prefer to outsource the audit, Data Fusion can help. Data Fusion's personnel have the expertise to perform a thorough analysis of your data integrity, identify and document all errors found, and implement corrective measures where appropriate. We will also provide you with the information and tools you need to maintain your system integrity going forward.

We Check Everything

Our database integrity audit includes:

- Checktab program run on all tables.
- Data Fusion advanced integrity SQLs run on all tables.
- Balancing SQLs are provided and applied to the last full period of data.
- Balancing SQLs are tailored to match your system parameters and are setup for monthly execution.
- A daily integrity check script is created to provide immediate warning of a reoccurrence of problems identified by the initial system check.
- Correction of all errors that require back-end updates.
- Detailed documentation of all corrections and updates.

Keeping it clean

At the conclusion of the audit, we meet with you and your key staff members to review our findings and give you a detailed daily, weekly and monthly plan to maintain integrity going forward.