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
Special Facilities
Viewed 2002 times since Wed, Mar 27, 2013
Expand Data Files
Viewed 3039 times since Wed, Mar 27, 2013
SWITCHES - Payments, Deductions and Repayments
Viewed 1872 times since Tue, Mar 26, 2013
Employee-3 File Database Structure
Viewed 1938 times since Wed, Mar 27, 2013
Payroll Extra
Viewed 1778 times since Mon, Nov 25, 2013
Edit System Status Display
Viewed 1828 times since Wed, Mar 27, 2013
Payroll Considerations - Using the Payroll
Viewed 2820 times since Tue, Mar 26, 2013
Employee Details
Viewed 1927 times since Tue, Mar 26, 2013
Employee Mandatory 4/4
Viewed 1824 times since Wed, Mar 27, 2013
Employee File – Item Screen Design
Viewed 1112 times since Tue, Mar 26, 2013