PR128 – Offset Time Record Creation

System
Payroll (PR)
Type
Batch program
Updates
40 tables
References
83 tables

PR128 (Offset Time Record Creation) is a Lawson Payroll batch program. It updates ACCOMMIT, ACCOMMITX, ADDRDATA, C6EMDDMSTR, C6EMPADDRT, CKPOINT, CMASSIGN, CMPAYCYC and 32 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ATTENDCODE, C6EMPADDRT and 75 more.

About PR128

Run Offset Time Record Creation (PR128) to create offset time records. When you run PR128, the system creates three reports - Offset Time Record Creation, which lists the employees, the exception time records, and the offset time records the system created - Error Listing, which lists employees and exception time records for which offset time records could not be created due to errors - Exception/Offset Time Record Variance Report, which is an optional report that lists employees whose exception and offset time record hours do not balance **Processing Effect When you run PR128, the Payroll system creates offset time records for employees who have the Auto Time Record field on HR11.1 (Employee) set to Yes, Standard, or Time Group AND who have one or more exception time records. The system creates an offset time record for each exception time record. Offset time records consist of negative hours that reduce the regular hours produced by auto time records. You want to create offset time records for employees who have too many hours entered into the system due to exception time records. For example, if you have an employee with 40 hours of regular pay generated by auto time records and you enter 16 hours of vacation, the total time for the employee is over by 16 hours. To reduce the total hours for the employee, you run PR128, which creates an offset time record ofnegative 16 hours. An exception time record is assigned one of the exception pay codes that you defined on PR28.1 (Exception and Offset Time Record Rules). UsePR28.1 to define the relationships between exception pay codes and offset pay codes. You can define these exception rules by company or employee group. If you define rules by employee group, PR128 looks alphabetically through theemployee groups until it finds the first group the employee belongs to. The system uses the exception rules for that employee group to create offset time records for the employee.

Updated files (40)

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
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 (83)

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
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
PATHFINDEmployee Report Writer PathsHR
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
PREMDEDHSTEmployee Deduction HistoryPR
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
TREXCEPTThis file contains exception pay codes and offsetting pay codes for deviating employee attendances, such as absences.PR
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