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
PR247 PR261 PR262 PR266 PR283 PR287
PR36.1 PR192 PR297 PR299 PR797


UPDATED BY
BN305 BN66.1 HR11.1 HR11.2 HR511 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR140 PR189 PR195 PR300 PR45.1
PR560 PR582 PR80.1 PR80.4 PR80.2 PR82.1
PR82.3 PR85.1 PR89.1 UK560 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 BN71.1 BN72.1
BN729 BN991 BS13.1 BS14.1 BS15.1 BS32.1
HR170 HR70.1 PR125 PR139 PR141 PR142
PR160 PR180 PR197 PR226 PR250 PR251
PR253 PR260 PR275 PR276 PR277 PR279
PR282 PR418 PR50.2 PR51.1 PR51.2 PR86.1
UK13.1 UK141 UK145 UK201 UK202 UK277
UK50.1 UK50.3 UK50.5 XR275 XR885 PR274
XR901

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
UK560
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
UK560
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 UK560
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
UK560
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
UK560
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
UK560
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 UK560
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 UK560
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
UK560
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 UK50.1
UK50.3 UK560
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 UK560
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 UK560
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 UK560
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
UK560
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
UK560
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
UK560
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
UK560
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
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
UK560
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
UK560
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
UK560
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 UK560
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
UK560
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
UK560
PYD-HM-PROCESS-LEV
Element: Process Lev Hr		Alpha 5
BN305 BN66.1
HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560
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
UK560
PYD-NI-CODE
Element: Ni Code		Alpha 1
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR82.1 PR82.3
PR89.1 UK560
PYD-DIRECTOR
Element: Director		Alpha 1
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR82.1 PR82.3
PR89.1 UK560
PYD-TAX-CODE
Element: Tax Code		Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR82.1 PR89.1
UK560
PYD-TAX-BASIS
Element: Tax Basis		Alpha 1
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR82.1 PR89.1
UK560
PYD-PERIOD-NBR
Element: Period Nbr		Numeric 3
BN66.1 PR140
PR189 PR195
PR582 PR80.1
PR80.4 PR82.1
PR89.1
PYD-CONTRACTED-OUT
Element: Contracted Out		Alpha 1
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR82.1 PR82.3
PR89.1 UK560
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
PR82.1 PR89.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
BN105 BN145
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
BN729 BN991
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
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 PR287
PR297 PR299
PR797 PR80.1
PR80.4 PR89.1
XR901
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


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: Wed Jun 08 20:51:09 2016

Home
Contact Us



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