Home » Categories » Solutions by Business Process » Finance » Payroll

Compact & Audit Database

Datafile Software

Compact & Audit Database


The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted. New records are always added to the end of the file. Therefore, over a period of time, it is possible a file may appear full but there could be gaps in the middle where records were deleted. Using this option consolidates the active data and frees up space.

With payroll systems the record number of the employee is used as their employee number so, in the normal course of events, you would never compact the file. If you do so then you must ensure you only do this immediately after the year-end – never during the tax year. You should also note that you will lose document history (i.e. payslip reprint) as the documents link on the employee number – if you compact the file you should also clear the documents file using the options above.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Special 161+ Print Items
Viewed 5992 times since Wed, Mar 27, 2013
Employee Optional 6/11
Viewed 1472 times since Wed, Mar 27, 2013
Payroll Considerations - Payroll "Switches"
Viewed 1674 times since Tue, Mar 26, 2013
Maintain Employee File
Viewed 17095 times since Wed, Mar 27, 2013
Link to Company Constants Extra Payroll Data Items
Viewed 1602 times since Fri, May 27, 2016
Copy EMP to TX (1/4) - Copy EMP to TX (2/4) - Copy EMP to TX (3/4) - Copy EMP to TX (4/4)
Viewed 1645 times since Wed, Mar 27, 2013
Year End Procedures
Viewed 1634 times since Tue, Mar 26, 2013
Employee Optional 3/11
Viewed 1541 times since Wed, Mar 27, 2013
Employee Details
Viewed 1614 times since Tue, Mar 26, 2013
Submit P45 On-Line
Viewed 2851 times since Wed, Jun 13, 2012