Employee Deduction History
This file contains employee deduction totals by month and is used in displaying year-to-date deduction amounts.
REFERENCED BY
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
PDH-COMPANY Element: Company Hr | Numeric 4 |
|
||||||||
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. |
|
||||||||
PDH-DED-CODE Element: Ded Code | Alpha 4 Contains the deduction code. |
|
||||||||
PDH-SEQ-NBR Element: Seq Nbr | Numeric 4 Contains the automatically assigned sequence number for the deduction. |
|
||||||||
PDH-YEAR Element: Year | Numeric 4 Contains the fiscal year for the data stored on this record. |
|
||||||||
PDH-DED-AMT Element: Ded Amt | Signed 13.2 Occurs 13 Times Contains the deduction amount. |
|
||||||||
PDH-WAGE-AMOUNT Element: Wage Amount | Signed 13.2 Occurs 13 Times Contains the sum of all wage amounts from the time records. |
|
||||||||
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 |
|
||||||||
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. |
|
||||||||
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). |
|
||||||||
PDH-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||
PDH-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||
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 |
|
||||||||
PDH-HM-PROC-LEVEL Element: Process Lev Hr | Alpha 5 |
|||||||||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PDHSET1 |
COMPANY EMPLOYEE DED-CODE SEQ-NBR YEAR PERIOD-NBR REPORT-ENTITY |
|
|||||||||||||||||||||||||
PDHSET2 |
COMPANY EMPLOYEE YEAR DED-CODE SEQ-NBR REPORT-ENTITY PERIOD-NBR |
|
| ||||||||||||||||||||||||
PDHSET4 |
COMPANY EMPLOYEE DED-CODE YEAR PERIOD-NBR REPORT-ENTITY SEQ-NBR* |
|
|||||||||||||||||||||||||
PDHSET5 |
COMPANY HM-PROC-LEVEL EMPLOYEE DED-CODE SEQ-NBR YEAR PERIOD-NBR REPORT-ENTITY |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| ||||||||||||
Deduction Code | DEDCODE |
Required
| ||||||||||||
Emp Deduction | EMDEDMASTR |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.