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
Timesheets
Viewed 1778 times since Tue, Mar 26, 2013
Payslips – Conditional Text Labels
Viewed 22 times since Thu, Jan 2, 2025
Include Statutory Payments in Gross Pay
Viewed 5950 times since Mon, Jun 11, 2012
Department Analysis Headings
Viewed 1799 times since Tue, Mar 26, 2013
Additional Lookups for Maintain Employee
Viewed 117 times since Wed, Oct 16, 2024
Memo Facility Configuration
Viewed 4140 times since Tue, Mar 26, 2013
Pre-Payroll Check Report
Viewed 1994 times since Wed, Mar 27, 2013
Reports – Remember Report Sequence
Viewed 31 times since Thu, Jan 2, 2025
Payroll Considerations - Statutory Payments
Viewed 1850 times since Tue, Mar 26, 2013
What is the DPS Secure Mailbox?
Viewed 2361 times since Tue, Mar 26, 2013