Procedure for preparing for effective rates

1. Back up the PayGlobal database that you want to check.

   You should always take a backup of your database before you run any major database processes.

2. Navigate to the Integrity Checker application.
3. Double-click IntegrityChecker.exe.

   The Select a PayGlobal database page appears.

4. Select the required database from the Choose a company database combo list, which displays all of the companies in the Hr.ini file.

   Click Next.

   The Select the tables page appears.

   The first time that you run the Integrity Checker, you should select all tables and all rules to ensure that all of your data is checked.

   

5. Ensure that all tables are selected.
6. Click Next.

   The Select the rules page appears.

   

7. Ensure that the Date range order and Rate overlaps rules are ticked (see Rules).
8. Click Next.

   The Begin integrity checking page appears.

9. Click Start.

   A two-stage progress bar and status messages are displayed while the tables are checked by each rule. You can click the Cancel button to cancel the process, which allows the rule that is currently running to complete before the integrity check is terminated. If you cancel the process, then any changes that have already been made to the database are not rolled back.

   The Displaying database integrity check results page appears, which displays a summarised list of violations.

   The following example shows one error, but your database may have many integrity errors.

   

   To view more information about the integrity check, click the View audit log button.

   The audit log shows which tables and records have problems, which rules were violated, and the errors that were corrected. The audit log is saved in the selected company's Log folder and has the prefix "Database_Integrity_Check".

10. Click Finish.

    Important: Any errors that the integrity checker finds should be fixed before you turn on effective rates functionality.
    If the integrity checker finds errors that you cannot correct, then contact Customer Support who may need to book a consultant to fix the errors in your database for you.

Topic: 43109