PRPENHIST FILE
REFERENCED BY
PR195 PR197 PR85.1
UPDATED BY
PR560 PR82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNH-COMPANY Numeric 4 PR560 PR82.1
Company The company number represents an
established company and is entered on
all function codes.
PNH-EMPLOYEE Numeric 9 PR560 PR82.1
Employee Contains the employee number. Each
person employed by the company is
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 PR560 PR82.1
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
PNH-PENS-SEQ-NBR Numeric 4 PR560 PR82.1
Pens Seq Nbr
PNH-PENS-DIST-TYPE Numeric 2 PR560 PR82.1
Pens Dist Type 01 = Partial; Hardship
02 = Partial; Non-hardship
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 PR560 PR82.1
Pens Dist Code 1 = Early distrib; No exception
2 = Early distrib; With exception
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 PR560 PR82.1
Pens Dst Code2 A = Qualified for 5/10yr averaging
D = Exs cntrb;Txb in pri yr;Pri yr
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 PR560
Tax Category 00 = Regular
70 = Periodic
71 = Non-periodic;Not elig rollover
72 = Eligible for rollover
PNH-ADDL-FED-TAX Signed 9.2 PR560
Addl Fed Tax
PNH-PERC-TOT-DIST Numeric 3 PR560 PR82.1
Perc Tot Dist
PNH-PAYABLE-TO Alpha 38 (Lower Case) PR560
Payable To
PNH-FBO-NAME Alpha 38 (Lower Case) PR560
Fbo Name
PNH-ADDR1 Alpha 30 (Lower Case) PR560
Address 1 This field contains the first line of
address information.
PNH-ADDR2 Alpha 30 (Lower Case) PR560
Address 2 This field contains the second line of
address information.
PNH-ADDR3 Alpha 30 (Lower Case) PR560
Address 3 This field contains the third line of
address information.
PNH-ADDR4 Alpha 30 (Lower Case) PR560
Address 4 This field contains the fourth line of
address information.
PNH-CITY Alpha 18 (Lower Case) PR560
City This field contains the city of the
address.
PNH-STATE Alpha 2 PR560
State or Province This field contains the two-character
state code of the address.
PNH-POSTAL-CODE Alpha 10 (Lower Case) PR560
Postal Code This field contains the postal code.
PNH-COUNTRY-CODE Alpha 2 PR560
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PNH-ROLLOVER-ACCT Alpha 17 PR560
Rollover Acct
PNH-MISCELLANEOUS Alpha 6 PR560
Miscellaneous
PNH-MISCELLANEOUS2 Alpha 6 PR560
Miscellaneous2
PNH-WIRE-IND Numeric 1 PR560
Wire Ind 1 = Foreign
2 = Domestic
PNH-CA-EFT Alpha 1 PR560
Ca Eft N = No
Y = Yes
PRPENHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PNHSET1 COMPANY PR195 PR197
EMPLOYEE PR560 PR82.1
CHECK-ID PR85.1
PENS-SEQ-NBR
PNHSET2 COMPANY PR560
EMPLOYEE
PENS-SEQ-NBR*
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
|
