PREMDEDHST – Employee Deduction History
- System
- Payroll (PR)
- Prefix
PDH- Primary key
COMPANY,EMPLOYEE,DED-CODE,SEQ-NBR,YEAR,PERIOD-NBR,REPORT-ENTITY- Fields
- 48
- Updated by
- 50 programs
- Referenced by
- 90 programs
PREMDEDHST is the Employee Deduction History table in Lawson Payroll (prefix PDH). It is indexed by COMPANY, EMPLOYEE, DED-CODE, SEQ-NBR, YEAR, PERIOD-NBR, REPORT-ENTITY (PDHSET1); alternate indexes: PDHSET2, PDHSET4 and PDHSET5. It is related 1:1 to PRSYSTEM, DEDCODE, EMDEDMASTR and EMPLOYEE. It is updated by BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 and 42 more and referenced by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 82 more. The table has 48 fields, 4 indexes and 4 documented relations.
About PREMDEDHST
This file contains employee deduction totals by month and is used in displaying year-to-date deduction amounts.
Fields (48)
Column = COBOL field name without the PDH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PDH-COMPANY PKCOMPANY | Numeric 4 | — | PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-EMPLOYEE PKEMPLOYEE | 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. | PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-DED-CODE PKDED_CODE | Alpha 4 | Contains the deduction code. | PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-SEQ-NBR PKSEQ_NBR | Numeric 4 | Contains the automatically assigned sequence number for the deduction. | PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-YEAR PKYEAR | Numeric 4 | Contains the fiscal year for the data stored on this record. | PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-DED-AMTDED_AMT | Signed 13.2 Occurs 13 Times ×13 | Contains the deduction amount. | PR195, PR197, PR52.1, PR560, PR582, PR80.2, PR82.1, PR85.1 |
PDH-WAGE-AMOUNTWAGE_AMOUNT | Signed 13.2 Occurs 13 Times ×13 | Contains the sum of all wage amounts from the time records. | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-UI-WORKED-12UI_WORKED_12 | Numeric 1 Occurs 13 Times ×13 | Contains the numeric identifier for employees who worked the pay period that includes the 12th
| PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-REPORT-ENTITY PKREPORT_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. | PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-COUNTRY-CODECOUNTRY_CODE | Alpha 2 | The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-WAGE-TO-LELWAGE_TO_LEL | Signed 7.2 Occurs 13 Times ×13 | — | — |
PDH-WAGE-TO-UELWAGE_TO_UEL | Signed 7.2 Occurs 13 Times ×13 | — | — |
PDH-WAGE-TO-ETWAGE_TO_ET | Signed 7.2 Occurs 13 Times ×13 | — | — |
PDH-ERNI-REBATEERNI_REBATE | Signed 7.2 Occurs 13 Times ×13 | — | — |
PDH-EENI-REBATEEENI_REBATE | Signed 7.2 Occurs 13 Times ×13 | — | — |
PDH-P45-GROSSP45_GROSS | Signed 7.2 Occurs 13 Times ×13 | — | — |
PDH-P45-TAXP45_TAX | Signed 7.2 Occurs 13 Times ×13 | — | — |
PDH-OT-PLAN-CODEOT_PLAN_CODE | Alpha 4 Occurs 13 Times ×13 | Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD). | — |
PDH-PERIOD-NBR PKPERIOD_NBR | Numeric 3 | — | PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PDH-HM-PROC-LEVELHM_PROC_LEVEL | Alpha 5 | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more |
PDH-DED-AMT-DYEARDED_AMT_DYEAR | Derived | — | — |
PDH-DED-AMT-D01DED_AMT_D01 | Derived | — | — |
PDH-DED-AMT-D02DED_AMT_D02 | Derived | — | — |
PDH-DED-AMT-D03DED_AMT_D03 | Derived | — | — |
PDH-DED-AMT-D04DED_AMT_D04 | Derived | — | — |
PDH-DED-AMT-D05DED_AMT_D05 | Derived | — | — |
PDH-DED-AMT-D06DED_AMT_D06 | Derived | — | — |
PDH-DED-AMT-D07DED_AMT_D07 | Derived | — | — |
PDH-DED-AMT-D08DED_AMT_D08 | Derived | — | — |
PDH-DED-AMT-D09DED_AMT_D09 | Derived | — | — |
PDH-DED-AMT-D10DED_AMT_D10 | Derived | — | — |
PDH-DED-AMT-D11DED_AMT_D11 | Derived | — | — |
PDH-DED-AMT-D12DED_AMT_D12 | Derived | — | — |
PDH-WAGE-AMT-DYEARWAGE_AMT_DYEAR | Derived | — | — |
PDH-WAGE-AMT-D01WAGE_AMT_D01 | Derived | — | — |
PDH-WAGE-AMT-D02WAGE_AMT_D02 | Derived | — | — |
PDH-WAGE-AMT-D03WAGE_AMT_D03 | Derived | — | — |
PDH-WAGE-AMT-D04WAGE_AMT_D04 | Derived | — | — |
PDH-WAGE-AMT-D05WAGE_AMT_D05 | Derived | — | — |
PDH-WAGE-AMT-D06WAGE_AMT_D06 | Derived | — | — |
PDH-WAGE-AMT-D07WAGE_AMT_D07 | Derived | — | — |
PDH-WAGE-AMT-D08WAGE_AMT_D08 | Derived | — | — |
PDH-WAGE-AMT-D09WAGE_AMT_D09 | Derived | — | — |
PDH-WAGE-AMT-D10WAGE_AMT_D10 | Derived | — | — |
PDH-WAGE-AMT-D11WAGE_AMT_D11 | Derived | — | — |
PDH-WAGE-AMT-D12WAGE_AMT_D12 | Derived | — | — |
Indexes (4)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PDHSET1 | COMPANY, EMPLOYEE, DED-CODE, SEQ-NBR, YEAR, PERIOD-NBR, REPORT-ENTITY | Primary | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source) | |
PDHSET2 | COMPANY, EMPLOYEE, YEAR, DED-CODE, SEQ-NBR, REPORT-ENTITY, PERIOD-NBR | BN66.1, HR170, HR70.1, PR11.3, PR140, PR160, PR180, PR189 +10 more | ||
PDHSET4 | COMPANY, EMPLOYEE, DED-CODE, YEAR, PERIOD-NBR, REPORT-ENTITY, SEQ-NBR* | Subset | Where COUNTRY-CODE = "UK" Or COUNTRY-CODE = "GB" | — |
PDHSET5 | COMPANY, HM-PROC-LEVEL, EMPLOYEE, DED-CODE, SEQ-NBR, YEAR, PERIOD-NBR, REPORT-ENTITY | KeyChange | BN66.1, PR139, PR140, PR189, PR195, PR560, PR80.1, PR80.4 +2 more |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | PDH-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Deduction Code | DEDCODE | Required | PDH-COMPANY → DDC-COMPANY, PDH-DED-CODE → DDC-DED-CODE | |
| Emp Deduction | EMDEDMASTR | Required | PDH-COMPANY → EDM-COMPANY, PDH-EMPLOYEE → EDM-EMPLOYEE, PDH-DED-CODE → EDM-DED-CODE, PDH-SEQ-NBR → EDM-SEQ-NBR | |
| Employee | EMPLOYEE | Required | PDH-COMPANY → EMP-COMPANY, PDH-EMPLOYEE → EMP-EMPLOYEE |
Programs
Updated by (50)
- BN305 Highly Compensated Employees
- BN66.1 Estimated Pay Calculation
- HR11.1 Employee
- HR11.2 Compensation Analysis
- HR11.4 Employee Assignment Inquiry
- HR28.1 Employee Ethnicity
- HR511 Employee Conversion
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA02.1 Position
- PA100 Action Update
- PA102 Position Update
- PA115 Employee Purge
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA502 Position Conversion
- PA513 Position and Job Conversion
- PA52.1 Individual Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PR11.3 Employee HIRE Act Tax Reporting Info
- PR110 Step And Grade Audit
- PR113 United States Tax Deduction Update
- PR12.6 Employee Automatic Deposit
- PR120 Mass Pay Update
- PR13.1 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR13.6 Employee Canada Taxes
- PR13.8 U.S. Tax Deduction Errors
- PR13.9 Employee Additional Tax Details
- PR139 Arrears Automation
- PR140 Earnings and Deductions Calculation
- PR189 Gross Up Calculation
- PR192 Nonstandard 12th of Month Calculation
- PR195 Accrual Program
- PR197 Payroll Close
- PR287 Quarterly Federal Tax Return
- PR30.2 Employee Automatic Time Record
- PR300 History Purge
- PR512 Employee ACH Distribution Interface
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR82.1 Adjustment
- PR85.1 Bank Account Reconciliation
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test
- ZH510 Update PCP from ZPENDPCP
Referenced by (90)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN104 Frequency Table Update
- BN105 Plan Update
- BN145 Flex Dollars Calculation
- BN150 Life Insurance Reportable Income
- BN245 Benefit Election Form
- BN31.1 Speed Benefit Entry
- BN31.2 Employee Benefit Entry
- BN32.1 Employee Benefit Changes
- BN32.2 Employee Benefit Detail Changes
- BN32.3 Benefit Add
- BN45.1 Employee Flex Credits
- BN531 Batch Benefit Enrollment
- BN65.1 Election Simulation
- BN71.1 COBRA Benefit Entry
- BN72.1 Retiree Benefit Entry
- BS10.1 Web Enrollment Current Benefit Inquiry
- BS12.1 Web Enrollment Eligible New Plans
- BS13.1 Web Enrollment Coverage Options
- BS14.1 Web Enrollment Coverage Amounts
- BS15.1 Web Enrollment Contribution Limits
- BS32.1 Web Enrollment Stop Benefits Update
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- HR170 Human Resource Writer Report Request
- HR70.1 Human Resource Writer Inquiry
- LP130 Absence Plan Payout
- PR05.1 Deduction
- PR128 Offset Time Record Creation
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR14.1 Employee Deduction
- PR14.2 Tax Withholding Lock-In
- PR15.1 Deduction Speed Entry
- PR15.2 Employee Deduction Speed Entry
- PR160 Payment Print
- PR180 Manual Payment Print
- PR205 Deduction Listing
- PR214 Employee Deduction Listing
- PR252 United States Territory W-2 Form Printing
- PR26.1 United States Employee Garnishment
- PR26.2 United States Employee Garnishment Inquiry
- PR29.1 Pension Payment Maintenance
- PR291 Unemployment Continuation Form
- PR292 Quarterly Unemployment Ins
- PR297 W-2 Forms
- PR299 EFW2 File Creation
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR39.1 One Time Deduction
- PR39.2 One Time Deduction Speed
- PR45.1 Error Processing
- PR47.1 Canada Employee Garnishment
- PR47.2 Canada Employee Garnishment Inquiry
- PR514 Employee Deduction Master Load
- PR52.1 Payroll History - Year To Date
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR539 One Time Deduction Load
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update
- ZB10.1 Coverage Options Calculator
- ZB31.1 Speed Benefit Entry
- ZB31.2 Employee Benefit Entry
- ZB32.1 Employee Benefit Changes
- ZB32.2 Employee Benefit Detail Changes
- ZB32.3 Benefit Add
- ZP557 Foundation - BiWeekly