The main files of the payroll system are the employee files – the employee files are split over (up to) five databases, the record number in each relating to the same employee. As part of the payroll run information is accumulated up to the department file and from there to the nominal ledger. Also as part of the payroll run a transaction with the period pay values is written to the P11 database and the, Premier only, transaction file.
ProFiler Reporting
If you design ProFiler reports then you can report from all the employee databases by defining a ‘lookup’ relationship from the main employee file to the other employee files.You would leave the lookup item as ‘0’ to indicate it’s to link on the equivalent record number.
Article ID: 1950
Created On: Tue, Mar 26, 2013 at 11:21 AM
Last Updated On: Fri, Jun 16, 2023 at 5:19 PM
Online URL: https://kb.datafile.co.uk/article/payroll-considerations-file-relationships-1950.html