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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PDH-COMPANY PK
COMPANY		Numeric 4—PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1
#PDH-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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 PK
DED_CODE		Alpha 4Contains the deduction code.PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1
#PDH-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the automatically assigned sequence number for the deduction.PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1
#PDH-YEAR PK
YEAR		Numeric 4Contains the fiscal year for the data stored on this record.PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1
#PDH-DED-AMT
DED_AMT		Signed 13.2 Occurs 13 Times ×13Contains the deduction amount.PR195, PR197, PR52.1, PR560, PR582, PR80.2, PR82.1, PR85.1
#PDH-WAGE-AMOUNT
WAGE_AMOUNT		Signed 13.2 Occurs 13 Times ×13Contains the sum of all wage amounts from the time records.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#PDH-UI-WORKED-12
UI_WORKED_12		Numeric 1 Occurs 13 Times ×13Contains the numeric identifier for employees who worked the pay period that includes the 12th
  • 0 Did Not Work
  • 1 Did Work
PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1
#PDH-REPORT-ENTITY PK
REPORT_ENTITY		Alpha 5Contains 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-CODE
COUNTRY_CODE		Alpha 2The 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-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).PR195, PR197, PR560, PR582, PR82.1, PR85.1
#PDH-CURR-ND
CURR_ND		Numeric 1The 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-LEL
WAGE_TO_LEL		Signed 7.2 Occurs 13 Times ×13——
#PDH-WAGE-TO-UEL
WAGE_TO_UEL		Signed 7.2 Occurs 13 Times ×13——
#PDH-WAGE-TO-ET
WAGE_TO_ET		Signed 7.2 Occurs 13 Times ×13——
#PDH-ERNI-REBATE
ERNI_REBATE		Signed 7.2 Occurs 13 Times ×13——
#PDH-EENI-REBATE
EENI_REBATE		Signed 7.2 Occurs 13 Times ×13——
#PDH-P45-GROSS
P45_GROSS		Signed 7.2 Occurs 13 Times ×13——
#PDH-P45-TAX
P45_TAX		Signed 7.2 Occurs 13 Times ×13——
#PDH-OT-PLAN-CODE
OT_PLAN_CODE		Alpha 4 Occurs 13 Times ×13Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).—
#PDH-PERIOD-NBR PK
PERIOD_NBR		Numeric 3—PR192, PR195, PR197, PR560, PR582, PR82.1, PR85.1
#PDH-HM-PROC-LEVEL SET5
HM_PROC_LEVEL		Alpha 5—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#PDH-DED-AMT-DYEAR
DED_AMT_DYEAR		Derived——
#PDH-DED-AMT-D01
DED_AMT_D01		Derived——
#PDH-DED-AMT-D02
DED_AMT_D02		Derived——
#PDH-DED-AMT-D03
DED_AMT_D03		Derived——
#PDH-DED-AMT-D04
DED_AMT_D04		Derived——
#PDH-DED-AMT-D05
DED_AMT_D05		Derived——
#PDH-DED-AMT-D06
DED_AMT_D06		Derived——
#PDH-DED-AMT-D07
DED_AMT_D07		Derived——
#PDH-DED-AMT-D08
DED_AMT_D08		Derived——
#PDH-DED-AMT-D09
DED_AMT_D09		Derived——
#PDH-DED-AMT-D10
DED_AMT_D10		Derived——
#PDH-DED-AMT-D11
DED_AMT_D11		Derived——
#PDH-DED-AMT-D12
DED_AMT_D12		Derived——
#PDH-WAGE-AMT-DYEAR
WAGE_AMT_DYEAR		Derived——
#PDH-WAGE-AMT-D01
WAGE_AMT_D01		Derived——
#PDH-WAGE-AMT-D02
WAGE_AMT_D02		Derived——
#PDH-WAGE-AMT-D03
WAGE_AMT_D03		Derived——
#PDH-WAGE-AMT-D04
WAGE_AMT_D04		Derived——
#PDH-WAGE-AMT-D05
WAGE_AMT_D05		Derived——
#PDH-WAGE-AMT-D06
WAGE_AMT_D06		Derived——
#PDH-WAGE-AMT-D07
WAGE_AMT_D07		Derived——
#PDH-WAGE-AMT-D08
WAGE_AMT_D08		Derived——
#PDH-WAGE-AMT-D09
WAGE_AMT_D09		Derived——
#PDH-WAGE-AMT-D10
WAGE_AMT_D10		Derived——
#PDH-WAGE-AMT-D11
WAGE_AMT_D11		Derived——
#PDH-WAGE-AMT-D12
WAGE_AMT_D12		Derived——

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PDHSET1
  1. COMPANY
  2. EMPLOYEE
  3. DED-CODE
  4. SEQ-NBR
  5. YEAR
  6. PERIOD-NBR
  7. REPORT-ENTITY
PrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
PDHSET2
  1. COMPANY
  2. EMPLOYEE
  3. YEAR
  4. DED-CODE
  5. SEQ-NBR
  6. REPORT-ENTITY
  7. PERIOD-NBR
BN66.1, HR170, HR70.1, PR11.3, PR140, PR160, PR180, PR189 +10 more
PDHSET4
  1. COMPANY
  2. EMPLOYEE
  3. DED-CODE
  4. YEAR
  5. PERIOD-NBR
  6. REPORT-ENTITY
  7. SEQ-NBR ↓
SubsetWhere COUNTRY-CODE = "UK" Or COUNTRY-CODE = "GB"—
PDHSET5
  1. COMPANY
  2. HM-PROC-LEVEL
  3. EMPLOYEE
  4. DED-CODE
  5. SEQ-NBR
  6. YEAR
  7. PERIOD-NBR
  8. REPORT-ENTITY
KeyChangeBN66.1, PR139, PR140, PR189, PR195, PR560, PR80.1, PR80.4 +2 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMDEDCODEEMDEDMASTREMPLOYEEPREMDEDHST

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PDH-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Deduction CodeDEDCODERequired
PDH-COMPANY→DDC-COMPANY
PDH-DED-CODE→DDC-DED-CODE
Emp DeductionEMDEDMASTRRequired
PDH-COMPANY→EDM-COMPANY
PDH-EMPLOYEE→EDM-EMPLOYEE
PDH-DED-CODE→EDM-DED-CODE
PDH-SEQ-NBR→EDM-SEQ-NBR
EmployeeEMPLOYEERequired
PDH-COMPANY→EMP-COMPANY
PDH-EMPLOYEE→EMP-EMPLOYEE

Programs

Updated by (50)

Referenced by (90)