PRPENPAY FILE
REFERENCED BY
PR229 AC541 AC542 BN150 PR128 PR131
PR132 PR134 PR136 PR195 PR197 PR32.2
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR36.1 PR45.1 PR530
PR560 PR82.1 PR85.1 UK102 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNP-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
PNP-EMPLOYEE Numeric 9
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.
PNP-EFFECT-DATE Numeric 8 (yyyymmdd)
Effective Date
PNP-END-DATE Numeric 8 (yyyymmdd)
Ending Date The ending date in a range of dates.
PNP-PENS-SEQ-NBR Numeric 4
Pens Seq Nbr
PNP-PENS-DIST-TYPE Numeric 2
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
PNP-PENS-DIST-CODE Alpha 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
PNP-PENS-DST-CODE2 Alpha 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
PNP-TAX-CATEGORY Numeric 2
Tax Category 00 = Regular
70 = Periodic
71 = Non-periodic;Not elig rollover
72 = Eligible for rollover
PNP-ADDL-FED-TAX Signed 9.2
Addl Fed Tax
PNP-PERC-TOT-DIST Numeric 3
Perc Tot Dist
PNP-PAYABLE-TO Alpha 38 (Lower Case)
Payable To
PNP-FBO-NAME Alpha 38 (Lower Case)
Fbo Name
PNP-ADDR1 Alpha 30 (Lower Case)
Address 1 This field contains the first line of
address information.
PNP-ADDR2 Alpha 30 (Lower Case)
Address 2 This field contains the second line of
address information.
PNP-ADDR3 Alpha 30 (Lower Case)
Address 3 This field contains the third line of
address information.
PNP-ADDR4 Alpha 30 (Lower Case)
Address 4 This field contains the fourth line of
address information.
PNP-CITY Alpha 18 (Lower Case)
City This field contains the city of the
address.
PNP-STATE Alpha 2
State or Province This field contains the two-character
state code of the address.
PNP-POSTAL-CODE Alpha 10 (Lower Case)
Postal Code This field contains the postal code.
PNP-COUNTRY-CODE Alpha 2
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PNP-ROLLOVER-ACCT Alpha 17
Rollover Acct
PNP-MISCELLANEOUS Alpha 6
Miscellaneous
PNP-MISCELLANEOUS2 Alpha 6
Miscellaneous2
PNP-WIRE-IND Numeric 1
Wire Ind 1 = Foreign
2 = Domestic
PNP-CA-EFT Alpha 1
Ca Eft N = No
Y = Yes
PRPENPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PNPSET1 COMPANY PR229
EMPLOYEE
EFFECT-DATE
PENS-SEQ-NBR
PNPSET2 COMPANY AC541 AC542
EMPLOYEE BN150 PR128
PENS-SEQ-NBR* PR131 PR132
PR134 PR136
PR195 PR197
PR229 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR530
PR560 PR82.1
PR85.1 UK102
UK120
PNPSET3 COMPANY
EMPLOYEE
EFFECT-DATE*
PENS-SEQ-NBR
PRPENPAY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PNP-COMPANY -> PRS-COMPANY (PRSSET1)
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PNP-COMPANY -> EMP-COMPANY
PNP-EMPLOYEE -> EMP-EMPLOYEE
PRPENPAY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Paymastr PAYMASTR
PNP-COMPANY -> PYM-COMPANY
PNP-EMPLOYEE -> PYM-EMPLOYEE
PNP-PENS-SEQ-NBR -> PYM-PENS-SEQ-NBR
PYM-CHECK-ID
Prcheck PRCHECK
PNP-COMPANY -> PCH-COMPANY
PNP-EMPLOYEE -> PCH-EMPLOYEE
PNP-PENS-SEQ-NBR -> PCH-PENS-SEQ-NBR
PCH-CHECK-ID
|
