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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 9Contains 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 12Contains 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 4Contains the employee deduction.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
#PYD-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5This 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 2Identifies 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 SET7
PAYROLL_YEAR		Numeric 4Contains the year portion of the payment date.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +4 more
#PYD-QUARTER
QUARTER		Numeric 1Contains the quarter number associated with the payment date. 1 2 3 4BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +4 more
#PYD-EDM-SEQ-NBR PK
EDM_SEQ_NBR		Numeric 4Contains 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.2Contains 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.2Contains 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.2Contains 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.2Contains 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 12Assigned 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 5Contains 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 4Contains 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 4Contains the Quebec enterprise number group.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
#PYD-OBJ-ID
OBJ_ID		Numeric 12This 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 5This 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 1The 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 SET7
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 SET6
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 2The 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 SET7
TAX_CODE		Alpha 10This 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 4Identifies 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PYDSET1
  1. COMPANY
  2. EMPLOYEE
  3. CHECK-ID
  4. DED-CODE
  5. EDM-SEQ-NBR
  6. REPORT-ENTITY
  7. BUS-NBR-GRP
  8. QC-ENT-NBR-GRP
  9. PROCESS-LEVEL
  10. WORK-STATE
PrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
PYDSET3
  1. COMPANY
  2. EMPLOYEE
  3. DED-CODE
  4. EDM-SEQ-NBR
  5. CHECK-ID
  6. REPORT-ENTITY
  7. BUS-NBR-GRP
  8. QC-ENT-NBR-GRP
  9. PROCESS-LEVEL
  10. WORK-STATE
BN66.1, PR139, PR140, PR189, PR192, PR195, PR274, PR297 +6 more
PYDSET6
  1. COMPANY
  2. HM-PROCESS-LEV
  3. EMPLOYEE
  4. CHECK-ID
  5. DED-CODE
  6. EDM-SEQ-NBR
  7. REPORT-ENTITY
  8. BUS-NBR-GRP
  9. QC-ENT-NBR-GRP
  10. PROCESS-LEVEL
  11. WORK-STATE
KeyChange—
PYDSET7
  1. COMPANY
  2. PAYROLL-YEAR
  3. PER-END-DATE
  4. TAX-CODE
  5. EMPLOYEE
  6. CHECK-ID
  7. DED-CODE
  8. EDM-SEQ-NBR
  9. REPORT-ENTITY
  10. BUS-NBR-GRP
  11. QC-ENT-NBR-GRP
  12. PROCESS-LEVEL
  13. WORK-STATE
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMDEDCODEEMDEDMASTREMPLOYEEPAYMASTRPRQCENTGRPPRTAXAUTHPRSTATEPRDEDDTLQUARTDEDPAYDEDUCTN

One to one (9) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PYD-COMPANY→PRS-COMPANY (PRSSET1)
Spaces→PRS-PROCESS-LEVEL
Deduct CodeDEDCODERequired
PYD-COMPANY→DDC-COMPANY
PYD-DED-CODE→DDC-DED-CODE
Emp Ded CodeEMDEDMASTRRequired
PYD-COMPANY→EDM-COMPANY
PYD-EMPLOYEE→EDM-EMPLOYEE
PYD-DED-CODE→EDM-DED-CODE
PYD-EDM-SEQ-NBR→EDM-SEQ-NBR
EmployeeEMPLOYEERequired
PYD-COMPANY→EMP-COMPANY
PYD-EMPLOYEE→EMP-EMPLOYEE
PaymentPAYMASTRRequired
PYD-COMPANY→PYM-COMPANY
PYD-EMPLOYEE→PYM-EMPLOYEE
PYD-CHECK-ID→PYM-CHECK-ID
Process LevelPRSYSTEMRequired
PYD-COMPANY→PRS-COMPANY
PYD-PROCESS-LEVEL→PRS-PROCESS-LEVEL
PrqcentgrpPRQCENTGRPNot Required
PYD-COMPANY→PQC-COMPANY
PYD-PROCESS-LEVEL→PQC-PROCESS-LEVEL
PYD-QC-ENT-NBR-GRP→PQC-QC-ENT-NBR-GRP
Tax IdPRTAXAUTHRequiredWhen DDC-CALC-TYPE = "T"
DDC-TAX-ID-CODE→PRX-TAX-ID-CODE
Work StatePRSTATERequiredWhen PYD-WORK-STATE != Spaces
PYD-WORK-STATE→PSA-STATE

One to many (2) — child tables

RelationTableRulesConditionField map
PrdeddtlPRDEDDTL
PYD-OBJ-ID→PDE-PYD-OBJ-ID
—→PDE-TAX-STATUS
QuartdedQUARTDED
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)

Referenced by (34)