Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAYDEDUCTN


                            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
BN71.1    BN72.1    BS13.1    BS14.1    BS15.1    BS32.1
HR170     HR70.1    PR125     PR141     PR142     PR160
PR180     PR197     PR226     PR247     PR260     PR275
PR276     PR277     PR282     PR418     PR50.2    PR51.1
PR51.2    PR51.3    PR86.1    UK141     UK145     UK201
UK202     UK277     UK50.1    UK50.3    UK50.5    TP140
BN104     BN150     PR128     PR130     PR131     PR132
PR134     PR136     PR14.1    PR15.1    PR15.2    PR205
PR26.1    PR26.2    PR29.1    PR32.2    PR33.2    PR33.3
PR35.1    PR35.2    PR35.3    PR35.4    PR35.5    PR35.6
PR35.8    PR35.9    PR39.1    PR39.2    PR47.1    PR47.2
PR529     PR530     UK102     UK47.1    UK47.2    TA147
TP135     PR283

UPDATED BY

HR11.1    HR11.2    HR511     PA02.1    PA100     PA102
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    PR300     PR45.1    PR560
PR82.1    PR85.1    PR36.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PYD-COMPANY            Numeric 4                                 PR560   PR82.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PYD-EMPLOYEE           Numeric 9                                 PR560   PR82.1
Element: Employee      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.

PYD-CHECK-ID           Numeric 12                                PR560   PR82.1
Internal Check ID      Contains the payment identification       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                                   PR560   PR82.1
Element: Deduction CodeContains the employee deduction.

PYD-PROCESS-LEVEL      Alpha 5                                   PR560   PR82.1
Element: Process Lev HrThis field contains the tax reporting
                       process level.

PYD-WORK-STATE         Alpha 2                                   PR560   PR82.1
Element: Work State    Identifies the state in which the
                       workers' compensation plan is affective.


PYD-PAYROLL-YEAR       Numeric 4                                 PR560   PR82.1
Element: Current PayrolContains the year portion of the          PR85.1
                       payment date.

PYD-QUARTER            Numeric 1                                 PR560   PR82.1
Element: Quarter       Contains the quarter number associated    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                               HR70.1  PR197
Element: Deduction AmouContains the deduction amount taken on    PR50.2  PR51.1
                       a payment. The system rolls the           PR51.2  PR560
                       deduction amount into the employee's      PR82.1  PR85.1
                       year-to-date deduction amount.            UK50.1  UK50.3

PYD-TAX-WAGES          Signed 13.2                               PR560   PR82.1
Element: Taxable Wages Contains the taxable wages for a          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                               PR560   PR82.1
Element: Wage Amount   Contains the sum of all wage amounts      PR85.1
                       from time records for pay codes tied to
                       this pay summary group.

PYD-EXCESS             Signed 13.2                               PR560   PR82.1
Element: Excess        Contains the total amount of wages that   PR85.1
                       exceed the defined limit of wages
                       subject to unemployment taxes.

PYD-GARN-OBJ-ID        Numeric 12                                PR560   PR82.1
Element: 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
Element: 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
Element: Bus Nbr Grp   Contains the business number group.

PYD-QC-ENT-NBR-GRP     Alpha 4                                   PR560   PR82.1
Element: Qc Ent Nbr GrpContains 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
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

PYD-CURR-ND            Numeric 1                                 PR560   PR82.1
Account Currency       Represents the number of decimals
Code                   defined for the currency of the object.

PYD-CHECK-DATE         Numeric 8  (yyyymmdd)                     PR560   PR82.1
Element: Payment Date  The payment date.

PYD-PER-END-DATE       Numeric 8  (yyyymmdd)                     PR560   PR82.1
Element: Period End DatIdentifies period end date in             PR85.1
                       distribution record; used during PR198
                       to relieve salary encumbrance
                       commitments for pay period (updated from
                       TIMERECORD.PER-END-DATE).

PYD-BALANCE-TYPE       Alpha 1                                   PR560   PR82.1
Element: Balance Type  A = Ascending
                       D = Descending
                       " "

PYD-TAX-FLAG           Alpha 1                                   PR560   PR82.1
Element: Tax Flag      T = Tax
                       S = Tax Status
                       " " = Non-tax

PYD-HM-PROCESS-LEV     Alpha 5                                   HR11.1  HR11.2
Element: Process Lev Hr                                          HR511   PA02.1
                                                                 PA100   PA102
                                                                 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  PR560
                                                                 PR82.1

PYD-COUNTRY-CODE       Alpha 2                                   PR560   PR82.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

PYD-NI-CODE            Alpha 1
Element: Ni Code

PYD-DIRECTOR           Alpha 1
Element: Director

PYD-TAX-CODE           Alpha 10
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


PYD-TAX-BASIS          Alpha 1
Element: Tax Basis

PYD-PERIOD-NBR         Numeric 3                                 PR82.1
Element: Period Nbr

PYD-CONTRACTED-OUT     Alpha 1
Element: Contracted Out

PYD-OT-PLAN-CODE       Alpha 4
Element: Ot Plan Code  Identifies pay plan in effect for
                       employee when PRDISTRIB record was
                       created from PR197 (PRPRD).

                         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                                          BN531   BN65.1
          WORK-STATE                                             BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 HR11.1  HR11.2
                                                                 HR170   HR511
                                                                 HR70.1  PA02.1
                                                                 ...

PYDSET3   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          DED-CODE                                               BN104   BN105
          EDM-SEQ-NBR                                            BN145   BN150
          CHECK-ID                                               BN245   BN31.1
          REPORT-ENTITY                                          BN31.2  BN32.1
          BUS-NBR-GRP                                            BN32.2  BN32.3
          QC-ENT-NBR-GRP                                         BN45.1  BN531
          PROCESS-LEVEL                                          BN65.1  BN71.1
          WORK-STATE                                             BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HR11.1
                                                                 HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 ...

PYDSET4   COMPANY       KeyChange                                PR283
          EMPLOYEE
          DED-CODE
          PER-END-DATE
          CHECK-ID
          EDM-SEQ-NBR
          REPORT-ENTITY
          BUS-NBR-GRP
          QC-ENT-NBR-GRP
          PROCESS-LEVEL
          WORK-STATE

PYDSET5   COMPANY       Subset
          EMPLOYEE      Where COUNTRY-CODE = "UK"
          DED-CODE      Or    COUNTRY-CODE = "GB"
          PAYROLL-YEAR
          OT-PLAN-CODE
          PERIOD-NBR
          REPORT-ENTITY
          EDM-SEQ-NBR
          CHECK-ID

PYDSET6   COMPANY       KeyChange
          HM-PROCESS-LEV
          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       RELATED
 NAME           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       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
                                                     QTD-PENSION