The Catch-All Cleanup Tool

The Catch-All tool cleans up various records including duplicate registrations, name records with duplicate ID values, duplicate UDF records, duplicate workshop records, and duplicate Cost Center code records. It also creates missing UDF records and missing instructor pay records, and creates missing links between course and location.

To run the Catch-All tool:

  1. Select Tools > Data Cleanup > The Catch-All, Registration, Name (IDs Only), Cost Center Codes, Missing Course/Instructor Links, & UDF.
  2. You will be asked to confirm the cleanup option. Click the Yes button.
  3. The system will run the cleanup procedures then report how many records were marked for deletion.

  1. Click OK to close the window.

Note: duplicates are only marked for deletion. You must run the Pack procedure to remove them from the database.

 

Related Topics Link IconRelated Topics