The quality control module is a program which allows a user to create queries which will run on a
scheduled basis and send an email for each record that matches the search criteria. The system takes
advantage of the iMIS database schema by using the updated by fields which get modified when an iMIS
user modifies the data in a field. The user has the option to setup the query so the email message
goes to a static address or to the person who last updated the record. Associations use this
technology to find records in their iMIS database that have missing or incorrect data.
The system works by creating stored procedures in your SQL server or MSDE database. In addition, SQL
jobs are created and scheduled to run at the intervals that you specify.
Many associations find they have a number of records that don’t meet their data standards.
Therefore, we recommend you start out slowly with the association and don’t overwhelm the users.
You will achieve a higher level of acceptance if you start with one or two quality controls and limit
the number of records that are emailed out to staff. The system will allow you to specify a maximum
number of records to be reported.