Lawson Insight Technical Documentation |
|
PRPENHIST
PRPENHIST FILE
REFERENCED BY
ET530 PR197
UPDATED BY
BN66.1 PR140 PR160 PR180 PR189 PR195
PR29.1 PR300 PR529 PR560 PR80.1 PR80.2
PR82.1 PR85.1 PR89.1 UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNH-COMPANY Numeric 4 PR160 PR180
Element: Company Hr PR560 PR80.2
PR82.1 UK560
PNH-EMPLOYEE Numeric 9 PR160 PR180
Element: Employee Contains the employee number. Each PR560 PR80.2
person employed by the company is PR82.1 UK560
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PNH-CHECK-ID Numeric 12 PR160 PR180
Element: Check Id Contains the payment identification PR560 PR80.2
number (unique payment identifier used PR82.1 PR85.1
in tracking payment information). UK560
PNH-PENS-SEQ-NBR Numeric 4 PR160 PR180
Element: Pens Seq Nbr PR560 PR80.2
PR82.1 UK560
PNH-PENS-DIST-TYPE Numeric 2 PR160 PR180
Element: Pens Dist Type01 = Partial; Hardship PR560 PR80.2
02 = Partial; Non-hardship PR82.1 UK560
03 = Partial; Rollover to IRA
04 = Total; Non-rollover
05 = Total Rollover to IRA
06 = Total rollover to qual plan
07 = Periodic; > 10 years
08 = Periodic; < 10 years
09 = Periodic; < 10 years; Roll IRA
10 = Periodic; Tax not determined
11 = Periodic; W-2
12 = Lump sum payment; W-2
13 = Retro-payment
14 = Retro-payment; Rollover to IRA
15 = Loan issued
16 = Dividend
17 = Minimum distribution
18 = Excess deferrals
19 = Non-spousal death benefit
20 = Periodic non-res alien; 1042S
21 = Lump sum NRA; 1042S
22 = Periodic; 480.6
23 = Lump sum; 480.6
24 = Retro; W-2
PNH-PENS-DIST-CODE Alpha 1 PR160 PR180
Element: Pens Dist Code1 = Early distrib; No exception PR560 PR80.2
2 = Early distrib; With exception PR82.1 UK560
3 = Disability
4 = Death benefit
5 = Prohibited transaction
6 = Section 1035 exchange
7 = Normal distribution
8 = Excess contrib;Taxable curr yr
9 = PS 58 costs
A = Qualified for 5/10yr averaging
D = Exs cntrb;Txb in pri yr;Pri yr
E = Excess annual addtns; Sec 415
G = Direct rollover to IRA
H = R-over to qual plan/tax sh ann
L = Loan default
P = Excess contrib;Txbl prior year
PNH-PENS-DST-CODE2 Alpha 1 PR160 PR180
Element: Pens Dst Code2A = Qualified for 5/10yr averaging PR560 PR80.2
D = Exs cntrb;Txb in pri yr;Pri yr PR82.1 UK560
G = Direct rollover to IRA
H = R-over to qual plan/tax sh ann
P = Excess contrib;Txbl prior year
PNH-TAX-CATEGORY Numeric 2 PR160 PR180
Element: Tax Category 00 = Regular PR560 PR80.2
70 = Periodic UK560
71 = Non-periodic;Not elig rollover
72 = Eligible for rollover
PNH-ADDL-FED-TAX Signed 9.2 PR160 PR180
Element: Addl Fed Tax PR560 PR80.2
UK560
PNH-PERC-TOT-DIST Numeric 3 PR160 PR180
Element: Perc Tot Dist PR560 PR80.2
PR82.1 UK560
PNH-PAYABLE-TO Alpha 38 (Lower Case) PR160 PR180
Element: Payable To PR560 PR80.2
UK560
PNH-FBO-NAME Alpha 38 (Lower Case) PR160 PR180
Element: Fbo Name PR560 PR80.2
UK560
PNH-ADDR1 Alpha 30 (Lower Case) PR160 PR180
Element: Addr1 This field contains the first line of PR560 PR80.2
address information. UK560
PNH-ADDR2 Alpha 30 (Lower Case) PR160 PR180
Element: Addr1 This field contains the first line of PR560 PR80.2
address information. UK560
PNH-ADDR3 Alpha 30 (Lower Case) PR160 PR180
Element: Addr1 This field contains the first line of PR560 PR80.2
address information. UK560
PNH-ADDR4 Alpha 30 (Lower Case) PR160 PR180
Element: Addr1 This field contains the first line of PR560 PR80.2
address information. UK560
PNH-CITY Alpha 18 (Lower Case) PR160 PR180
Element: City This field contains the city of the PR560 PR80.2
address. UK560
PNH-STATE Alpha 2 PR160 PR180
Element: State This field contains the two-character PR560 PR80.2
state code of the address. UK560
PNH-POSTAL-CODE Alpha 10 (Lower Case) PR160 PR180
Element: Postal Code This field contains the postal code. PR560 PR80.2
UK560
PNH-COUNTRY-CODE Alpha 2 PR160 PR180
Element: Country Code The country code. Required for VAT and PR560 PR80.2
intrastat reporting. Must be defined in UK560
IN01.1 (Country Maintenance).
PNH-ROLLOVER-ACCT Alpha 17 PR160 PR180
Element: Rollover Acct PR560 PR80.2
UK560
PNH-MISCELLANEOUS Alpha 6 PR160 PR180
Element: Miscellaneous PR560 PR80.2
UK560
PNH-MISCELLANEOUS2 Alpha 6 PR160 PR180
Element: Miscellaneous2 PR560 PR80.2
UK560
PNH-WIRE-IND Numeric 1 PR160 PR180
Element: Wire Ind 1 = Foreign PR560 PR80.2
2 = Domestic UK560
PNH-CA-EFT Alpha 1 PR160 PR180
Element: Ca Eft N = No PR560 PR80.2
Y = Yes UK560
PRPENHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PNHSET1 COMPANY BN66.1 ET530
EMPLOYEE PR140 PR160
CHECK-ID PR180 PR189
PENS-SEQ-NBR PR195 PR197
PR29.1 PR300
PR529 PR560
PR80.1 PR80.2
PR82.1 PR85.1
PR89.1 UK560
PNHSET2 COMPANY PR29.1 PR529
EMPLOYEE PR560 PR82.1
PENS-SEQ-NBR* UK560
CHECK-ID
PRPENHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PNH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PNH-COMPANY -> EMP-COMPANY
PNH-EMPLOYEE -> EMP-EMPLOYEE
Paymastr PAYMASTR Not Required
PNH-COMPANY -> PYM-COMPANY
PNH-EMPLOYEE -> PYM-EMPLOYEE
PNH-CHECK-ID -> PYM-CHECK-ID
Prcheck PRCHECK Not Required
PNH-COMPANY -> PCH-COMPANY
PNH-EMPLOYEE -> PCH-EMPLOYEE
PNH-PENS-SEQ-NBR -> PCH-PENS-SEQ-NBR
PNH-CHECK-ID -> PCH-CHECK-ID
|