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 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 BN66.1 BN71.1 BN72.1 BS13.1 BS14.1
BS15.1 BS32.1 HR11.1 HR11.2 HR170 HR511
HR650 HR70.1 PA02.1 PA100 PA102 PA13.1
PA13.2 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PR05.1 PR110 PR113 PR120 PR128
PR13.1 PR13.2 PR13.5 PR13.6 PR13.8 PR130
PR131 PR132 PR134 PR136 PR139 PR14.1
PR140 PR15.1 PR15.2 PR189 PR205 PR214
PR252 PR26.1 PR26.2 PR29.1 PR292 PR297
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 PR45.1 PR47.1 PR47.2 PR514 PR529
PR530 PR80.1 PR80.3 PR80.2 PR89.1 UK102
TA147 UK120 PR160 PR180 PR52.1
UPDATED BY
AC542 PR195 PR197 PR300 PR560 PR82.1
PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDH-COMPANY Numeric 4 AC542 PR195
Company The company number represents an PR197 PR560
established company and is entered on PR82.1 PR85.1
all function codes.
PDH-EMPLOYEE Numeric 9 AC542 PR195
Employee Contains the employee number. Each PR197 PR560
person employed by the company is PR82.1 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 AC542 PR195
Deduction Code Contains the deduction code. PR197 PR560
PR82.1 PR85.1
PDH-SEQ-NBR Numeric 4 AC542 PR195
Sequence Number Contains the automatically assigned PR197 PR560
sequence number for the deduction. PR82.1 PR85.1
PDH-YEAR Numeric 4 AC542 PR195
Last Closed Year Contains the fiscal year for the data PR197 PR560
stored on this record. PR82.1 PR85.1
PDH-MONTH Numeric 2 AC542 PR195
Month Contains the numeric identifier for the PR197 PR560
month. Zero identifies the amount as the PR82.1 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 AC542 PR195
Deduction Amount Contains the deduction amount. PR197 PR52.1
PR560 PR80.2
PR82.1 PR85.1
PDH-WAGE-AMOUNT Signed 13.2 AC542 PR195
Wage Amount Contains the sum of all wage amounts PR197 PR560
from the time records. PR82.1 PR85.1
PDH-UI-WORKED-12 Numeric 1 AC542 PR195
Ui Worked 12 Contains the numeric identifier for PR197 PR82.1
employees who worked the pay period that PR85.1
includes the 12th
0 = Did Not Work
1 = Did Work
PDH-REPORT-ENTITY Alpha 5 AC542 PR195
Report Entity Contains the report entity. PR197 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 AC542 PR195
Country Code The country code. Required for VAT and PR197 PR560
intrastat reporting. Must be defined in PR82.1 PR85.1
IN01.1 (Country Maintenance).
PDH-CURRENCY-CODE Alpha 5 AC542 PR195
Currency Code This field contains the company base PR197 PR560
currency code established in Company PR82.1 PR85.1
(GL10.1 ).
PDH-CURR-ND Numeric 1 AC542 PR195
Currency Number of Represents the number of decimals PR197 PR560
Decimals defined for the currency of the object. PR82.1 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
BN66.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR170
...
PDHSET2 COMPANY BN66.1 HR170
EMPLOYEE HR70.1 PR139
YEAR PR140 PR160
MONTH PR180 PR189
DED-CODE PR195 PR300
SEQ-NBR PR52.1 PR80.1
REPORT-ENTITY PR80.2 PR89.1
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
|
