PR131 – Retroactive Pay Calculation

System
Payroll (PR)
Type
Batch program
Updates
41 tables
References
85 tables

PR131 (Retroactive Pay Calculation) is a Lawson Payroll batch program. It updates ACCOMMIT, ACCOMMITX, ADDRDATA, C6EMDDMSTR, C6EMPADDRT, CKPOINT, CMASSIGN, CMPAYCYC and 33 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ATTENDCODE, C6EMPADDRT and 77 more.

About PR131

Run Retroactive Pay Calculation (PR131) to calculate a retroactive pay increase based on a percent of earnings or an amount per hour, and create a time record for the amount. You can calculate retroactive pay for all employees in the company, or for any subgroup of employees based on process level, department, union, job code, shift, employee group, payment date(s), pay class, and/or pay codes. **Processing Effect Choose Update; Recreate Time Records to have PR131 remove all retro status time records and recreate retro status time records based on the job parameters. Note: This option deletes all retro time records for the employees included in the job parameters. Verify all retro status time records todetermine if other PR131 jobs need to be rerun. For example, for process level A you ran PR131 Update Option; Add Time Records for Pay Code REG1 for 3 %. You then ran PR131 for process level A Update Option; Add Time Records for Pay Code REG2 for 5%. Theemployees in process level A now have two time records. You realize that the REG2percent should have been 4% instead of 5%. Run PR131 with Update: Recreate TimeRecords. This run will delete both time records and recreate the REG2 retro timerecords for 4%. Then run PR131 again with Update; Add Time Records for the REG1 Pay Code for 3%.

More information: If you give a retroactive pay increase to non-exempt employees, run PR132 (FLSA Overtime Calculation) to calculate overtime due on the retroactive amount.

Updated files (41)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ADDRDATAAddress CodeIF
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
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
HRHISTORYHR HistoryHR
LPPENDREQNo description in the Lawson data dictionaryLP
PAEMPPOSEmployee Multiple Pos, JobsHR
PAYDEDUCTNEmployee Payment DeductionsPR
PRBATCHPayroll Time Record Batch HeadPR
PRMONITORNo description in the Lawson data dictionaryPR
PRPAYCODEPay CodePR
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
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
TRSGBLCKThis file contains segment block data for employee time records.PR

Referenced files (85)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATSUMXAccount Category Summ DetailAC
ATTENDCODEAttendance CodeTM
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
CUCODESCurrency CodesIF
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
EMSTATUSEmployee/Applicant StatusHR
FBFUNDDTLBudget Fund DetailGL
GLADDRESSGeneral Ledger Company AddressIF
GLCHARTGeneral Ledger ChartIF
GLCODESGeneral Ledger CodesIF
GLINTCOGeneral Ledger IntercompanyIF
GLNAMESGeneral Ledger NamesIF
GLSYSTEMGeneral Ledger CompanyIF
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
PAYCLASSPay ClassPR
PAYDEDUCTNEmployee Payment DeductionsPR
PAYMASTREmployee Payment MasterPR
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
PRDISTRIBEmployee Payment DistributionPR
PREMDEDHSTEmployee Deduction HistoryPR
PROTWRKPRDOvertime Work PeriodsPR
PROVERTIMEOvertime Pay PlanPR
PRPAYCODEPay CodePR
PRPENPAYNo description in the Lawson data dictionaryPR
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
PRTIMEEmployee Pay/Hours HistoryPR
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