Mass Update Student Audit

CAMS allows you to perform mass audits for groups of students. For example, if an advisor wanted to perform an audit for all 50 of his advisees, he could do that through the Mass Update Audit. This process stores the audits in an evaluated state.

To perform a mass update audit:

From the CAMS Enterprise home page, click Tools >Processes >Registration Module >Mass Update Audit.
Select the appropriate criteria from the Mass Update Student Audit Criteria 1 tab.
On the Criteria 2 Mass Update - Get Students tab, click Initiate. CAMS generates a list of all students to update based on the selected criteria.
On the Process tab.
Check the Periodically Defrag Audit Tables checkbox to have CAMS automatically defragment the SQL audit tables’ indexes.
Set the number of Audits after which the audit tables’ indexes will be defragmented. This defaults to 50. CAMS will defrag the audit tables’ indexes at the beginning and after each number of audits as set in the Audits field. Check this option and set the number at 0 (zero) to defrag once at the beginning only.
Click Process. A new window opens displaying the progress of the Mass Update Student. You can minimize this window and continue to work in CAMS. If the update needs to be stopped for any reason, you can close this progress window with the “X” in the upper-right corner to halt the process.

Note: What to set the defrag option at depends on a number of factors. The defrag can help the process, but too many defrags can hurt the performance of this process. You can start with zero to have the audit tables’ indexes defragmented at the beginning of the process then, after running the process, determine if you should set it at a higher number such as 50, 100, or 200, etc. If your system is using SQL 2005 and your database administrator defragments the database indexes on a regular basis, you may not need to do it at all from this window. Unit4 Education Solutions, Inc. provides a defragment script which defragments all SQL indexes and can be set as a SQL job to run automatically on a periodic basis as determined by your database administrator.