Chapter 37: Human Resources Table Maintenance.........................
Human Resources is designed to ensure maximum accuracy and integrity
of your Human Resources data. Occasionally, however, your data tables
might become damaged. Hardware failures, power surges and other
problems can affect your data by damaging or destroying it. While damage
occurs infrequently, the factors that cause it are difficult to predict or
control, and it’s necessary to take measures to protect your data. The
procedures described in this chapter will help you minimize risk of damage
to your data and to quickly recover your data from damage if it occurs.
Regularly back up your Human Resources data to minimize risk of data
loss from table damage. If you’re using a c-tree Plus or Pervasive.SQL
database, you can also rebuild your tables.
If you added Human Resources to your Payroll system, you’ll need to
reconcile information so it appears in both Human Resources and Payroll.
For instance, if you defined benefits or deductions in Payroll, you’ll need to
reconcile the benefits or deductions so they appear in Human Resources.
Always back up your data before you shrink any table. If processing is interrupted.
You can use the backup torestore your data to its original condition.
This information is divided into the following sections:
- Shrinking a Human Resources table
- Reconciling Human Resources information
- Classifying benefit and deduction codes
Shrinking a Human Resources table
If you’re using a c-tree Plus or Pervasive.SQL database, use the Human
Resources File Maintenance window to shrink tables and remove unused
space from tables, ensuring that the maximum amount of space is available
on your hard disk or network drive.
Do not use this procedure if you’re using a Microsoft SQL Server database.
Tables sometimes contain unused space and regularly shrinking them will
ensure that you always have as much space available as possible on your
hard disk or network drive. Shrinking copies a table, removes any unused
