| Home » Categories » Solutions by Business Process » Finance » Payroll |
Payroll Considerations - File Relationships |
|
Article Number: 1950 | Rating: Unrated | Last Updated: Fri, Jun 16, 2023 at 5:19 PM
|
|
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. |
Attachments
There are no attachments for this article.
|
Related Articles 
Payroll Extra - Payroll Check Spreadsheet
Viewed 5006 times since Mon, Nov 25, 2013
Employee Optional 9/11
Viewed 1820 times since Wed, Mar 27, 2013
Employee-2 File Database Structure
Viewed 2436 times since Wed, Mar 27, 2013
Payroll Profile
Viewed 3200 times since Tue, Mar 26, 2013
Benefits in Kind / Company Cars
Viewed 1665 times since Mon, Jun 26, 2017
OTHER – Extra Amendment Screens
Viewed 1623 times since Tue, Mar 26, 2013
Compact & Audit Database
Viewed 2575 times since Wed, Mar 27, 2013
Mark Employee as Leaver / Print P45
Viewed 1886 times since Tue, Mar 26, 2013
NI – Update the Employee National Insurance Category
Viewed 1260 times since Tue, Mar 26, 2013
NI Verification Request (NVR)
Viewed 10635 times since Tue, Mar 26, 2013
|
| Datafile Home | KB Home | Advanced Search |
|
 |
|
|
|
|
|
|
Print Article
Email Article to Friend