Lawson Insight Technical Documentation |
|
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 BN104 BN105
BN145 BN150 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 ET530 ETI1.1 ETI2.1 HR170
HR70.1 LP130 PR125 PR128 PR130 PR131
PR132 PR134 PR136 PR139 PR14.1 PR14.2
PR141 PR142 PR15.1 PR15.2 PR160 PR180
PR197 PR205 PR226 PR247 PR26.1 PR26.2
PR260 PR261 PR262 PR266 PR275 PR276
PR277 PR279 PR282 PR283 PR287 PR29.1
PR32.2 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR39.1 PR39.2 PR418 PR47.1 PR47.2 PR50.2
PR51.1 PR51.2 PR51.3 PR514 PR529 PR530
PR539 PR86.1 UK102 UK13.1 UK141 UK145
UK201 UK202 UK277 UK47.1 UK47.2 UK50.1
UK50.3 UK50.5 TA147 PR274
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
PR140 PR189 PR195 PR300 PR45.1 PR560
PR80.1 PR82.1 PR82.3 PR85.1 PR89.1 UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PYD-COMPANY Numeric 4 BN66.1 PR140
Element: Company Hr PR189 PR195
PR560 PR80.1
PR82.1 PR89.1
UK560
PYD-EMPLOYEE Numeric 9 BN66.1 PR140
Element: Employee Contains the employee number. Each PR189 PR195
person employed by the company is PR560 PR80.1
assigned a unique number. The system PR82.1 PR89.1
uses the employee number to correlate UK560
all of the information related to that
person.
PYD-CHECK-ID Numeric 12 BN66.1 PR140
Element: Check Id Contains the payment identification PR189 PR195
number. When you create a payment PR560 PR80.1
deduction record, the system moves the PR82.1 PR85.1
payment identification number into this PR89.1 UK560
field to serve as the link between the
Employee Payment file record and the
Employee Payment Deductions file record.
PYD-DED-CODE Alpha 4 BN66.1 PR140
Element: Ded Code Contains the employee deduction. PR189 PR195
PR560 PR80.1
PR82.1 PR89.1
UK560
PYD-PROCESS-LEVEL Alpha 5 BN66.1 PR140
Element: Process Lev HrThis field contains the tax reporting PR189 PR195
process level. PR560 PR80.1
PR82.1 PR89.1
UK560
PYD-WORK-STATE Alpha 2 BN66.1 PR140
Element: Work State Identifies the state in which the PR189 PR195
workers' compensation plan is affective. PR560 PR80.1
PR82.1 PR89.1
UK560
PYD-PAYROLL-YEAR Numeric 4 BN66.1 PR140
Element: Payroll Year Contains the year portion of the PR189 PR195
payment date. PR560 PR80.1
PR82.1 PR85.1
PR89.1 UK560
PYD-QUARTER Numeric 1 BN66.1 PR140
Element: Quarter Contains the quarter number associated PR189 PR195
with the payment date. PR560 PR80.1
1 PR82.1 PR85.1
2 PR89.1 UK560
3
4
PYD-EDM-SEQ-NBR Numeric 4 BN66.1 PR140
Element: Edm Seq Nbr Contains the employee deduction PR189 PR195
sequence number. PR560 PR80.1
PR82.1 PR89.1
UK560
PYD-DED-AMT Signed 13.2 BN66.1 ET530
Element: Ded Amt Contains the deduction amount taken on HR70.1 PR140
a payment. The system rolls the PR189 PR195
deduction amount into the employee's PR197 PR50.2
year-to-date deduction amount. PR51.1 PR51.2
PR560 PR80.1
PR80.2 PR82.1
PR85.1 PR89.1
UK50.1 UK50.3
UK560
PYD-TAX-WAGES Signed 13.2 BN66.1 PR140
Element: Tax Wages Contains the taxable wages for a PR189 PR195
payment. The system uses this field to PR560 PR80.1
calculate a withholding type deduction. PR82.1 PR85.1
The system rolls the taxable wages into PR89.1 UK560
the employee's year-to-date wage amount.
PYD-WAGE-AMOUNT Signed 13.2 BN66.1 PR140
Element: Wage Amount Contains the sum of all wage amounts PR189 PR195
from time records for pay codes tied to PR560 PR80.1
this pay summary group. PR82.1 PR85.1
PR89.1 UK560
PYD-EXCESS Signed 13.2 BN66.1 PR140
Element: Excess Contains the total amount of wages that PR189 PR195
exceed the defined limit of wages PR560 PR80.1
subject to unemployment taxes. PR82.1 PR85.1
PR89.1 UK560
PYD-GARN-OBJ-ID Numeric 12 BN66.1 PR140
Element: Garn Obj Id Assigned when an employee garnishment PR189 PR195
table (PREMPGARN) is added and PR560 PR80.1
deductions are created. This ID links PR82.1 PR89.1
the employee deductions to this UK560
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 BN66.1 PR140
Element: Report Entity Contains the report entity. PR189 PR195
PR560 PR80.1
Report Entity is the Process Level or PR82.1 PR89.1
Company that this Process Level reports UK560
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 BN66.1 PR140
Element: Bus Nbr Grp Contains the business number group. PR189 PR195
PR560 PR80.1
PR82.1 PR89.1
UK560
PYD-QC-ENT-NBR-GRP Alpha 4 BN66.1 PR140
Element: Qc Ent Nbr GrpContains the Quebec enterprise number PR189 PR195
group. PR560 PR80.1
PR82.1 PR89.1
UK560
PYD-OBJ-ID Numeric 12 BN66.1 PR140
Element: Obj Id This is the object identifier. It is PR189 PR195
used to relate commitments or posted PR80.1 PR85.1
transactions back to the originating PR89.1
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 BN66.1 PR140
Element: Currency Code This field contains the company base PR189 PR195
currency code established in Company PR560 PR80.1
(GL10.1 ). PR82.1 PR89.1
UK560
PYD-CURR-ND Numeric 1 BN66.1 PR140
Element: Acct Nd The number of decimals assigned to a PR189 PR195
particular account as determined by the PR560 PR80.1
account currency. PR82.1 PR89.1
UK560
PYD-CHECK-DATE Numeric 8 (yyyymmdd) BN66.1 PR140
Element: Check Date The payment date. PR189 PR195
PR560 PR80.1
PR82.1 PR89.1
UK560
PYD-PER-END-DATE Numeric 8 (yyyymmdd) BN66.1 PR140
Element: Per End Date Identifies period end date in PR189 PR195
distribution record; used during PR198 PR560 PR80.1
to relieve salary encumbrance PR82.1 PR85.1
commitments for pay period (updated from PR89.1 UK560
TIMERECORD.PER-END-DATE).
PYD-BALANCE-TYPE Alpha 1 BN66.1 PR140
Element: Balance Type A = Ascending PR189 PR195
D = Descending PR560 PR80.1
" " PR82.1 PR89.1
UK560
PYD-TAX-FLAG Alpha 1 BN66.1 PR140
Element: Tax Flag T = Tax PR189 PR195
S = Tax Status PR560 PR80.1
" " = Non-tax PR82.1 PR89.1
UK560
PYD-HM-PROCESS-LEV Alpha 5 BN305 BN66.1
Element: Process Lev Hr 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
PR140 PR189
PR195 PR560
PR80.1 PR82.1
PR89.1 UK560
PYD-COUNTRY-CODE Alpha 2 BN66.1 PR140
Element: Country Code The country code. Required for VAT and PR189 PR195
intrastat reporting. Must be defined in PR560 PR80.1
IN01.1 (Country Maintenance). PR82.1 PR89.1
UK560
PYD-NI-CODE Alpha 1 BN66.1 PR140
Element: Ni Code PR189 PR195
PR80.1 PR82.1
PR82.3 PR89.1
UK560
PYD-DIRECTOR Alpha 1 BN66.1 PR140
Element: Director PR189 PR195
PR80.1 PR82.1
PR82.3 PR89.1
UK560
PYD-TAX-CODE Alpha 10 BN66.1 PR140
Element: Tax Code This field contains a code representing PR189 PR195
specific tax information. This must be PR80.1 PR82.1
valid Tax Code. PR89.1 UK560
PYD-TAX-BASIS Alpha 1 BN66.1 PR140
Element: Tax Basis PR189 PR195
PR80.1 PR82.1
PR89.1 UK560
PYD-PERIOD-NBR Numeric 3 BN66.1 PR140
Element: Period Nbr PR189 PR195
PR80.1 PR82.1
PR89.1
PYD-CONTRACTED-OUT Alpha 1 BN66.1 PR140
Element: Contracted Out PR189 PR195
PR80.1 PR82.1
PR82.3 PR89.1
UK560
PYD-OT-PLAN-CODE Alpha 4 BN66.1 PR140
Element: Ot Plan Code Identifies pay plan in effect for PR189 PR195
employee when PRDISTRIB record was PR80.1 PR82.1
created from PR197 (PRPRD). PR89.1
PAYDEDUCTN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PYDSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
CHECK-ID BN104 BN105
DED-CODE BN145 BN150
EDM-SEQ-NBR BN232 BN245
REPORT-ENTITY BN305 BN31.1
BUS-NBR-GRP BN31.2 BN32.1
QC-ENT-NBR-GRP BN32.2 BN32.3
PROCESS-LEVEL BN330 BN340
WORK-STATE BN45.1 BN531
BN65.1 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
...
PYDSET3 COMPANY PR274
EMPLOYEE
DED-CODE
EDM-SEQ-NBR
CHECK-ID
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
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
|