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)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ADDRDATAAddress CodeIF
ATTENDHISTEmployee Attendance HistoryTM
C6EMDDMSTRNo description in the Lawson data dictionaryC6
C6EMPADDRTNo description in the Lawson data dictionaryC6
CKPOINTNo description in the Lawson data dictionary
CMASSIGNNo description in the Lawson data dictionaryCW
CMPAYCYCNo description in the Lawson data dictionaryCW
CWASSIGNNo description in the Lawson data dictionaryCW
EMACHDEPSTEmployee ACH AccountPR
EMDEDMASTREmployee DeductionPR
EMPLOYEEEmployeeHR
FBDETAILBudget DetailGL
FBFUNDAMTBudget Fund BalanceGL
FBTRANSBudget TransactionsGL
FBYETRNo description in the Lawson data dictionaryGL
GLCOMMITGL CommitmentsGL
GLCOMMITXGL commitment DetailGL
GLHISCOMBLNo description in the Lawson data dictionaryGL
GLHISCOMXNo description in the Lawson data dictionaryGL
GMLABDISTXGrant Labor Distribution DtlGM
HRHISTORYHR HistoryHR
LPPENDREQNo description in the Lawson data dictionaryLP
PAEMPPOSEmployee Multiple Pos, JobsHR
PAYDEDUCTNEmployee Payment DeductionsPR
PAYMASTREmployee Payment MasterPR
PR1099RHSTNo description in the Lawson data dictionaryPR
PR1099RSLHNo description in the Lawson data dictionaryPR
PRBATCHPayroll Time Record Batch HeadPR
PRDEDDTLNo description in the Lawson data dictionaryPR
PRDISTRIBEmployee Payment DistributionPR
PREMDEDHSTEmployee Deduction HistoryPR
PREMPBANKNo description in the Lawson data dictionaryPR
PREMPGARNUsed to store information to identify a particular garnishment per employee per company.PR
PRGARNHISTContains the history for a particular garnishment (case number and file number).PR
PRMONITORNo description in the Lawson data dictionaryPR
PRPAYCODEPay CodePR
PRPENFSRCNo description in the Lawson data dictionaryPR
PRPENFSRCHNo description in the Lawson data dictionaryPR
PRPENHISTNo description in the Lawson data dictionaryPR
PRPENPAYNo description in the Lawson data dictionaryPR
PRRATEHISTEmployee Rate HistoryHR
PRREGPARMNo description in the Lawson data dictionaryPR
PRSHIFTHDRContains the shift table code definitions.PR
PRSYSTEMHR Company and Process LevelsHR
PRTAXLOCNo description in the Lawson data dictionaryPR
PRTIMEEmployee Pay/Hours HistoryPR
QUARTDEDQuarterly DeductionPR
QUARTWAGEQuarterly WagePR
STANDTIMEPayroll Standard Time RecordPR
SUBCKPOINTSubledger Check PointIF
TAEEMASTEREmployee Absence PlanLP
TAEMPSERVEmployee LP Service RecordLP
TAENROLLNo description in the Lawson data dictionaryLP
TAPAYROLLAbsence Plan Payroll RuleLP
TASTRUCTURAbsence Plan StructureLP
TIMERECORDEmployee Time RecordsPR
TIPPAYEmployee Tip PayPR
TPPARAMTip ParametersTP
TRSGBLCKThis file contains segment block data for employee time records.PR

