PREMDEDHST

Employee Deduction History

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

REFERENCED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN245 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN45.1 BN531 BN65.1 BN71.1
BN72.1 BS10.1 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 HR170 HR70.1 PR521 EXI2.1 EXI4.1
LP130 PR05.1 PR128 PR131 PR132 PR134
PR135 PR136 PR137 PR14.1 PR14.2 PR15.1
PR15.2 PR205 PR214 PR252 PR26.1 PR26.2
PR29.1 PR291 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
PR36.4 PR37.1 PR39.1 PR39.2 PR45.1 PR47.1
PR47.2 PR514 PR529 PR530 PR539 UK102
TA147 PR160 PR180 PR292 PR52.1 ZP557


UPDATED BY
BN305 HR11.1 HR11.2 HR11.4 HR28.1 HR511
LT101 LT111 ZH510 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
PR192 PR195 PR197 PR30.2 PR300 PR512
PR560 PR582 PR82.1 PR85.1 BN66.1 PR139
PR140 PR189 PR287 PR80.1 PR80.4 PR89.1
PRAT.1 PR11.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDH-COMPANY
Element: Company Hr
Numeric 4
PR192 PR195
PR197 PR560
PR582 PR82.1
PR85.1
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
PDH-DED-CODE
Element: Ded Code
Alpha 4
Contains the deduction code.
PR192 PR195
PR197 PR560
PR582 PR82.1
PR85.1
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
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
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
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
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 PR560
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
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
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
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
PDH-WAGE-TO-LEL
Element: Wage To Lel
Signed 7.2 Occurs 13 Times
PDH-WAGE-TO-UEL
Element: Wage To Uel
Signed 7.2 Occurs 13 Times
PDH-WAGE-TO-ET
Element: Wage To Et
Signed 7.2 Occurs 13 Times
PDH-ERNI-REBATE
Element: Erni Rebate
Signed 7.2 Occurs 13 Times
PDH-EENI-REBATE
Element: Eeni Rebate
Signed 7.2 Occurs 13 Times
PDH-P45-GROSS
Element: P45 Gross
Signed 7.2 Occurs 13 Times
PDH-P45-TAX
Element: P45 Tax
Signed 7.2 Occurs 13 Times
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).
PDH-PERIOD-NBR
Element: Period Nbr
Numeric 3
PR192 PR195
PR197 PR560
PR582 PR82.1
PR85.1
PDH-HM-PROC-LEVEL
Element: Process Lev Hr
Alpha 5
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
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
PR512 PR560
PR582 PR82.1
PR85.1 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 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
PDHSET2 COMPANY
EMPLOYEE
YEAR
DED-CODE
SEQ-NBR
REPORT-ENTITY
PERIOD-NBR
BN66.1 HR170
HR70.1 PR11.3
PR140 PR160
PR180 PR189
PR195 PR292
PR300 PR52.1
PR80.1 PR80.2
PR80.4 PR89.1
PRAT.1 ZP557
PDHSET4 COMPANY
EMPLOYEE
DED-CODE
YEAR
PERIOD-NBR
REPORT-ENTITY
SEQ-NBR*
Subset
WhereCOUNTRY-CODE ="UK"
OrCOUNTRY-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
PR89.1 PRAT.1


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 02:30:33 2016

Home
Contact Us



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