PR582 – Mass Adjustment Load
- System
- Payroll (PR)
- Type
- Batch program
- Updates
- 61 tables
- References
- 89 tables
PR582 (Mass Adjustment Load) is a Lawson Payroll batch program. It updates ACCOMMIT, ACCOMMITX, ADDRDATA, ATTENDHIST, C6EMDDMSTR, C6EMPADDRT, CKPOINT, CMASSIGN and 53 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ATTENDCODE, BANKACCT and 81 more.
About PR582
Run Mass Adjustment Load (PR582) to load new adjustment records using a CSVfile in the Payroll system. The program is also used to delete existing adjustment records. IMPORTANT The input file, ADJLOAD, must be sorted according to Company,Employee, Group-ID, and Record Type prior to running PR582. **Processing Effect You can run Payroll Register (PR141) to view adjustment records that werecreated using different criteria after running PR582 in Update mode. The adjustment records for earnings or deductions are created via the comma separated values (CSV) file (ADJLOAD). Run Payroll Close (PR197) to close the adjustment records and update thehistory files like the QTD, QTW, etc. The system creates ADJERROR, the CSV file that holds all records thatencountered errors while processing. This file is located at $LAWDIR/print/username/jobname/1. The system also creates ADJDELETE, located at$LAWDIR/print/username/jobname/1. This is the CSV file that holds all records that were deleted. This file can be reloaded, if necessary.
More information: The CSV file that you provide must have a Header record even if the rest ofthe fields within the header are left blank. There must also be a record for at least one of the record types (Earnings, Deduction, Pension Funding, or Pension Distribution). There can only be one pension distribution record type per employee and Group-ID, but there may be more than one record for the rest of the record types. If more than one earnings record type is provided for the Group-IDadjustment, the pay code must be unique on each record. If more than one deduction record type is provided for the Group-IDadjustment, the deduction code must be unique on each record. If more than one pending funding source record type is provided for theGroup-ID adjustment, the pending funding source code must be unique on each record. If you want to perform updates on loaded records, use Adjustment (PR82).Alternatively use Mass Adjustment Load (PR582) to delete the adjustment records, correct the data and reload the adjustments using PR582.
Updated files (61)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ADDRDATA | Address Code | IF |
| ATTENDHIST | Employee Attendance History | TM |
| C6EMDDMSTR | No description in the Lawson data dictionary | C6 |
| C6EMPADDRT | 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 |
| 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 |
| GMLABDISTX | Grant Labor Distribution Dtl | GM |
| 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 |
| PRDEDDTL | No description in the Lawson data dictionary | PR |
| PRDISTRIB | Employee Payment Distribution | PR |
| PREMDEDHST | Employee Deduction History | PR |
| PREMPBANK | No description in the Lawson data dictionary | PR |
| PREMPGARN | Used to store information to identify a particular garnishment per employee per company. | PR |
| PRGARNHIST | Contains the history for a particular garnishment (case number and file number). | 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 |
| TPPARAM | Tip Parameters | TP |
| TRSGBLCK | This file contains segment block data for employee time records. | PR |
Referenced files (89)
| 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 |
| BANKACCT | Bank Account | PR |
| 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 |
| 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 |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| 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 |
| EMPACHDIST | Employee ACH Distribution | 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 |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GMCONTROL | No description in the Lawson data dictionary | GM |
| GMLABDIST | Grant Labor Distribution | GM |
| GMLABDISTX | Grant Labor Distribution Dtl | GM |
| 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 |
| PGEMPLOYEE | Employee Group Employees | HR |
| PLAN | PL Group Detail | BN |
| PRBUSGRP | No description in the Lawson data dictionary | PR |
| PRCHECK | Employee Payment | PR |
| PRDEDACCTS | No description in the Lawson data dictionary | PR |
| PRFUNDSRC | No description in the Lawson data dictionary | PR |
| PROTACCTS | This file contains expense accounts for premium portions of pay by job codes. | PR |
| PROTPAYPRD | Overtime Pay Periods | PR |
| PROVERTIME | Overtime Pay Plan | PR |
| PRPROCGRP | Payroll Process Group | HR |
| 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