|
|
PAYDEDUCTN FILE
Employee Payment Deductions
This file contains employee deduction information associated with Employee
Payment file records. PR140 (Earnings and Deduction Calculation) is the
primary program that updates this file. For efficiency, one Employee Payment
Deductions file record stores information for up to ten Employee Deduction
file records. If an Employee Payment file record has more than ten Employee
Deduction file records associated with it, the system creates another Employee
Payment Deductions file record with a different sequence number. PR199
(Payroll Close) rolls the information in the Employee Payment Deductions file
records into D type Employee Payroll YTD Summary file records.
The Benefits system uses this file to total employee deduction amounts for
defined contribution plans for third-party administrator reporting.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN232 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN330 BN340 BN45.1 BN531 BN65.1
BN66.1 BN71.1 BN72.1 BS13.1 BS14.1 BS15.1
BS32.1 HR170 HR70.1 PR139 PR141 PR142
PR150 PR160 PR180 PR195 PR199 PR226
PR260 PR275 PR276 PR277 PR294 PR50.2
PR51.1 PR51.2 PR86.1 PR89.1 BN104 HR11.1
HR511 PA100 PA52.1 PA52.4 PA52.5 PR13.1
PR13.2 PR14.1 PR15.1 PR15.2 PR205 PR26.1
PR26.2 PR39.1 PR39.2 PR514
UPDATED BY
BN500 PR140 PR300 PR45.1 PR560 PR80.1
PR82.1 PR85.1 PR36.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PYD-COMPANY Numeric 4 BN500 PR140
Company The company number represents an PR560 PR80.1
established company and is entered on PR82.1
all function codes.
PYD-EMPLOYEE Numeric 9 BN500 PR140
Employee Contains the employee number. Each PR560 PR80.1
person employed by the company is PR82.1
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PYD-CHECK-ID Numeric 12 BN500 PR140
Internal Check ID Contains the payment identification PR560 PR80.1
Number number. When you create a payment PR82.1 PR85.1
deduction record, the system moves the
payment identification number into this
field to serve as the link between the
Employee Payment file record and the
Employee Payment Deductions file record.
PYD-DED-CODE Alpha 4 BN500 PR140
Deduction Code Contains the employee deduction. PR560 PR80.1
PR82.1
PYD-PROCESS-LEVEL Alpha 5 BN500 PR140
Process Level This field contains the process level, PR560 PR80.1
which is the reporting hierarchy below PR82.1
company.
PYD-WORK-STATE Alpha 2 BN500 PR140
Work State Identifies the state in which the PR560 PR80.1
workers' compensation plan is affective. PR82.1
PYD-PAYROLL-YEAR Numeric 4 BN500 PR140
Current Payroll Year Contains the year portion of the PR560 PR80.1
payment date. PR82.1 PR85.1
PYD-QUARTER Numeric 1 BN500 PR140
Quarter Contains the quarter number associated PR560 PR80.1
with the payment date. PR82.1 PR85.1
1
2
3
4
PYD-EDM-SEQ-NBR Numeric 4 PR140 PR560
Emp Deduction Contains the employee deduction PR80.1 PR82.1
Sequence Number sequence number.
PYD-DED-AMT Signed 9.2 BN500 HR70.1
Deduction Amount Contains the deduction amount taken on PR140 PR150
a payment. The system rolls the PR195 PR199
deduction amount into the employee's PR50.2 PR51.1
year-to-date deduction amount. PR51.2 PR560
PR80.1 PR82.1
PR85.1
PYD-TAX-WAGES Signed 11.2 BN500 PR140
Taxable Wages Contains the taxable wages for a PR560 PR80.1
payment. The system uses this field to PR82.1 PR85.1
calculate a withholding type deduction.
The system rolls the taxable wages into
the employee's year-to-date wage amount.
PYD-WAGE-AMOUNT Signed 11.2 BN500 PR140
Wage Amount Contains the sum of all wage amounts PR560 PR80.1
from time records for pay codes tied to PR82.1 PR85.1
this pay summary group.
PYD-EXCESS Signed 11.2 BN500 PR140
Excess Contains the total amount of wages that PR560 PR80.1
exceed the defined limit of wages PR82.1 PR85.1
subject to unemployment taxes.
PYD-GARN-OBJ-ID Numeric 12 PR140 PR560
Garn Obj Id Assigned when an employee garnishment PR80.1 PR82.1
table (PREMPGARN) is added and
deductions are created. This ID links
the employee deductions to this
garnishment (case number/file number).
If the same deduction is created for
this employee, this ID along with the
sequence number keeps the record unique.
PAYDEDUCTN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PYDSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
CHECK-ID BN105 BN145
DED-CODE BN232 BN245
EDM-SEQ-NBR BN31.1 BN31.2
PROCESS-LEVEL BN32.1 BN32.2
WORK-STATE BN32.3 BN330
BN340 BN45.1
BN500 BN531
BN65.1 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR170 HR70.1
PR139 PR140
...
PYDSET3 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
DED-CODE BN104 BN105
EDM-SEQ-NBR BN145 BN245
CHECK-ID BN31.1 BN31.2
PROCESS-LEVEL BN32.1 BN32.2
WORK-STATE BN32.3 BN45.1
BN531 BN65.1
BN66.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR511 PA100
PA52.1 PA52.4
PA52.5 PR13.1
...
PAYDEDUCTN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PYD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deduct Code DEDCODE Required
PYD-COMPANY -> DDC-COMPANY
PYD-DED-CODE -> DDC-DED-CODE
Emp Ded Code EMDEDMASTR Required
PYD-COMPANY -> EDM-COMPANY
PYD-EMPLOYEE -> EDM-EMPLOYEE
PYD-DED-CODE -> EDM-DED-CODE
PYD-EDM-SEQ-NBR -> EDM-SEQ-NBR
Employee EMPLOYEE Required
PYD-COMPANY -> EMP-COMPANY
PYD-EMPLOYEE -> EMP-EMPLOYEE
Payment PAYMASTR Required
PYD-COMPANY -> PYM-COMPANY
PYD-EMPLOYEE -> PYM-EMPLOYEE
PYD-CHECK-ID -> PYM-CHECK-ID
Process Level PRSYSTEM Required
PYD-COMPANY -> PRS-COMPANY
PYD-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Quartded 1 QUARTDED Not Required
PYD-COMPANY -> QTD-COMPANY
PYD-PAYROLL-YEAR -> QTD-PAYROLL-YEAR
PYD-EMPLOYEE -> QTD-EMPLOYEE
PYD-DED-CODE -> QTD-DED-CODE
PYD-QUARTER -> QTD-QUARTER
PYD-PROCESS-LEVEL -> QTD-PROCESS-LEVEL
PYD-WORK-STATE -> QTD-WORK-STATE
Tax Id PRTAXAUTH Required
When PYD-CALC-TYPE = "W"
DDC-TAX-ID-CODE -> PRX-TAX-ID-CODE
Work State PRSTATE Required
When PYD-WORK-STATE != Spaces
PYD-WORK-STATE -> PSA-STATE
PAYDEDUCTN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Quartded QUARTDED
PYD-COMPANY -> QTD-COMPANY
PRS-PAYROLL-YEAR -> QTD-PAYROLL-YEAR
PYD-EMPLOYEE -> QTD-EMPLOYEE
PYD-DED-CODE -> QTD-DED-CODE
QTD-QUARTER
QTD-PROCESS-LEVEL
QTD-WORK-STATE
|