PAYDEDUCTN – Employee Payment Deductions

System: Payroll (PR)
Prefix: PYD
Primary key: COMPANY, EMPLOYEE, CHECK-ID, DED-CODE, EDM-SEQ-NBR, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE
Fields: 33
Updated by: 135 programs
Referenced by: 34 programs

PAYDEDUCTN is the Employee Payment Deductions table in Lawson Payroll (prefix PYD). It is indexed by COMPANY, EMPLOYEE, CHECK-ID, DED-CODE, EDM-SEQ-NBR, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE (PYDSET1); alternate indexes: PYDSET3, PYDSET6 and PYDSET7. It is related 1:1 to PRSYSTEM, DEDCODE, EMDEDMASTR, EMPLOYEE, PAYMASTR, PRQCENTGRP, PRTAXAUTH and PRSTATE and 1:M to PRDEDDTL and QUARTDED. It is updated by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 127 more and referenced by BN232, BN330, BN340, HR170, HR70.1, PR125, PR141, PR142 and 26 more. The table has 33 fields, 4 indexes and 11 documented relations.

About PAYDEDUCTN

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.

Fields (33)

Column = COBOL field name without the PYD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PYD-COMPANY` PK COMPANY	Numeric 4	—	BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
`PYD-EMPLOYEE` PK 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 +3 more
`PYD-CHECK-ID` PK 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 +4 more
`PYD-DED-CODE` PK DED_CODE	Alpha 4	Contains the employee deduction.	BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
`PYD-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	This field contains the tax reporting process level.	BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
`PYD-WORK-STATE` PK 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 +3 more
`PYD-PAYROLL-YEAR` PAYROLL_YEAR	Numeric 4	Contains the year portion of the payment date.	BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +4 more
`PYD-QUARTER` 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 +4 more
`PYD-EDM-SEQ-NBR` PK EDM_SEQ_NBR	Numeric 4	Contains the employee deduction sequence number.	BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
`PYD-DED-AMT` 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 +10 more
`PYD-TAX-WAGES` 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 +4 more
`PYD-WAGE-AMOUNT` 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 +4 more
`PYD-EXCESS` 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 +4 more
`PYD-GARN-OBJ-ID` 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 +3 more
`PYD-REPORT-ENTITY` PK 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 +3 more
`PYD-BUS-NBR-GRP` PK BUS_NBR_GRP	Alpha 4	Contains the business number group.	BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
`PYD-QC-ENT-NBR-GRP` PK QC_ENT_NBR_GRP	Alpha 4	Contains the Quebec enterprise number group.	BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
`PYD-OBJ-ID` 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 +1 more
`PYD-CURRENCY-CODE` 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 +3 more
`PYD-CURR-ND` CURR_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 +3 more
`PYD-CHECK-DATE` CHECK_DATE	Numeric 8 (yyyymmdd)	The payment date.	BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
`PYD-PER-END-DATE` 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 +4 more
`PYD-BALANCE-TYPE` BALANCE_TYPE	Alpha 1	" " `A` Ascending `D` Descending	BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
`PYD-TAX-FLAG` TAX_FLAG	Alpha 1	" " = Non-tax `T` Tax `S` Tax Status	BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
`PYD-HM-PROCESS-LEV` HM_PROCESS_LEV	Alpha 5	—	BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +35 more
`PYD-COUNTRY-CODE` 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 +3 more
`PYD-NI-CODE` NI_CODE	Alpha 1	—	—
`PYD-DIRECTOR` DIRECTOR	Alpha 1	—	—
`PYD-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. This must be valid Tax Code.	—
`PYD-TAX-BASIS` TAX_BASIS	Alpha 1	—	—
`PYD-PERIOD-NBR` PERIOD_NBR	Numeric 3	—	—
`PYD-CONTRACTED-OUT` CONTRACTED_OUT	Alpha 1	—	—
`PYD-OT-PLAN-CODE` 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

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	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`	Primary	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
`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 +6 more
`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`		—

Relations

One to one (9) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (135)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN104 Frequency Table Update
BN105 Plan Update
BN145 Flex Dollars Calculation
BN150 Life Insurance Reportable Income
BN245 Benefit Election Form
BN305 Highly Compensated Employees
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN65.1 Election Simulation
BN66.1 Estimated Pay Calculation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS10.1 Web Enrollment Current Benefit Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
LP130 Absence Plan Payout
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR128 Offset Time Record Creation
PR13.1 Employee United States Taxes
PR13.2 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR139 Arrears Automation
PR14.1 Employee Deduction
PR14.2 Tax Withholding Lock-In
PR140 Earnings and Deductions Calculation
PR15.1 Deduction Speed Entry
PR15.2 Employee Deduction Speed Entry
PR189 Gross Up Calculation
PR192 Nonstandard 12th of Month Calculation
PR195 Accrual Program
PR205 Deduction Listing
PR26.1 United States Employee Garnishment
PR26.2 United States Employee Garnishment Inquiry
PR261 Payment Detail Listing By Report Entity
PR262 Taxable Wage CSV
PR266 Quarterly Tax Balancing Report
PR283 Employees With No Earnings
PR287 Quarterly Federal Tax Return
PR29.1 Pension Payment Maintenance
PR292 Quarterly Unemployment Ins
PR297 W-2 Forms
PR299 EFW2 File Creation
PR30.2 Employee Automatic Time Record
PR300 History Purge
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR39.1 One Time Deduction
PR39.2 One Time Deduction Speed
PR45.1 Error Processing
PR47.1 Canada Employee Garnishment
PR47.2 Canada Employee Garnishment Inquiry
PR512 Employee ACH Distribution Interface
PR514 Employee Deduction Master Load
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR539 One Time Deduction Load
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR797 Benefit EMP YTD Contribution Update
PR80.1 Manual Check
PR80.3 Manual Payment One Time Deduction
PR80.4 Manual Payment
PR82.1 Adjustment
PR85.1 Bank Account Reconciliation
PR89.1 Payment Modeling
PRAT.1 Alltax connection test
TA147 Canada Vacation Audit
UK102 Bonus Pay Update
ZB10.1 Coverage Options Calculator
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add
ZH510 Update PCP from ZPENDPCP

Referenced by (34)

BN232 Benefits Statement
BN330 Defined Contribution Plan Contributions
BN340 ADP and ACP Tests
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
PR125 Employee Wages for Employment Health Tax
PR141 Payroll Register
PR142 Consolidated Payroll Register
PR160 Payment Print
PR180 Manual Payment Print
PR197 Payroll Close
PR226 United States Employee Garnishment Listing
PR247 Canada Employee Garnishment Listing
PR250 1099-R Form Reporting
PR251 1099-R File Creation
PR253 1099-R Reporting
PR260 Payment Detail Listing
PR274 Statistics Canada
PR275 Deduction Report
PR276 Employee Deduction Report
PR277 Garnishment History Report
PR279 Benefit Deduction Audit Report
PR282 Canada Record of Employment
PR418 Canada Workers Compensation Report
PR50.2 United States Payment Inquiry
PR51.1 Pay Stub Inquiry
PR51.2 Pay Stub Inquiry
PR86.1 Payment Replacement
ZP551 Triad FSA Export Interface
ZP552 Fidelity - BiWeekly
ZP554 Union Dues - BiWeekly
ZP555 HealthEquity Export Interface
ZP557 Foundation - BiWeekly
ZP559 Create MetLife Pay Confirm