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
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
UK47.1 UK47.2 TA147 UK120 PR160 PR180
PR52.1 UK50.2 PR291 UK145 UK201 UK202
UPDATED BY
AC542 PR195 PR197 PR300 PR560 PR82.1
PR85.1 UK13.1 UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDH-COMPANY Numeric 4 AC542 PR195
Element: Company The company number represents an PR197 PR560
established company and is entered on PR82.1 PR85.1
all function codes. UK13.1 UK560
PDH-EMPLOYEE Numeric 9 AC542 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 AC542 PR195
Element: Deduction CodeContains the deduction code. PR197 PR560
PR82.1 PR85.1
UK13.1 UK560
PDH-SEQ-NBR Numeric 4 AC542 PR195
Element: Sequence NumbeContains the automatically assigned PR197 PR560
sequence number for the deduction. PR82.1 PR85.1
UK13.1 UK560
PDH-YEAR Numeric 4 AC542 PR195
Element: Last Closed YeContains the fiscal year for the data PR197 PR560
stored on this record. PR82.1 PR85.1
UK13.1 UK560
PDH-MONTH Numeric 2 AC542 PR195
Element: 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. UK13.1 UK560
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
Element: Deduction AmouContains the deduction amount. PR197 PR52.1
PR560 PR80.2
PR82.1 PR85.1
UK560
PDH-WAGE-AMOUNT Signed 13.2 AC542 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 AC542 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 AC542 PR195
Element: Process Level 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 AC542 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 AC542 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 AC542 PR195
Account Currency PR197 PR560
Code PR82.1 PR85.1
UK560
PDH-WAGE-TO-LEL Signed 7.2 AC542 PR195
Element: Wage To Lel PR197 PR82.1
PR85.1 UK560
PDH-WAGE-TO-UEL Signed 7.2 AC542 PR195
Element: Wage To Uel PR197 PR82.1
PR85.1 UK560
PDH-WAGE-TO-ET Signed 7.2 AC542 PR195
Element: Wage To Et PR197 PR82.1
PR85.1 UK560
PDH-ERNI-REBATE Signed 7.2 AC542 PR195
Element: Erni Rebate PR197 PR82.1
PR85.1 UK560
PDH-EENI-REBATE Signed 7.2 AC542 PR195
Element: Eeni Rebate PR197 PR82.1
PR85.1 UK560
PDH-P45-GROSS Signed 7.2 UK13.1
Element: P45 Gross
PDH-P45-TAX Signed 7.2 UK13.1
Element: P45 Tax
PDH-OT-PLAN-CODE Alpha 4 AC542 PR195
Element: Ot Plan Code PR197 PR82.1
PR85.1 UK560
PDH-PERIOD-NBR Numeric 3 AC542 PR195
Element: Period Nbr PR197 PR560
PR82.1 PR85.1
UK13.1 UK560
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
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 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
PERIOD-NBR UK50.2
PDHSET3 COMPANY PR291
EMPLOYEE
REPORT-ENTITY
DED-CODE
SEQ-NBR
YEAR
MONTH
PERIOD-NBR
PDHSET4 COMPANY Subset AC542 BN66.1
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
MONTH UK145 UK201
UK202 UK560
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
PDH-PERIOD-NBR
PDH-REPORT-ENTITY
|