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)
| 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 |
| 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 |
| 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 |
| HRHISTORY | HR History | HR |
| LPPENDREQ | No description in the Lawson data dictionary | LP |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PRBATCH | Payroll Time Record Batch Head | PR |
| PRMONITOR | No description in the Lawson data dictionary | PR |
| PRPAYCODE | Pay Code | 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 |
| 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 (83)
| 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 |
| 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 |
| 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 |
| PATHFIND | Employee Report Writer Paths | HR |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PAYMASTR | Employee Payment Master | PR |
| 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 |
| PREMDEDHST | Employee Deduction History | PR |
| PROVERTIME | Overtime Pay Plan | PR |
| PRPAYCODE | Pay Code | PR |
| PRPENPAY | No description in the Lawson data dictionary | 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 |
| PRTIME | Employee Pay/Hours History | 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 |
| TREXCEPT | This file contains exception pay codes and offsetting pay codes for deviating employee attendances, such as absences. | 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