Lawson Insight Technical Documentation |
|
PREMDEDHST
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 BN66.1
BN71.1 BN72.1 BS13.1 BS14.1 BS15.1 BS32.1
ETI1.1 ETI2.1 HR170 HR70.1 LP130 PR05.1
PR128 PR130 PR131 PR132 PR134 PR136
PR139 PR14.1 PR14.2 PR140 PR15.1 PR15.2
PR189 PR205 PR214 PR252 PR26.1 PR26.2
PR287 PR29.1 PR291 PR297 PR299 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 PR514 PR529
PR530 PR539 PR80.1 PR80.3 PR80.2 PR89.1
UK102 UK47.1 UK47.2 TA147 PR160 PR180
PR292 PR52.1 UK50.2 UK145 UK201 UK202
UPDATED BY
BN305 ET530 HR11.1 HR11.2 HR511 PA02.1
PA100 PA102 PA115 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
PR195 PR197 PR300 PR560 PR82.1 PR85.1
UK13.1 UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDH-COMPANY Numeric 4 ET530 PR195
Element: Company Hr PR197 PR560
PR82.1 PR85.1
UK13.1 UK560
PDH-EMPLOYEE Numeric 9 ET530 PR195
Element: Employee Contains the employee number. Each PR197 PR560
person employed by the company is PR82.1 PR85.1
assigned a unique number. The system UK13.1 UK560
uses the employee number to correlate
all of the information related to that
person.
PDH-DED-CODE Alpha 4 ET530 PR195
Element: Ded Code Contains the deduction code. PR197 PR560
PR82.1 PR85.1
UK13.1 UK560
PDH-SEQ-NBR Numeric 4 ET530 PR195
Element: Seq Nbr Contains the automatically assigned PR197 PR560
sequence number for the deduction. PR82.1 PR85.1
UK13.1 UK560
PDH-YEAR Numeric 4 ET530 PR195
Element: Year Contains the fiscal year for the data PR197 PR560
stored on this record. PR82.1 PR85.1
UK13.1 UK560
PDH-DED-AMT Signed 13.2 Occurs 13 Times ET530 PR195
Element: Ded Amt Contains the deduction amount. PR197 PR52.1
PR560 PR80.2
PR82.1 PR85.1
UK560
PDH-WAGE-AMOUNT Signed 13.2 Occurs 13 Times ET530 PR195
Element: Wage Amount Contains the sum of all wage amounts PR197 PR560
from the time records. PR82.1 PR85.1
UK560
PDH-UI-WORKED-12 Numeric 1 Occurs 13 Times ET530 PR195
Element: 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 ET530 PR195
Element: Report Entity Contains the report entity. PR197 PR560
PR82.1 PR85.1
Report Entity is the Process Level or UK13.1 UK560
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 ET530 PR195
Element: 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). UK13.1 UK560
PDH-CURRENCY-CODE Alpha 5 ET530 PR195
Element: Currency Code This field contains the company base PR197 PR560
currency code established in Company PR82.1 PR85.1
(GL10.1 ). UK560
PDH-CURR-ND Numeric 1 ET530 PR195
Element: Acct Nd The number of decimals assigned to a PR197 PR560
particular account as determined by the PR82.1 PR85.1
account currency. UK560
PDH-WAGE-TO-LEL Signed 7.2 Occurs 13 Times ET530 PR195
Element: Wage To Lel PR197 PR82.1
PR85.1 UK560
PDH-WAGE-TO-UEL Signed 7.2 Occurs 13 Times ET530 PR195
Element: Wage To Uel PR197 PR82.1
PR85.1 UK560
PDH-WAGE-TO-ET Signed 7.2 Occurs 13 Times ET530 PR195
Element: Wage To Et PR197 PR82.1
PR85.1 UK560
PDH-ERNI-REBATE Signed 7.2 Occurs 13 Times ET530 PR195
Element: Erni Rebate PR197 PR82.1
PR85.1 UK560
PDH-EENI-REBATE Signed 7.2 Occurs 13 Times ET530 PR195
Element: Eeni Rebate PR197 PR82.1
PR85.1 UK560
PDH-P45-GROSS Signed 7.2 Occurs 13 Times UK13.1
Element: P45 Gross
PDH-P45-TAX Signed 7.2 Occurs 13 Times UK13.1
Element: P45 Tax
PDH-OT-PLAN-CODE Alpha 4 Occurs 13 Times ET530 PR195
Element: Ot Plan Code Identifies pay plan in effect for PR197 PR82.1
employee when PRDISTRIB record was PR85.1 UK560
created from PR197 (PRPRD).
PDH-PERIOD-NBR Numeric 3 ET530 PR195
Element: Period Nbr PR197 PR560
PR82.1 PR85.1
UK13.1 UK560
PDH-HM-PROC-LEVEL Alpha 5 BN305 ET530
Element: Process Lev Hr HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 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
PR195 PR197
PR560 PR82.1
PR85.1 UK560
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 BN305
PERIOD-NBR BN31.1 BN31.2
REPORT-ENTITY 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 ET530
ETI1.1 ETI2.1
HR11.1 HR11.2
...
PDHSET2 COMPANY HR170 HR70.1
EMPLOYEE PR160 PR180
YEAR PR292 PR300
DED-CODE PR52.1 PR80.2
SEQ-NBR UK50.2
REPORT-ENTITY
PERIOD-NBR
PDHSET4 COMPANY Subset BN66.1 ET530
EMPLOYEE Where COUNTRY-CODE = "UK" PR139 PR140
DED-CODE Or COUNTRY-CODE = "GB" PR160 PR180
YEAR PR189 PR195
PERIOD-NBR PR197 PR80.1
REPORT-ENTITY PR80.2 PR82.1
SEQ-NBR* PR85.1 PR89.1
UK145 UK201
UK202 UK560
PDHSET5 COMPANY KeyChange BN66.1 PR139
HM-PROC-LEVEL PR140 PR189
EMPLOYEE PR195 PR560
DED-CODE PR80.1 PR89.1
SEQ-NBR UK560
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
|