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
Employee National Insurance
Viewed 2031 times since Tue, Mar 26, 2013
Check for Active Submissions
Viewed 2048 times since Tue, Mar 26, 2013
Adjust Basic Pay by Statutory Payment Values
Viewed 4394 times since Mon, Jun 11, 2012
Overtime Rate Table
Viewed 2158 times since Tue, Mar 26, 2013
Database Audit
Viewed 2166 times since Wed, Mar 27, 2013
Employee Optional 11/11
Viewed 2058 times since Wed, Mar 27, 2013
Benefits in Kind / Company Cars
Viewed 1900 times since Mon, Jun 26, 2017
Payroll - Furloughing Employees
Viewed 2334 times since Wed, Apr 15, 2020
Improvements to Employee Maintenance and Payroll Input
Viewed 2108 times since Wed, Jun 13, 2012
Submit P45 On-Line
Viewed 3408 times since Wed, Jun 13, 2012