PREMDEDHST

Employee Deduction History

This file contains employee deduction totals by month and is used in displaying year-to-date deduction amounts.

REFERENCED BY
PR11.3 PR252 PR287 PR291 UK145 UK202


UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN245 BN305 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN45.1 BN531 BN65.1
BN66.1 BN71.1 BN72.1 BS13.1 BS14.1 BS15.1
BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 HR11.1 HR11.2 HR170 HR28.1 HR511
HR70.1 LT101 PR521 ZH510 EXI2.1 EXI4.1
LP130 PA02.1 PA100 PA102 PA115 PA13.1
PA13.2 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PR05.1 PR110 PR113 PR12.6 PR120
PR128 PR13.1 PR13.2 PR13.5 PR13.6 PR13.8
PR13.9 PR130 PR131 PR132 PR134 PR135
PR136 PR137 PR139 PR14.1 PR14.2 PR140
PR15.1 PR15.2 PR160 PR180 PR189 PR192
PR195 PR197 PR205 PR214 PR26.1 PR26.2
PR29.1 PR292 PR297 PR299 PR30.2 PR300
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR37.1 PR39.1 PR39.2 PR45.1
PR47.1 PR47.2 PR514 PR52.1 PR529 PR530
PR539 PR560 PR582 PR80.1 PR80.2 PR80.3
PR80.4 PR82.1 PR85.1 PR89.1 UK102 UK13.1
UK201 UK47.1 UK47.2 UK50.2 UK560 ZP530
ZP557 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDH-COMPANY
Element: Company Hr		Numeric 4
PR192 PR195
PR197 PR560
PR582 PR82.1
PR85.1 UK13.1
UK560
PDH-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.
PR192 PR195
PR197 PR560
PR582 PR82.1
PR85.1 UK13.1
UK560
PDH-DED-CODE
Element: Ded Code		Alpha 4
Contains the deduction code.
PR192 PR195
PR197 PR560
PR582 PR82.1
PR85.1 UK13.1
UK560
PDH-SEQ-NBR
Element: Seq Nbr		Numeric 4
Contains the automatically assigned sequence number for the deduction.
PR192 PR195
PR197 PR560
PR582 PR82.1
PR85.1 UK13.1
UK560
PDH-YEAR
Element: Year		Numeric 4
Contains the fiscal year for the data stored on this record.
PR192 PR195
PR197 PR560
PR582 PR82.1
PR85.1 UK13.1
UK560
PDH-DED-AMT
Element: Ded Amt		Signed 13.2 Occurs 13 Times
Contains the deduction amount.
PR195 PR197
PR52.1 PR560
PR582 PR80.2
PR82.1 PR85.1
UK560
PDH-WAGE-AMOUNT
Element: Wage Amount		Signed 13.2 Occurs 13 Times
Contains the sum of all wage amounts from the time records.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PDH-UI-WORKED-12
Element: Ui Worked 12		Numeric 1 Occurs 13 Times
Contains the numeric identifier for employees who worked the pay period that includes the 12th
0 = Did Not Work
1 = Did Work
PR192 PR195
PR197 PR582
PR82.1 PR85.1
PDH-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.
PR192 PR195
PR197 PR560
PR582 PR82.1
PR85.1 UK13.1
UK560
PDH-COUNTRY-CODE
Element: Country 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
UK13.1 UK560
PDH-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PDH-CURR-ND
Element: Acct 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
UK560
PDH-WAGE-TO-LEL
Element: Wage To Lel		Signed 7.2 Occurs 13 Times
PR195 PR197
PR582 PR82.1
PR85.1 UK560
PDH-WAGE-TO-UEL
Element: Wage To Uel		Signed 7.2 Occurs 13 Times
PR195 PR197
PR582 PR82.1
PR85.1 UK560
PDH-WAGE-TO-ET
Element: Wage To Et		Signed 7.2 Occurs 13 Times
PR195 PR197
PR582 PR82.1
PR85.1 UK560
PDH-ERNI-REBATE
Element: Erni Rebate		Signed 7.2 Occurs 13 Times
PR195 PR197
PR582 PR82.1
PR85.1 UK560
PDH-EENI-REBATE
Element: Eeni Rebate		Signed 7.2 Occurs 13 Times
PR195 PR197
PR582 PR82.1
PR85.1 UK560
PDH-P45-GROSS
Element: P45 Gross		Signed 7.2 Occurs 13 Times
UK13.1
PDH-P45-TAX
Element: P45 Tax		Signed 7.2 Occurs 13 Times
UK13.1
PDH-OT-PLAN-CODE
Element: Ot Plan Code		Alpha 4 Occurs 13 Times
Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).
PR195 PR197
PR582 PR82.1
PR85.1 UK560
PDH-PERIOD-NBR
Element: Period Nbr		Numeric 3
PR192 PR195
PR197 PR560
PR582 PR82.1
PR85.1 UK13.1
UK560
PDH-HM-PROC-LEVEL
Element: Process Lev Hr		Alpha 5
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR195
PR197 PR30.2
PR560 PR582
PR82.1 PR85.1
UK560 ZH510
PDH-DED-AMT-DYEAR
Element: Ded Amt Dyear		Derived
PDH-DED-AMT-D01
Element: Ded Amt D01		Derived
PDH-DED-AMT-D02
Element: Ded Amt D02		Derived
PDH-DED-AMT-D03
Element: Ded Amt D03		Derived
PDH-DED-AMT-D04
Element: Ded Amt D04		Derived
PDH-DED-AMT-D05
Element: Ded Amt D05		Derived
PDH-DED-AMT-D06
Element: Ded Amt D06		Derived
PDH-DED-AMT-D07
Element: Ded Amt D07		Derived
PDH-DED-AMT-D08
Element: Ded Amt D08		Derived
PDH-DED-AMT-D09
Element: Ded Amt D09		Derived
PDH-DED-AMT-D10
Element: Ded Amt D10		Derived
PDH-DED-AMT-D11
Element: Ded Amt D11		Derived
PDH-DED-AMT-D12
Element: Ded Amt D12		Derived
PDH-WAGE-AMT-DYEAR
Element: Wage Amt Dyear		Derived
PDH-WAGE-AMT-D01
Element: Wage Amt D01		Derived
PDH-WAGE-AMT-D02
Element: Wage Amt D02		Derived
PDH-WAGE-AMT-D03
Element: Wage Amt D03		Derived
PDH-WAGE-AMT-D04
Element: Wage Amt D04		Derived
PDH-WAGE-AMT-D05
Element: Wage Amt D05		Derived
PDH-WAGE-AMT-D06
Element: Wage Amt D06		Derived
PDH-WAGE-AMT-D07
Element: Wage Amt D07		Derived
PDH-WAGE-AMT-D08
Element: Wage Amt D08		Derived
PDH-WAGE-AMT-D09
Element: Wage Amt D09		Derived
PDH-WAGE-AMT-D10
Element: Wage Amt D10		Derived
PDH-WAGE-AMT-D11
Element: Wage Amt D11		Derived
PDH-WAGE-AMT-D12
Element: Wage Amt D12		Derived


PREMDEDHST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDHSET1 COMPANY
EMPLOYEE
DED-CODE
SEQ-NBR
YEAR
PERIOD-NBR
REPORT-ENTITY
...
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN66.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
PDHSET2 COMPANY
EMPLOYEE
YEAR
DED-CODE
SEQ-NBR
REPORT-ENTITY
PERIOD-NBR
HR170 HR70.1
PR11.3 PR160
PR180 PR292
PR300 PR52.1
PR80.2 UK50.2
ZP557
PDHSET4 COMPANY
EMPLOYEE
DED-CODE
YEAR
PERIOD-NBR
REPORT-ENTITY
SEQ-NBR*
Subset
WhereCOUNTRY-CODE ="UK"
OrCOUNTRY-CODE ="GB"
BN66.1 PR139
PR140 PR160
PR180 PR189
PR195 PR197
PR582 PR80.1
PR80.2 PR80.4
PR82.1 PR85.1
PR89.1 UK145
UK201 UK202
UK560
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
PR89.1 UK560


PREMDEDHST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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

File created: Thu Jun 09 11:27:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.