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.