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

Payroll Considerations - File Relationships

Datafile Software

Payroll Considerations - File Relationships

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.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Report Birthdays on Payroll Run
Viewed 2252 times since Fri, Jun 8, 2012
Payroll - Options for File Access and Application Security
Viewed 3484 times since Tue, Sep 22, 2020
Compact & Audit Database
Viewed 2817 times since Wed, Mar 27, 2013
Pension Auto-Enrolment
Viewed 4464 times since Wed, Mar 27, 2013
Cheque Design - Document Design Manager
Viewed 2377 times since Wed, Mar 27, 2013
Extra File Scans
Viewed 4521 times since Tue, Mar 26, 2013
Special Facilities
Viewed 2218 times since Wed, Mar 27, 2013
XML Submissions to the HMRC
Viewed 2440 times since Tue, Jun 12, 2012
Employee Optional 8/11
Viewed 2085 times since Wed, Mar 27, 2013
Period End / Start Next Period
Viewed 2209 times since Tue, Mar 26, 2013