PR560 – Payroll History Load CSV
- System
- Payroll (PR)
- Type
- Batch program
- Updates
- 57 tables
- References
- 78 tables
PR560 (Payroll History Load CSV) is a Lawson Payroll batch program. It updates ACCOMMIT, ACCOMMITX, ADDRDATA, C6EMDDMSTR, C6EMPADDRT, C6PRDDTL, CKPOINT, CMASSIGN and 49 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ATTENDCODE, BANKFILE and 70 more.
About PR560
Run Payroll History Load CSV (PR560) to create payroll history records in the Payroll system. IMPORTANT The input file, HSTLOADCSV, must be SORTED prior to running PR560. If it is not sorted, unpredictable results and data corruption are possible. HSTLOADCSV must be sorted by: HL-COMPANY HL-EMPLOYEE HL-CHECK-ID HL-PROCESS-LEVEL HL-DEPARTMENT **Processing Effect PR560 reads the contents of a previously created comma separated value (CSV) file (HSTLOADCSV). Any history record that does not pass cleanly through edits is written to a CSV file called HSTOUTCSV and does not create a record in the database. Errors are printed on an edit report so you can makecorrections. History records that are created are also listed on the report unless "Bypass report" is entered as "Yes". Select No in the Update field, to run the program for edit purposes. Select Yes in the Update field to update the database. A re-run option is also available. When you re-run the program against the original input, history for each employee included in the input file is deleted and reconstructed. Select No in the Rerun field so that existing data is not purged and the contents of the HSTLOADCSV file is added to the existing data. Each record in this file represents a deduction or pay record for an employee for a specified year, quarter, payment ID, tax state, process level, and department, if applicable. PR560 jobs may be run concurrently, each having its own input and output files. For best results, all records for a specific employee must be run in the same job. The HL-CHECK-ID (payment ID) field is required and the HL-CHECK-NBR (payment number) field is optional but will default from the HL-CHECK-ID.
Updated files (57)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ADDRDATA | Address Code | IF |
| C6EMDDMSTR | No description in the Lawson data dictionary | C6 |
| C6EMPADDRT | No description in the Lawson data dictionary | C6 |
| C6PRDDTL | No description in the Lawson data dictionary | C6 |
| CKPOINT | No description in the Lawson data dictionary | — |
| CMASSIGN | No description in the Lawson data dictionary | CW |
| CMPAYCYC | No description in the Lawson data dictionary | CW |
| CWASSIGN | No description in the Lawson data dictionary | CW |
| EMACHDEPST | Employee ACH Account | PR |
| EMDEDMASTR | Employee Deduction | PR |
| EMPACHDIST | Employee ACH Distribution | PR |
| EMPLOYEE | Employee | HR |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| HRHISTORY | HR History | HR |
| LPPENDREQ | No description in the Lawson data dictionary | LP |
| PAEMPPOS | Employee Multiple Pos, Jobs | HR |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PAYMASTR | Employee Payment Master | PR |
| PR1099RHST | No description in the Lawson data dictionary | PR |
| PR1099RSLH | No description in the Lawson data dictionary | PR |
| PRBATCH | Payroll Time Record Batch Head | PR |
| PRCHECK | Employee Payment | PR |
| PREMDEDHST | Employee Deduction History | PR |
| PREMPBANK | No description in the Lawson data dictionary | PR |
| PRMONITOR | No description in the Lawson data dictionary | PR |
| PRPAYCODE | Pay Code | PR |
| PRPENFSRC | No description in the Lawson data dictionary | PR |
| PRPENFSRCH | No description in the Lawson data dictionary | PR |
| PRPENHIST | No description in the Lawson data dictionary | PR |
| PRPENPAY | No description in the Lawson data dictionary | PR |
| PRRATEHIST | Employee Rate History | HR |
| PRREGPARM | No description in the Lawson data dictionary | PR |
| PRSHIFTHDR | Contains the shift table code definitions. | PR |
| PRSYSTEM | HR Company and Process Levels | HR |
| PRTAXLOC | No description in the Lawson data dictionary | PR |
| PRTIME | Employee Pay/Hours History | PR |
| QUARTDED | Quarterly Deduction | PR |
| QUARTWAGE | Quarterly Wage | PR |
| STANDTIME | Payroll Standard Time Record | PR |
| SUBCKPOINT | Subledger Check Point | IF |
| TAEEMASTER | Employee Absence Plan | LP |
| TAEMPSERV | Employee LP Service Record | LP |
| TAENROLL | No description in the Lawson data dictionary | LP |
| TAPAYROLL | Absence Plan Payroll Rule | LP |
| TASTRUCTUR | Absence Plan Structure | LP |
| TIMERECORD | Employee Time Records | PR |
| TIPPAY | Employee Tip Pay | PR |
| TRSGBLCK | This file contains segment block data for employee time records. | PR |
Referenced files (78)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ATTENDCODE | Attendance Code | TM |
| BANKFILE | Bank Code | PR |
| C6BANKM | No description in the Lawson data dictionary | C6 |
| C6EMPADDRT | No description in the Lawson data dictionary | C6 |
| C6PRDDEF | No description in the Lawson data dictionary | C6 |
| C6PRDDTL | No description in the Lawson data dictionary | C6 |
| C6STATE | No description in the Lawson data dictionary | C6 |
| C6TAXGRP | No description in the Lawson data dictionary | C6 |
| CMASSIGN | No description in the Lawson data dictionary | CW |
| CMCONTRACT | No description in the Lawson data dictionary | CW |
| CMCONTRULE | No description in the Lawson data dictionary | CW |
| CMPAYCYC | No description in the Lawson data dictionary | CW |
| CWASSIGN | No description in the Lawson data dictionary | CW |
| CWCONTRACT | Contracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay… | CW |
| CWCONTRULE | No description in the Lawson data dictionary | CW |
| DEDCODE | Deduction | PR |
| DEPTCODE | Department | HR |
| DEPTSEGBLK | Department Segment Block | HR |
| EMDISTMAST | Emp Acct Distribution Override | PR |
| EMSTATUS | Employee/Applicant Status | HR |
| FBFUNDDTL | Budget Fund Detail | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| HRHISTORY | HR History | HR |
| HRSECLEV | Employee Security Level | HR |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JOBCODE | Job Code Parameters | HR |
| LPLINK | LP Link Plan Table | LP |
| ONETMDED | Payroll One-time Deduction | PR |
| PADICT | HR Systems Data Dictionary | HR |
| PAEMPLOYEE | Employee Personnel Information | HR |
| PAEMPPOS | Employee Multiple Pos, Jobs | HR |
| PAPOSITION | Positions | PA |
| PAPOSRULE | Position Rules | PA |
| PASCRTY | Data Item Attribute Parameters | HR |
| PAYSUMGRP | Pay Summary Groups | PR |
| PCODES | Human Resource Code | HR |
| PCODESDTL | Contains contact information detail (address and phone number) for specific types of PCODES. | HR |
| PERSACTION | Personnel Action | PA |
| PERSGROUP | Employee Group Header | HR |
| PLAN | PL Group Detail | BN |
| PRBUSGRP | No description in the Lawson data dictionary | PR |
| PREMPGARN | Used to store information to identify a particular garnishment per employee per company. | PR |
| PRFUNDSRC | No description in the Lawson data dictionary | PR |
| PROVERTIME | Overtime Pay Plan | PR |
| PRPROVINCE | This file contains province codes and descriptions. | PR |
| PRQCENTGRP | No description in the Lawson data dictionary | PR |
| PRRATEHIST | Employee Rate History | HR |
| PRRATES | Alternate Pay Rates | PR |
| PRSAGDTL | Step & Grade Schedule Detail | HR |
| PRSAGHEAD | Step & Grade Schedule Header | HR |
| PRSHIFTHDR | Contains the shift table code definitions. | PR |
| PRSHIFTTBL | This detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule… | PR |
| PRSTATE | States | PR |
| PRTAXAUTH | Tax Authority | PR |
| PRTAXLEVY | Payroll Tax Levy | PR |
| PSGRELATE | Pay Class/Pay Sum Grp Relation | HR |
| SYSTEMCODE | System Code | IF |
| TAEEMASTER | Employee Absence Plan | LP |
| TAENROLL | No description in the Lawson data dictionary | LP |
| TAPAYROLL | Absence Plan Payroll Rule | LP |
| TAPLAN | Absence Plan | LP |
| TAREASCODE | Absence Plan Reason Code | LP |
| TASERVCODE | Absence Plan Service Code | LP |
| TASERVICE | Service Class & Code Relations | LP |
| TASTRUCTUR | Absence Plan Structure | LP |
| TAXGROUP | Payroll Tax Reporting Group | PR |
| WCCLASSOVR | No description in the Lawson data dictionary | PR |
Program calls
Invoked programs (17)
ACAC, ACTA, API4, HRHI, HRLO, HRST, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, PREN, SLSE, SLSS, SLSU