|
|
PR140 - Earnings and Deductions Calc
**Form Purpose
Run Earnings and Deductions Calc (PR140) to calculate and report employee
deductions, company deductions, and net pay for all employees with Current
status time records.
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.
When you run PR140, the Payroll system can also create three additional
reports:
- Error report
- Warning report
- Error Time Record Deleted report
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.
Important If you have made changes to PR26.1 (Employee Garnishments), you
need to run PR115 (Garnishment Update) before you run PR140.
Updated Files
ACCOMMIT -
ACCOMMITX -
CKPOINT - The Universe file used for recovery.
EMACHDEPST - Used to update the remaining occurrences when an ACH deposit
is generated for an employee who is to have a limited number of
deposits to a given bank account.
EMPACHDIST - Used to create distribution records for all auto deposits.
These are output to tape by PR160 (Payment Print).
EMTAMASTR - Used to update employee time accrual records.
GLCOMMIT -
GLCOMMITX -
ONETMDED - Records are created in this file if arrears deductions are
calculated by the program.
PAYDEDUCTN - Contains the deductions calculated by the program for each
payment.
PAYMASTR - Used to create a record for each payment generated by the
program.
PBBLDEDUCT -
PBJOBCDTRN -
PBTIME -
PBTIMEREC -
PBTRANS -
PRCHECK - Used to void payments created by PR160 (Payment Print) on a
re-run.
PRDEDDTL -
PREMPGARN -
PRGARNHIST -
PRMONITOR -
PRPENFSRCH -
PRPENHIST -
PRSYSTEM - Used to update the run flag which identifies the cycle
programs that are running or have been run.
PRTRDADJ -
TIMERECORD - Used to update the time record status.
TRSGBLCK -
UKNITP -
Referenced Files
ACACCTCAT -
ACACTGRP -
ACACTIVITY -
BANKACCT - Used to validate bank account information.
BANKFILE - Used to validate the entered bank code and bank account from
which the payroll is to be paid.
BNLIMITS -
COMPHIST -
DEDCODE - If changes are made to deductions in PR05.1 (Deduction), PR140
(Earnings and Deductions Calculation) updates all Employee
Deduction file records with the changes, and resets the
deduction change flag.
DEPTCODE - Used to validate the employee's department.
EMDEDMASTR - Used to update the employee deduction when account information
for the deduction is changed in PR05.1 (Deduction).
EMPLOYEE - Used to update the last payroll date for each employee
processed.
EMSTATUS - Used to validate the employee's status.
GLADDRESS -
GLCHART -
GLNAMES -
GLSYSTEM -
HRSECLEV -
HRUTILITY -
INSTCTRYCD -
PAEMPLOYEE -
PASCRTY - Used to determine the security for a data item; if the data
item is to be logged; if the data item is required in a
program; and if the data item can be changed only by a
personnel action.
PAYSUMGRP - Used to validate the pay summary group and to retrieve the
payment description.
PBBILL -
PBBLDEDRT -
PBBLDEDRX -
PBBLJOBCD -
PBBLJOBCDX -
PBCLIENT -
PBDCTGRPX -
PBFEE -
PBFEEGRPX -
PCODESDTL -
PGEMPLOYEE -
PLAN - Read at the beginning of the program to determine if changes
were made to the deduction frequency table assigned to the
benefits plan. This only applies if the Lawson Benefits system
is used. If changes were made, you must run BN104 (Deduction
Frequency Update) before you run PR140 (Earnings and Deductions
Calculation).
PRBUSGRP -
PREMDEDHST - Used to retrieve employee deduction information.
PRGARNRULE -
PRGARNRULX -
PRGARNTYPE -
PRMINWAGE - Used to retrieve the Federal minimum wage.
PRONWAGES -
PROTPAYPRD -
PROVERTIME -
PRPAYCODE - If a change is made to a deduction in PR20.4 (Paycode), PR140
(Earnings and Deductions Calculation) updates all time records
using that code with the changes, and resets the deduction
change flag.
PRPENFSRC -
PRPENFSRCH -
PRPENPAY -
PRPROCGRP - Used to validate the process group.
PRREGPARM -
PRSAGDTL - Used to retrieve a pay rate from a step and grade schedule.
PRTAXAUTH - Used to retrieve tax authority information used for time
record processing.
PRTAXLEVY - Used to retrieve tax levy information used for time record
processing.
PRTAXLOC -
PRTAXPRDS -
PRTAXYEAR -
PRTIME - Used to retrieve time record information used for time record
processing.
PSGRELATE - Used to associate pay summary groups to pay classes in order
to compute deduction amounts that are based on a particular
type of pay.
PSGTAXES - Used to retrieve supplemental tax information for time record
processing.
QUARTDED -
QUARTWAGE -
SYSTEMCODE -
TAXGROUP - Used to determine if an employee's process level is included
in a tax reporting group. If it is, the head process level is
used to find the taxing authority information for that
employee.
TAXIDEXMP - Used to determine if a pay code or deduction should be exempt
from specific taxes as defined in PR20.5 (Withholding
Exemptions) or PR05.2 (Taxable Wages Table).
UKCOTABLE -
UKNICAT -
UKNILIMITS -
UKNIRATES -
UKTAXRATE -
INVOKED Programs
ACCL
IFCU
IFSG
IFOB
IFRS
PBFE
PBWC
PRAN
PRBA
PRBN
PREN
PRWC
|
