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
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PYD-COMPANY Element: Company Hr | Numeric 4 |
|
||||||||||||||||||||
| PYD-EMPLOYEE Element: 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. |
|
||||||||||||||||||||
| PYD-CHECK-ID Element: 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. |
|
||||||||||||||||||||
| PYD-DED-CODE Element: Ded Code | Alpha 4 Contains the employee deduction. |
|
||||||||||||||||||||
| PYD-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 This field contains the tax reporting process level. |
|
||||||||||||||||||||
| PYD-WORK-STATE Element: Work State | Alpha 2 Identifies the state in which the workers' compensation plan is affective. |
|
||||||||||||||||||||
| PYD-PAYROLL-YEAR Element: Payroll Year | Numeric 4 Contains the year portion of the payment date. |
|
||||||||||||||||||||
| PYD-QUARTER Element: Quarter | Numeric 1 Contains the quarter number associated with the payment date. 1 2 3 4 |
|
||||||||||||||||||||
| PYD-EDM-SEQ-NBR Element: Edm Seq Nbr | Numeric 4 Contains the employee deduction sequence number. |
|
||||||||||||||||||||
| PYD-DED-AMT Element: 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. |
|
||||||||||||||||||||
| PYD-TAX-WAGES Element: 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. |
|
||||||||||||||||||||
| PYD-WAGE-AMOUNT Element: Wage Amount | Signed 13.2 Contains the sum of all wage amounts from time records for pay codes tied to this pay summary group. |
|
||||||||||||||||||||
| PYD-EXCESS Element: Excess | Signed 13.2 Contains the total amount of wages that exceed the defined limit of wages subject to unemployment taxes. |
|
||||||||||||||||||||
| PYD-GARN-OBJ-ID Element: 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. |
|
||||||||||||||||||||
| PYD-REPORT-ENTITY Element: 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. |
|
||||||||||||||||||||
| PYD-BUS-NBR-GRP Element: Bus Nbr Grp | Alpha 4 Contains the business number group. |
|
||||||||||||||||||||
| PYD-QC-ENT-NBR-GRP Element: Qc Ent Nbr Grp | Alpha 4 Contains the Quebec enterprise number group. |
|
||||||||||||||||||||
| PYD-OBJ-ID Element: 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. |
|
||||||||||||||||||||
| PYD-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||||||
| PYD-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||
| PYD-CHECK-DATE Element: Check Date | Numeric 8 (yyyymmdd) The payment date. |
|
||||||||||||||||||||
| PYD-PER-END-DATE Element: 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). |
|
||||||||||||||||||||
| PYD-BALANCE-TYPE Element: Balance Type | Alpha 1 A = Ascending D = Descending " " |
|
||||||||||||||||||||
| PYD-TAX-FLAG Element: Tax Flag | Alpha 1 T = Tax S = Tax Status " " = Non-tax |
|
||||||||||||||||||||
| PYD-HM-PROCESS-LEV Element: Process Lev Hr | Alpha 5 |
|||||||||||||||||||||
| PYD-COUNTRY-CODE Element: Country Code | Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
||||||||||||||||||||
| PYD-NI-CODE Element: Ni Code | Alpha 1 |
|
||||||||||||||||||||
| PYD-DIRECTOR Element: Director | Alpha 1 |
|
||||||||||||||||||||
| PYD-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||||||||||||||||||||
| PYD-TAX-BASIS Element: Tax Basis | Alpha 1 |
|
||||||||||||||||||||
| PYD-PERIOD-NBR Element: Period Nbr | Numeric 3 |
|
||||||||||||||||||||
| PYD-CONTRACTED-OUT Element: Contracted Out | Alpha 1 |
|
||||||||||||||||||||
| PYD-OT-PLAN-CODE Element: Ot Plan Code | Alpha 4 Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD). |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | 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 |
|
| ||||||||||||||||||||||||||||||||||||
| PYDSET3 |
COMPANY EMPLOYEE DED-CODE EDM-SEQ-NBR CHECK-ID REPORT-ENTITY BUS-NBR-GRP QC-ENT-NBR-GRP PROCESS-LEVEL WORK-STATE |
|
| ||||||||||||||||||||||||||||||||||||
| 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 |
|
|||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM |
Required
| ||||||||||||
| Deduct Code | DEDCODE |
Required
| ||||||||||||
| Emp Ded Code | EMDEDMASTR |
Required
| ||||||||||||
| Employee | EMPLOYEE |
Required
| ||||||||||||
| Payment | PAYMASTR |
Required
| ||||||||||||
| Process Level | PRSYSTEM |
Required
| ||||||||||||
| Prqcentgrp | PRQCENTGRP |
Not Required
| ||||||||||||
| Tax Id | PRTAXAUTH |
Required
| ||||||||||||
| Work State | PRSTATE |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Prdeddtl | PRDEDDTL |
| ||||||||||||||||||||||||||||||||||||
| Quartded | QUARTDED |
|
All trademarks and registered trademarks are the property of their
respective owners.