Summary

Important: Before you run the Manage Tables command, you must turn off Referential Integrity. If Referential Integrity is not turned off, then PayGlobal cannot remove any records that are referenced. After you run the Manage Tables command, you should run the Check Database Integrity command.

Data is responsible for more than 90% of the database size. You can significantly reduce the size of your database by regularly purging data that you no longer use. Purging will reduce the time required to:

• Back up data
• Reindex data
• Access data - This improvement would be small because PayGlobal minimises the data that needs to be accessed to accomplish a particular task.

For example, you could purge actual allowance transactions that were more than 90 days old because PayGlobal would refer to payroll history in an award interpretation for the current period or for general queries.

Similarly, if your database contained a large number of clock transactions, then you should regularly purge the clock transaction table as part of your scheduled maintenance programme.

What can you purge?

You can purge the following types of data:

• Audit log
• Budget Centre Transactions
• Employee History
• Payroll Transaction Audit Log
• Payroll Transactions
• Roster Timebands
• Roster Transactions
• Roster Scenario Timebands
• Roster Scenario Transactions
• Clock Transactions
• T&A Timebands
• T&A Transactions
• Terminated Employee Leave Credit History
• Terminated Employee History
• Terminated Employee UDF History

You can purge by:

• Date range

  - or -

• Pay sequence

• For the Terminated Employee Leave Credit History, Terminated Employee History and Terminated Employee UDF History commands, only data for terminated employees for pays after their termination will be selected for deletion.

Note: If you purge Payroll Transactions, then you cannot purge data with a pay sequence record in the current tax year (YTD).

Procedure

To purge data:

1. Double-click the Manage Tables command.
2. In the main menu of the Manage tables window, select Tools | Purge, and then your data type, such as Auditlog.
3. Select a date range or pay sequence and click OK.
4. A warning message appears so click OK to continue the purge or click Cancel to stop it.

After you purge data, you should run Reindex and Pack to reduce table size. PayGlobal can purge only data that is older than ninety days.

See also

Regular Maintenance of PayGlobal

Maintain Backups - Deleting Backups

Maintain Log Files

Manage Tables