PAYDEDUCTN

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
BN232 BN330 BN340 HR170 HR70.1 PR125
PR141 PR142 PR160 PR180 PR197 PR226
PR247 PR250 PR251 PR253 PR260 PR275
PR276 PR277 PR279 PR282 PR418 PR50.2
PR51.1 PR51.2 PR86.1 ZP551 ZP552 ZP554
ZP555 ZP557 ZP559 PR274


UPDATED BY
BN305 BN66.1 HR11.1 HR11.2 HR11.4 HR28.1
HR511 LT101 LT111 ZH510 PA02.1 PA100
PA102 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR12.6 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR13.2 PR140 PR189 PR195 PR30.2
PR300 PR45.1 PR512 PR560 PR582 PR80.1
PR80.4 PR80.3 PR82.1 PR85.1 PR89.1 PRAT.1
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN245 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN45.1 BN531 BN65.1 BN71.1
BN72.1 BS10.1 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 PR521 EXI2.1 EXI4.1 LP130 PR128
PR131 PR132 PR134 PR135 PR136 PR137
PR139 PR14.1 PR14.2 PR15.1 PR15.2 PR205
PR26.1 PR26.2 PR261 PR262 PR266 PR283
PR287 PR29.1 PR292 PR32.1 PR32.2 PR33.1
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR36.4
PR37.1 PR39.1 PR39.2 PR47.1 PR47.2 PR514
PR529 PR530 PR539 UK102 TA147 PR192
PR297 PR299 PR797

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PYD-COMPANY
Element: Company Hr
Numeric 4
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each 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.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-CHECK-ID
Element: Check Id
Numeric 12
Contains the payment identification 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.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
PYD-DED-CODE
Element: Ded Code
Alpha 4
Contains the employee deduction.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
This field contains the tax reporting process level.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-WORK-STATE
Element: Work State
Alpha 2
Identifies the state in which the workers' compensation plan is affective.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-PAYROLL-YEAR
Element: Payroll Year
Numeric 4
Contains the year portion of the payment date.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
PYD-QUARTER
Element: Quarter
Numeric 1
Contains the quarter number associated with the payment date.
1
2
3
4
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
PYD-EDM-SEQ-NBR
Element: Edm Seq Nbr
Numeric 4
Contains the employee deduction sequence number.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-DED-AMT
Element: Ded Amt
Signed 13.2
Contains the deduction amount taken on a payment. The system rolls the deduction amount into the employee's year-to-date deduction amount.
BN66.1 HR70.1
PR140 PR189
PR195 PR197
PR50.2 PR51.1
PR51.2 PR560
PR582 PR80.1
PR80.2 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
PYD-TAX-WAGES
Element: Tax Wages
Signed 13.2
Contains the taxable wages for a 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.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
PYD-WAGE-AMOUNT
Element: Wage Amount
Signed 13.2
Contains the sum of all wage amounts from time records for pay codes tied to this pay summary group.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
PYD-EXCESS
Element: Excess
Signed 13.2
Contains the total amount of wages that exceed the defined limit of wages subject to unemployment taxes.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
PYD-GARN-OBJ-ID
Element: Garn Obj Id
Numeric 12
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.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-REPORT-ENTITY
Element: Report Entity
Alpha 5
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.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-BUS-NBR-GRP
Element: Bus Nbr Grp
Alpha 4
Contains the business number group.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-QC-ENT-NBR-GRP
Element: Qc Ent Nbr Grp
Alpha 4
Contains the Quebec enterprise number group.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is 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.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR85.1 PR89.1
PRAT.1
PYD-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-CHECK-DATE
Element: Check Date
Numeric 8 (yyyymmdd)
The payment date.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-PER-END-DATE
Element: Per End Date
Numeric 8 (yyyymmdd)
Identifies period end date in distribution record; used during PR198 to relieve salary encumbrance commitments for pay period (updated from TIMERECORD.PER-END-DATE).
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
PYD-BALANCE-TYPE
Element: Balance Type
Alpha 1

A = Ascending
D = Descending
" "
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-TAX-FLAG
Element: Tax Flag
Alpha 1

T = Tax
S = Tax Status
" " = Non-tax
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-HM-PROCESS-LEV
Element: Process Lev Hr
Alpha 5
BN305 BN66.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR140 PR189
PR195 PR30.2
PR512 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
ZH510
PYD-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PYD-NI-CODE
Element: Ni Code
Alpha 1
PYD-DIRECTOR
Element: Director
Alpha 1
PYD-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
PYD-TAX-BASIS
Element: Tax Basis
Alpha 1
PYD-PERIOD-NBR
Element: Period Nbr
Numeric 3
PYD-CONTRACTED-OUT
Element: Contracted Out
Alpha 1
PYD-OT-PLAN-CODE
Element: Ot Plan Code
Alpha 4
Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1


PAYDEDUCTN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PYDSET1 COMPANY
EMPLOYEE
CHECK-ID
DED-CODE
EDM-SEQ-NBR
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
...
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN232 BN245
BN305 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN330 BN340
BN45.1 BN531
BN65.1 BN66.1
BN71.1 BN72.1
BS10.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
PYDSET3 COMPANY
EMPLOYEE
DED-CODE
EDM-SEQ-NBR
CHECK-ID
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
BN66.1 PR139
PR140 PR189
PR192 PR195
PR274 PR297
PR299 PR797
PR80.1 PR80.4
PR89.1 PRAT.1
PYDSET6 COMPANY
HM-PROCESS-LEV
EMPLOYEE
CHECK-ID
DED-CODE
EDM-SEQ-NBR
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
KeyChange
PYDSET7 COMPANY
PAYROLL-YEAR
PER-END-DATE
TAX-CODE
EMPLOYEE
CHECK-ID
DED-CODE
EDM-SEQ-NBR
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE


PAYDEDUCTN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PYD-COMPANY->PRS-COMPANY (PRSSET1)
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
Tax Id PRTAXAUTH Required
When DDC-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
NAME
RELATED 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
  QTD-PENSION


File created: Thu Jun 09 02:30:28 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.