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 BN10.1 BN100 BN101 BN102 BN103 BN104 BN105 BN145 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 HR11.1 HR170 HR511 HR70.1 PA02.1 PA100 PA102 PA502 PA52.1 PA52.3 PA52.4 PA52.5 PR05.1 PR13.1 PR13.2 PR139 PR14.1 PR140 PR15.1 PR15.2 PR205 PR214 PR26.1 PR26.2 PR292 PR39.1 PR39.2 PR514 PR80.1 PR80.2 PR89.1 PR160 PR180 PR52.1 UPDATED BY PR150 PR195 PR199 PR300 PR560 PR82.1 PR85.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY PDH-COMPANY Numeric 4 PR150 PR195 Company The company number represents an PR199 PR560 established company and is entered on PR82.1 PR85.1 all function codes. PDH-EMPLOYEE Numeric 9 PR150 PR195 Employee Contains the employee number. Each PR199 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 PR150 PR195 Deduction Code Contains the deduction code. PR199 PR560 PR82.1 PR85.1 PDH-SEQ-NBR Numeric 4 PR150 PR195 Sequence Number Contains the automatically assigned PR199 PR82.1 sequence number for the deduction. PR85.1 PDH-YEAR Numeric 4 PR150 PR195 Last Closed Year Contains the fiscal year for the data PR199 PR560 stored on this record. PR82.1 PR85.1 PDH-MONTH Numeric 2 PR150 PR195 Month Contains the numeric identifier for the PR199 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 9.2 PR150 PR195 Deduction Amount Contains the deduction amount. PR199 PR52.1 PR560 PR80.2 PR82.1 PR85.1 PDH-WAGE-AMOUNT Signed 11.2 PR150 PR195 Wage Amount Contains the sum of all wage amounts PR199 PR560 from the time records. PR82.1 PR85.1 PDH-UI-WORKED-12 Numeric 1 PR150 PR195 Ui Worked 12 Contains the numeric identifier for PR199 PR82.1 employees who worked the pay period that PR85.1 includes the 12th 0 = Did Not Work 1 = Did Work PREMDEDHST FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN PDHSET1 COMPANY BN10.1 BN100 EMPLOYEE BN101 BN102 DED-CODE BN103 BN104 SEQ-NBR BN105 BN145 YEAR BN245 BN31.1 MONTH 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 HR11.1 HR170 HR511 HR70.1 PA02.1 PA100 PA102 ... PDHSET2 COMPANY HR170 HR70.1 EMPLOYEE PR160 PR180 YEAR PR300 PR52.1 MONTH PR80.2 DED-CODE SEQ-NBR 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 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 |