|
|
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
|
