PR189 – Gross Up Calculation
- System
- Payroll (PR)
- Type
- Batch program
- Updates
- 59 tables
- References
- 103 tables
PR189 (Gross Up Calculation) is a Lawson Payroll batch program. It updates ACCOMMIT, ACCOMMITX, ADDRDATA, C6EMDDMSTR, C6EMPADDRT, C6EMPINV, C6EXEMPT, C6HOUSERNT and 51 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ATTENDCODE, BANKACCT and 95 more.
About PR189
Run Gross-Up Calculation (PR189) to calculate and report employee deductions, company deductions, and net pay for all employees with Current status time records. When you run PR140, the Payroll system can create up to five reports - Earnings and Deduction Calculation report - Garnishment report - Error report - Warning report - Error Time Record Deleted report The system creates Earnings and Deduction Calculation report every time you run PR140. For each employee, this report lists: - Wage detail - Employee paid deductions - Company paid deductions The system creates the Garnishment report every time you run PR140. For employee who has garnishments, this report lists: - Gross pay - Disposable income - Wages exempt from garnishment - Deduction amounts. If you have made changes to PR26.1 (Employee Garnishments), you need to run PR115 (Garnishment Update) before you run PR140. The system creates the Error report if there are time records that the system cannot process because of an error. It lists the time records that are in error. The system creates the Warning report if there are BSI tax warnings. This report lists the employee the warning applies to and the warning itself. If you do not want to create a Warning report, select No in the Tax Warning Messages field on PR140. The system creates the Error Time Records Deleted report if you chose to delete error time records when you ran PR140. This report lists the deleted time records. If you chose to delete error time records, you must re-enter the time records listed on this report before you can process them.
Updated files (59)
| 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 |
| C6EMPINV | No description in the Lawson data dictionary | C6 |
| C6EXEMPT | No description in the Lawson data dictionary | C6 |
| C6HOUSERNT | No description in the Lawson data dictionary | C6 |
| C6NETWAGE | No description in the Lawson data dictionary | C6 |
| C6PREVEMP | No description in the Lawson data dictionary | C6 |
| C6PROJECTN | 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 |
| EMPACHDIST | Employee ACH Distribution | PR |
| EMPLOYEE | Employee | HR |
| EMTAMASTR | Employee Time Accrual Master | TA |
| 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 |
| ONETMDED | Payroll One-time Deduction | PR |
| PAEMPPOS | Employee Multiple Pos, Jobs | HR |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PAYMASTR | Employee Payment Master | PR |
| PRBATCH | Payroll Time Record Batch Head | PR |
| PRCHECK | Employee Payment | PR |
| PRDEDDTL | No description in the Lawson data dictionary | PR |
| PREMPBANK | No description in the Lawson data dictionary | 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 |
| PRPENFSRCH | No description in the Lawson data dictionary | PR |
| PRPENHIST | 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 |
| PRTRDADJ | No description in the Lawson data dictionary | 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 (103)
| 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 |
| BNLIMITS | Benefit Limits | HR |
| C6BANKM | No description in the Lawson data dictionary | C6 |
| C6EMPADDRT | No description in the Lawson data dictionary | C6 |
| C6INPF | No description in the Lawson data dictionary | C6 |
| C6INVEST | No description in the Lawson data dictionary | C6 |
| C6NETWAGE | 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 |
| C6TAXGRP | 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 |
| COMPHIST | Employee Compensation History | BN |
| 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 |
| EMDEPEND | Employee Dependent | 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 |
| INEMPLOYEE | No description in the Lawson data dictionary | C6 |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JOBCODE | Job Code Parameters | HR |
| LPLINK | LP Link Plan Table | LP |
| 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 |
| PREMDEDHST | Employee Deduction History | PR |
| PREMPGARN | Used to store information to identify a particular garnishment per employee per company. | PR |
| PRGARNRULE | The Garnishment Rules files contains garnishment rules by governing tax authority and category for wage formulas… | PR |
| PRGARNRULX | No description in the Lawson data dictionary | PR |
| PRGARNTYPE | Contains the type of garnishments and categories to which they are linked. | PR |
| PRMINWAGE | Minimum Wage | PR |
| PRONWAGES | No description in the Lawson data dictionary | PR |
| PROTPAYPRD | Overtime Pay Periods | PR |
| PROVERTIME | Overtime Pay Plan | PR |
| PRPAYCODE | Pay Code | PR |
| PRPENFSRC | No description in the Lawson data dictionary | PR |
| PRPENFSRCH | No description in the Lawson data dictionary | 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 |
| PSGTAXES | Pay Summary Group Taxes | PR |
| QUARTDED | Quarterly Deduction | PR |
| 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 |
| TAXIDEXMP | Pay/Deduction Exemption Code | PR |
| WCCLASS | Work Comp Class Detail | PR |
| WCCLASSHDR | Work Comp Class Header | PR |
| WCCLASSOVR | No description in the Lawson data dictionary | PR |
| WCPOLICY | Workers Compensation Policy | PR |
Program calls
Invoked programs (20)
ACAC, ACTA, API4, HRHI, HRLO, HRST, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, PRAN, PRBA, PRBN, PREN, SLSE, SLSS, SLSU