Best of CASE District III Award
 

Institution: Florida International University

Title of entry: Streamlining Data Audits and Data Integrity at the FIU Foundation

About this entry: We are currently using Blackbaud Raiser’s Edge NXT as our CRM. To maintain data integrity and make sure that data coming into our system meets our set business rules and data entry standards, we used to run manually several queries plus another system tool (RE Queue) that would run multiple queries on a scheduled time. We had a total of 100 queries that would output the data inconsistencies to later be corrected. This tool serves to automate this process and consists of several stored procedures created in SQL that run multiple queries and returns data that is not aligned with specific business rules. The reports runs daily and when inconsistent data is found it allows for the operator to drill down on the granular data to be corrected.