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