PREMDEDHST

Employee Deduction History

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

REFERENCED BY
PR252 PR287 PR291 UK145 UK202


UPDATED BY
BN305 HR11.1 HR11.2 HR511 PA02.1 PA100
PA102 PA115 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 PR13.9
PR13.2 PR192 PR195 PR197 PR300 PR560
PR582 PR82.1 PR85.1 UK13.1 UK560 BN100
BN101 BN102 BN103 BN104 BN105 BN145
BN150 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN45.1 BN531 BN65.1 BN66.1 BN71.1
BN72.1 BN729 BN991 BS13.1 BS14.1 BS15.1
BS32.1 HR170 HR70.1 PR521 EXI2.1 EXI4.1
LP130 LP140 PR05.1 PR128 PR130 PR131
PR132 PR134 PR135 PR136 PR137 PR139
PR14.1 PR14.2 PR140 PR15.1 PR15.2 PR189
PR205 PR214 PR26.1 PR26.2 PR29.1 PR297
PR299 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 PR529 PR530
PR539 PR80.1 PR80.3 PR80.4 PR80.2 PR89.1
UK102 UK47.1 UK47.2 TA147 PR160 PR180
PR292 PR52.1 UK50.2 UK201

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 HR511
PA02.1 PA100
PA102 PA115
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 PR13.9
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
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 BN729
BN991 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR170
PDHSET2 COMPANY
EMPLOYEE
YEAR
DED-CODE
SEQ-NBR
REPORT-ENTITY
PERIOD-NBR
HR170 HR70.1
PR160 PR180
PR292 PR300
PR52.1 PR80.2
UK50.2
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: Wed Jun 08 20:51:10 2016

Home
Contact Us



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