Referenced files (89)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATSUMXAccount Category Summ DetailAC
ATTENDCODEAttendance CodeTM
BANKACCTBank AccountPR
BANKFILEBank CodePR
C6BANKMNo description in the Lawson data dictionaryC6
C6EMPADDRTNo description in the Lawson data dictionaryC6
C6PRDDEFNo description in the Lawson data dictionaryC6
C6PRDDTLNo description in the Lawson data dictionaryC6
CMASSIGNNo description in the Lawson data dictionaryCW
CMCONTRACTNo description in the Lawson data dictionaryCW
CMCONTRULENo description in the Lawson data dictionaryCW
CMPAYCYCNo description in the Lawson data dictionaryCW
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
CWASSIGNNo description in the Lawson data dictionaryCW
CWCONTRACTContracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay…CW
CWCONTRULENo description in the Lawson data dictionaryCW
DEDCODEDeductionPR
DEPTCODEDepartmentHR
DEPTSEGBLKDepartment Segment BlockHR
EMDISTMASTEmp Acct Distribution OverridePR
EMPACHDISTEmployee ACH DistributionPR
EMSTATUSEmployee/Applicant StatusHR
FBFUNDDTLBudget Fund DetailGL
GLADDRESSGeneral Ledger Company AddressIF
GLCHARTGeneral Ledger ChartIF
GLCODESGeneral Ledger CodesIF
GLINTCOGeneral Ledger IntercompanyIF
GLMASTERGeneral Ledger Account MasterIF
GLNAMESGeneral Ledger NamesIF
GLSYSTEMGeneral Ledger CompanyIF
GMCONTROLNo description in the Lawson data dictionaryGM
GMLABDISTGrant Labor DistributionGM
GMLABDISTXGrant Labor Distribution DtlGM
HRHISTORYHR HistoryHR
HRSECLEVEmployee Security LevelHR
INSTCTRYCDIntrastat Country CodesTX
JOBCODEJob Code ParametersHR
LPLINKLP Link Plan TableLP
ONETMDEDPayroll One-time DeductionPR
PADICTHR Systems Data DictionaryHR
PAEMPLOYEEEmployee Personnel InformationHR
PAEMPPOSEmployee Multiple Pos, JobsHR
PAPOSITIONPositionsPA
PAPOSRULEPosition RulesPA
PASCRTYData Item Attribute ParametersHR
PAYSUMGRPPay Summary GroupsPR
PCODESHuman Resource CodeHR
PCODESDTLContains contact information detail (address and phone number) for specific types of PCODES.HR
PERSACTIONPersonnel ActionPA
PERSGROUPEmployee Group HeaderHR
PGEMPLOYEEEmployee Group EmployeesHR
PLANPL Group DetailBN
PRBUSGRPNo description in the Lawson data dictionaryPR
PRCHECKEmployee PaymentPR
PRDEDACCTSNo description in the Lawson data dictionaryPR
PRFUNDSRCNo description in the Lawson data dictionaryPR
PROTACCTSThis file contains expense accounts for premium portions of pay by job codes.PR
PROTPAYPRDOvertime Pay PeriodsPR
PROVERTIMEOvertime Pay PlanPR
PRPROCGRPPayroll Process GroupHR
PRPROVINCEThis file contains province codes and descriptions.PR
PRQCENTGRPNo description in the Lawson data dictionaryPR
PRRATEHISTEmployee Rate HistoryHR
PRRATESAlternate Pay RatesPR
PRSAGDTLStep & Grade Schedule DetailHR
PRSAGHEADStep & Grade Schedule HeaderHR
PRSHIFTHDRContains the shift table code definitions.PR
PRSHIFTTBLThis detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule…PR
PRSTATEStatesPR
PRTAXAUTHTax AuthorityPR
PRTAXLEVYPayroll Tax LevyPR
PSGRELATEPay Class/Pay Sum Grp RelationHR
SYSTEMCODESystem CodeIF
TAEEMASTEREmployee Absence PlanLP
TAENROLLNo description in the Lawson data dictionaryLP
TAPAYROLLAbsence Plan Payroll RuleLP
TAPLANAbsence PlanLP
TAREASCODEAbsence Plan Reason CodeLP
TASERVCODEAbsence Plan Service CodeLP
TASERVICEService Class & Code RelationsLP
TASTRUCTURAbsence Plan StructureLP
TAXGROUPPayroll Tax Reporting GroupPR
WCCLASSOVRNo description in the Lawson data dictionaryPR

Program calls

Invoked programs (17)

ACAC, ACTA, API4, HRHI, HRLO, HRST, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, PREN, SLSE, SLSS, SLSU