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
LEAVE – Mark Employees as Leavers
Viewed 1250 times since Tue, Mar 26, 2013
Payroll - Options for File Access and Application Security
Viewed 3048 times since Tue, Sep 22, 2020
Submit P45 On-Line
Viewed 3049 times since Wed, Jun 13, 2012
Calendar
Viewed 1730 times since Tue, Mar 26, 2013
Enquiries Configuration
Viewed 1720 times since Tue, Mar 26, 2013
Adjust Basic Pay by Statutory Payment Values
Viewed 4178 times since Mon, Jun 11, 2012
Payments and Deduction Table
Viewed 2220 times since Tue, Mar 26, 2013
Department Analysis Headings
Viewed 1706 times since Tue, Mar 26, 2013
Database INI Settings
Viewed 3560 times since Tue, Mar 26, 2013
Appendix - End of Year Returns
Viewed 3766 times since Wed, Mar 27, 2013