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
AC541 AC542 BN10.1 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 HR511 HR650 HR70.1
PA502 PA513 PR05.1 PR128 PR13.1 PR13.2
PR13.5 PR13.6 PR13.8 PR131 PR132 PR134
PR136 PR139 PR14.1 PR15.1 PR15.2 PR205
PR214 PR26.1 PR26.2 PR292 PR32.2 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR36.1 PR39.1 PR39.2 PR47.1
PR47.2 PR514 PR530 PR89.1 UK102 UK120
PR52.1
UPDATED BY
PR195 PR197 PR300 PR560 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDH-COMPANY Numeric 4 PR195 PR197
Company The company number represents an PR560 PR82.1
established company and is entered on PR85.1
all function codes.
PDH-EMPLOYEE Numeric 9 PR195 PR197
Employee Contains the employee number. Each PR560 PR82.1
person employed by the company is PR85.1
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 PR195 PR197
Deduction Code Contains the deduction code. PR560 PR82.1
PR85.1
PDH-SEQ-NBR Numeric 4 PR195 PR197
Sequence Number Contains the automatically assigned PR560 PR82.1
sequence number for the deduction. PR85.1
PDH-YEAR Numeric 4 PR195 PR197
Last Closed Year Contains the fiscal year for the data PR560 PR82.1
stored on this record. PR85.1
PDH-MONTH Numeric 2 PR195 PR197
Month Contains the numeric identifier for the PR560 PR82.1
month. Zero identifies the amount as the PR85.1
Annual or year-to-date amount.
00 = Annual
01 = January
02 = February
03 = March
04 = April
05 = May
06 = June
07 = July
08 = August
09 = September
10 = October
11 = November
12 = December
PDH-DED-AMT Signed 13.2 PR195 PR197
Deduction Amount Contains the deduction amount. PR52.1 PR560
PR82.1 PR85.1
PDH-WAGE-AMOUNT Signed 13.2 PR195 PR197
Wage Amount Contains the sum of all wage amounts PR560 PR82.1
from the time records. PR85.1
PDH-UI-WORKED-12 Numeric 1 PR195 PR197
Ui Worked 12 Contains the numeric identifier for PR82.1 PR85.1
employees who worked the pay period that
includes the 12th
0 = Did Not Work
1 = Did Work
PDH-REPORT-ENTITY Alpha 5 PR195 PR197
Report Entity Contains the report entity. PR560 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 PR195 PR197
Country Code The country code. Required for VAT and PR560 PR82.1
intrastat reporting. Must be defined in PR85.1
IN01.1 (Country Maintenance).
PDH-CURRENCY-CODE Alpha 5 PR195 PR197
Currency Code This field contains the company base PR560 PR82.1
currency code established in Company PR85.1
(GL10.1 ).
PDH-CURR-ND Numeric 1 PR195 PR197
Currency Number of Represents the number of decimals PR560 PR82.1
Decimals defined for the currency of the object. PR85.1
PREMDEDHST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDHSET1 COMPANY AC541 AC542
EMPLOYEE BN10.1 BN100
DED-CODE BN101 BN102
SEQ-NBR BN103 BN104
YEAR BN105 BN145
MONTH BN150 BN245
REPORT-ENTITY 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 HR511
HR650 HR70.1
...
PDHSET2 COMPANY HR170 HR70.1
EMPLOYEE PR300 PR52.1
YEAR
MONTH
DED-CODE
SEQ-NBR
REPORT-ENTITY
PDHSET3 COMPANY
EMPLOYEE
REPORT-ENTITY
DED-CODE
SEQ-NBR
YEAR
MONTH
PREMDEDHST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PDH-COMPANY -> PRS-COMPANY (PRSSET1)
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
PREMDEDHST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Monthly Deds PREMDEDHST
Valid When PDH-MONTH = Zeroes
PDH-COMPANY -> PDH-COMPANY
PDH-EMPLOYEE -> PDH-EMPLOYEE
PDH-DED-CODE -> PDH-DED-CODE
PDH-SEQ-NBR -> PDH-SEQ-NBR
PDH-YEAR -> PDH-YEAR
PDH-MONTH
PDH-REPORT-ENTITY
|
