|
|
PREMDEDHST FILE
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 BS13.1 BS14.1 BS15.1 BS32.1 HR170
HR70.1 PR05.1 PR128 PR130 PR131 PR132
PR134 PR136 PR14.1 PR15.1 PR15.2 PR205
PR214 PR252 PR26.1 PR26.2 PR29.1 PR297
PR32.2 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR39.1 PR39.2 PR45.1 PR47.1 PR47.2 PR529
PR530 UK102 UK47.1 UK47.2 TA147 TP135
PR160 PR180 PR292 PR52.1 UK50.2 UK145
UK201 UK202
UPDATED BY
HR11.1 HR11.2 HR511 PA02.1 PA100 PA102
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 PR197 PR300 PR560
PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDH-COMPANY Numeric 4 PR197 PR560
Element: Company Hr Identifies the AP company if the PR82.1 PR85.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PDH-EMPLOYEE Numeric 9 PR197 PR560
Element: Employee Contains the employee number. Each PR82.1 PR85.1
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.
PDH-DED-CODE Alpha 4 PR197 PR560
Element: Deduction CodeContains the deduction code. PR82.1 PR85.1
PDH-SEQ-NBR Numeric 4 PR197 PR560
Element: Sequence NumbeContains the automatically assigned PR82.1 PR85.1
sequence number for the deduction.
PDH-YEAR Numeric 4 PR197 PR560
Element: Last Closed YeContains the fiscal year for the data PR82.1 PR85.1
stored on this record.
PDH-DED-AMT Signed 13.2 Occurs 13 Times PR197 PR52.1
Element: Deduction AmouContains the deduction amount. PR560 PR82.1
PR85.1
PDH-WAGE-AMOUNT Signed 13.2 Occurs 13 Times PR197 PR560
Element: Wage Amount Contains the sum of all wage amounts PR82.1 PR85.1
from the time records.
PDH-UI-WORKED-12 Numeric 1 Occurs 13 Times PR197 PR82.1
Element: Ui Worked 12 Contains the numeric identifier for PR85.1
employees who worked the pay period that
includes the 12th
0 = Did Not Work
1 = Did Work
PDH-REPORT-ENTITY Alpha 5 PR197 PR560
Element: Report Entity Contains the report entity. PR82.1 PR85.1
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.
PDH-COUNTRY-CODE Alpha 2 PR197 PR560
Element: Country Code The country code. Required for VAT and PR82.1 PR85.1
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PDH-CURRENCY-CODE Alpha 5 PR197 PR560
Element: Currency Code This field contains the company base PR82.1 PR85.1
currency code established in Company
(GL10.1 ).
PDH-CURR-ND Numeric 1 PR197 PR560
Account Currency Represents the number of decimals PR82.1 PR85.1
Code defined for the currency of the object.
PDH-WAGE-TO-LEL Signed 7.2 Occurs 13 Times PR197 PR82.1
Element: Wage To Lel PR85.1
PDH-WAGE-TO-UEL Signed 7.2 Occurs 13 Times PR197 PR82.1
Element: Wage To Uel PR85.1
PDH-WAGE-TO-ET Signed 7.2 Occurs 13 Times PR197 PR82.1
Element: Wage To Et PR85.1
PDH-ERNI-REBATE Signed 7.2 Occurs 13 Times PR197 PR82.1
Element: Erni Rebate PR85.1
PDH-EENI-REBATE Signed 7.2 Occurs 13 Times PR197 PR82.1
Element: Eeni Rebate PR85.1
PDH-P45-GROSS Signed 7.2 Occurs 13 Times
Element: P45 Gross
PDH-P45-TAX Signed 7.2 Occurs 13 Times
Element: P45 Tax
PDH-OT-PLAN-CODE Alpha 4 Occurs 13 Times PR197 PR82.1
Element: Ot Plan Code Identifies pay plan in effect for PR85.1
employee when PRDISTRIB record was
created from PR197 (PRPRD).
PDH-PERIOD-NBR Numeric 3 PR197 PR560
Element: Period Nbr PR82.1 PR85.1
PDH-HM-PROC-LEVEL Alpha 5 HR11.1 HR11.2
Element: Process Lev HrContains the employee's home process HR511 PA02.1
level. PA100 PA102
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 PR197
PR560 PR82.1
PR85.1
PDH-DED-AMT-DYEAR Derived
Element: Ded Amt Dyear
PDH-DED-AMT-D01 Derived
Element: Ded Amt D01
PDH-DED-AMT-D02 Derived
Element: Ded Amt D02
PDH-DED-AMT-D03 Derived
Element: Ded Amt D03
PDH-DED-AMT-D04 Derived
Element: Ded Amt D04
PDH-DED-AMT-D05 Derived
Element: Ded Amt D05
PDH-DED-AMT-D06 Derived
Element: Ded Amt D06
PDH-DED-AMT-D07 Derived
Element: Ded Amt D07
PDH-DED-AMT-D08 Derived
Element: Ded Amt D08
PDH-DED-AMT-D09 Derived
Element: Ded Amt D09
PDH-DED-AMT-D10 Derived
Element: Ded Amt D10
PDH-DED-AMT-D11 Derived
Element: Ded Amt D11
PDH-DED-AMT-D12 Derived
Element: Ded Amt D12
PDH-WAGE-AMT-DYEAR Derived
Element: Wage Amt Dyear
PDH-WAGE-AMT-D01 Derived
Element: Wage Amt D01
PDH-WAGE-AMT-D02 Derived
Element: Wage Amt D02
PDH-WAGE-AMT-D03 Derived
Element: Wage Amt D03
PDH-WAGE-AMT-D04 Derived
Element: Wage Amt D04
PDH-WAGE-AMT-D05 Derived
Element: Wage Amt D05
PDH-WAGE-AMT-D06 Derived
Element: Wage Amt D06
PDH-WAGE-AMT-D07 Derived
Element: Wage Amt D07
PDH-WAGE-AMT-D08 Derived
Element: Wage Amt D08
PDH-WAGE-AMT-D09 Derived
Element: Wage Amt D09
PDH-WAGE-AMT-D10 Derived
Element: Wage Amt D10
PDH-WAGE-AMT-D11 Derived
Element: Wage Amt D11
PDH-WAGE-AMT-D12 Derived
Element: Wage Amt D12
PREMDEDHST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDHSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
DED-CODE BN104 BN105
SEQ-NBR BN145 BN150
YEAR BN245 BN31.1
PERIOD-NBR BN31.2 BN32.1
REPORT-ENTITY BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR170
HR511 HR70.1
PA02.1 PA100
...
PDHSET2 COMPANY HR170 HR70.1
EMPLOYEE PR160 PR180
YEAR PR292 PR300
DED-CODE PR52.1 UK50.2
SEQ-NBR
REPORT-ENTITY
PERIOD-NBR
PDHSET3 COMPANY
EMPLOYEE
REPORT-ENTITY
DED-CODE
SEQ-NBR
YEAR
PERIOD-NBR
PDHSET4 COMPANY Subset PR160 PR180
EMPLOYEE Where COUNTRY-CODE = "UK" PR197 PR82.1
DED-CODE Or COUNTRY-CODE = "GB" PR85.1 UK145
YEAR UK201 UK202
PERIOD-NBR
REPORT-ENTITY
SEQ-NBR*
PDHSET5 COMPANY KeyChange PR560
HM-PROC-LEVEL
EMPLOYEE
DED-CODE
SEQ-NBR
YEAR
PERIOD-NBR
REPORT-ENTITY
PREMDEDHST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
