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 PR125 PR139 PR141
PR142 PR195 PR197 PR226 PR247 PR260
PR275 PR276 PR277 PR282 PR294 PR50.2
PR51.1 PR51.2 PR86.1 PR89.1 AC541 AC542
BN104 BN150 PR128 PR131 PR132 PR134
PR136 PR14.1 PR15.1 PR15.2 PR205 PR26.1
PR26.2 PR32.2 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR39.1
PR39.2 PR47.1 PR47.2 PR514 PR530 UK102
UK120 PR283
UPDATED BY
BN500 HR511 HR650 PA502 PA513 PR13.1
PR13.5 PR13.6 PR13.8 PR300 PR45.1 PR560
PR82.1 PR85.1 PR36.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PYD-COMPANY Numeric 4 BN500 PR560
Company The company number represents an PR82.1
established company and is entered on
all function codes.
PYD-EMPLOYEE Numeric 9 BN500 PR560
Employee Contains the employee number. Each PR82.1
person employed by the company is
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 PR560
Internal Check ID Contains the payment identification PR82.1 PR85.1
Number number. When you create a payment
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 PR560
Deduction Code Contains the employee deduction. PR82.1
PYD-PROCESS-LEVEL Alpha 5 BN500 PR560
Process Level This field contains the tax reporting PR82.1
process level.
PYD-WORK-STATE Alpha 2 BN500 PR560
Work State Identifies the state in which the PR82.1
workers' compensation plan is affective.
PYD-PAYROLL-YEAR Numeric 4 BN500 PR560
Current Payroll Year Contains the year portion of the PR82.1 PR85.1
payment date.
PYD-QUARTER Numeric 1 BN500 PR560
Quarter Contains the quarter number associated PR82.1 PR85.1
with the payment date.
1
2
3
4
PYD-EDM-SEQ-NBR Numeric 4 PR560 PR82.1
Emp Deduction Contains the employee deduction
Sequence Number sequence number.
PYD-DED-AMT Signed 13.2 BN500 HR70.1
Deduction Amount Contains the deduction amount taken on PR195 PR197
a payment. The system rolls the PR50.2 PR51.1
deduction amount into the employee's PR51.2 PR560
year-to-date deduction amount. PR82.1 PR85.1
PYD-TAX-WAGES Signed 13.2 BN500 PR560
Taxable Wages Contains the taxable wages for a PR82.1 PR85.1
payment. The system uses this field to
calculate a withholding type deduction.
The system rolls the taxable wages into
the employee's year-to-date wage amount.
PYD-WAGE-AMOUNT Signed 13.2 BN500 PR560
Wage Amount Contains the sum of all wage amounts PR82.1 PR85.1
from time records for pay codes tied to
this pay summary group.
PYD-EXCESS Signed 13.2 BN500 PR560
Excess Contains the total amount of wages that PR82.1 PR85.1
exceed the defined limit of wages
subject to unemployment taxes.
PYD-GARN-OBJ-ID Numeric 12 PR560 PR82.1
Garn Obj Id Assigned when an employee garnishment
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.
PYD-REPORT-ENTITY Alpha 5 PR560 PR82.1
Report Entity Contains the report entity.
Report Entity is the Process Level or
Company that this Process Level reports
to for tax reporting. If the Process
Level itself is independent then the
independent Process Level is the Report
Entity. If the Process Level is non
independent and is associated to a
independent head Process Level then the
independent head Process Level is the
Report Entity. If the Process Level is
non independent and is not associated to
a independent head Process Level then
the Company is the Report Entity.
PYD-BUS-NBR-GRP Alpha 4 PR560 PR82.1
Bus Nbr Grp Contains the business number group.
PYD-QC-ENT-NBR-GRP Alpha 4 PR560 PR82.1
Qc Ent Nbr Grp Contains the Quebec enterprise number
group.
PYD-OBJ-ID Numeric 12
Object This is the object identifier. It is
Identification used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
PYD-CURRENCY-CODE Alpha 5 PR560 PR82.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PYD-CURR-ND Numeric 1 PR560 PR82.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PYD-CHECK-DATE Numeric 8 (yyyymmdd) PR560 PR82.1
Payment Date The payment date.
PYD-PER-END-DATE Numeric 8 (yyyymmdd) BN500 PR560
Period End Date The period end date of the specified PR82.1 PR85.1
year.
PYD-BALANCE-TYPE Alpha 1 PR560 PR82.1
Balance Type A = Ascending
D = Descending
" "
PYD-TAX-FLAG Alpha 1 PR560 PR82.1
Tax Flag T = Tax
S = Tax Status
" " = Non-tax
PYD-HM-PROCESS-LEV Alpha 5 HR511 HR650
Hm Process Lev PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
PR560 PR82.1
PYD-COUNTRY-CODE Alpha 2 PR560
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
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
REPORT-ENTITY BN32.1 BN32.2
BUS-NBR-GRP BN32.3 BN330
QC-ENT-NBR-GRP BN340 BN45.1
PROCESS-LEVEL BN500 BN531
WORK-STATE BN65.1 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR170 HR511
HR650 HR70.1
...
PYDSET3 COMPANY AC541 AC542
EMPLOYEE BN100 BN101
DED-CODE BN102 BN103
EDM-SEQ-NBR BN104 BN105
CHECK-ID BN145 BN150
REPORT-ENTITY BN245 BN31.1
BUS-NBR-GRP BN31.2 BN32.1
QC-ENT-NBR-GRP BN32.2 BN32.3
PROCESS-LEVEL BN45.1 BN531
WORK-STATE BN65.1 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR511 HR650
PA502 PA513
...
PYDSET4 COMPANY KeyChange BN66.1 PR139
EMPLOYEE PR195 PR283
DED-CODE PR89.1
PER-END-DATE
CHECK-ID
EDM-SEQ-NBR
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
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
Prqcentgrp PRQCENTGRP Not Required
PYD-COMPANY -> PQC-COMPANY
PYD-PROCESS-LEVEL -> PQC-PROCESS-LEVEL
PYD-QC-ENT-NBR-GRP -> PQC-QC-ENT-NBR-GRP
Quartded 1 QUARTDED Not Required
PYD-COMPANY -> QTD-COMPANY
PYD-COUNTRY-CODE -> QTD-COUNTRY-CODE
PYD-PAYROLL-YEAR -> QTD-PAYROLL-YEAR
PYD-EMPLOYEE -> QTD-EMPLOYEE
PYD-DED-CODE -> QTD-DED-CODE
PYD-QUARTER -> QTD-QUARTER
PYD-REPORT-ENTITY -> QTD-REPORT-ENTITY
PYD-BUS-NBR-GRP -> QTD-BUS-NBR-GRP
PYD-QC-ENT-NBR-GRP -> QTD-QC-ENT-NBR-GRP
PYD-PROCESS-LEVEL -> QTD-PROCESS-LEVEL
PYD-WORK-STATE -> QTD-WORK-STATE
Tax Id PRTAXAUTH Required
When PYD-CALC-TYPE = "T"
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
Prdeddtl PRDEDDTL
PYD-OBJ-ID -> PDE-PYD-OBJ-ID
PDE-TAX-STATUS
Quartded QUARTDED
PYD-COMPANY -> QTD-COMPANY
PYD-COUNTRY-CODE -> QTD-COUNTRY-CODE
PRS-PAYROLL-YEAR -> QTD-PAYROLL-YEAR
PYD-EMPLOYEE -> QTD-EMPLOYEE
PYD-DED-CODE -> QTD-DED-CODE
QTD-QUARTER
QTD-REPORT-ENTITY
QTD-BUS-NBR-GRP
QTD-QC-ENT-NBR-GRP
QTD-PROCESS-LEVEL
QTD-WORK-STATE
|
