|
|
PRPENPAY FILE
REFERENCED BY
PR229 BN150 PR128 PR130 PR131 PR132
PR134 PR136 PR160 PR180 PR197 PR32.2
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR45.1
PR530 PR85.1 UK102 TA147 TP135
UPDATED BY
PR29.1 PR529 PR560 PR82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNP-COMPANY Numeric 4 PR29.1 PR529
Element: Company Hr Identifies the AP company if the PR560 PR82.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PNP-EMPLOYEE Numeric 9 PR29.1 PR529
Element: Employee Contains the employee number. Each PR560 PR82.1
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) PR29.1 PR529
Element: Effective Date PR560 PR82.1
PNP-END-DATE Numeric 8 (yyyymmdd) PR29.1 PR529
Element: Ending Date The end date for this effort period. PR560 PR82.1
PNP-PENS-SEQ-NBR Numeric 4 PR29.1 PR529
Element: Pens Seq Nbr PR560 PR82.1
PNP-PENS-DIST-TYPE Numeric 2 PR29.1 PR529
Element: Pens Dist Type01 = Partial; Hardship PR560 PR82.1
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 PR29.1 PR529
Element: Pens Dist Code1 = Early distrib; No exception PR560 PR82.1
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 PR29.1 PR529
Element: Pens Dst Code2A = Qualified for 5/10yr averaging PR560 PR82.1
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 PR29.1 PR529
Element: Tax Category 00 = Regular PR560 PR82.1
70 = Periodic
71 = Non-periodic;Not elig rollover
72 = Eligible for rollover
PNP-ADDL-FED-TAX Signed 9.2 PR29.1 PR529
Element: Addl Fed Tax PR560 PR82.1
PNP-PERC-TOT-DIST Numeric 3 PR29.1 PR529
Element: Perc Tot Dist PR560 PR82.1
PNP-PAYABLE-TO Alpha 38 (Lower Case) PR29.1 PR529
Element: Payable To PR560 PR82.1
PNP-FBO-NAME Alpha 38 (Lower Case) PR29.1 PR529
Element: Fbo Name PR560 PR82.1
PNP-ADDR1 Alpha 30 (Lower Case) PR29.1 PR529
Element: Address 1 This field contains the first line of PR560 PR82.1
address information.
PNP-ADDR2 Alpha 30 (Lower Case) PR29.1 PR529
Element: Address 1 This field contains the second line of PR560 PR82.1
address information.
PNP-ADDR3 Alpha 30 (Lower Case) PR29.1 PR529
Element: Address 1 This field contains the third line of PR560 PR82.1
address information.
PNP-ADDR4 Alpha 30 (Lower Case) PR29.1 PR529
Element: Address 1 This field contains the fourth line of PR560 PR82.1
address information.
PNP-CITY Alpha 18 (Lower Case) PR29.1 PR529
Element: City This field contains the city of the PR560 PR82.1
address.
PNP-STATE Alpha 2 PR29.1 PR529
Element: State or ProviThis field contains the two-character PR560 PR82.1
state code of the address.
PNP-POSTAL-CODE Alpha 10 (Lower Case) PR29.1 PR529
Element: Postal Code This field contains the postal code. PR560 PR82.1
PNP-COUNTRY-CODE Alpha 2 PR29.1 PR529
Element: Country Code The country code. Required for VAT and PR560 PR82.1
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PNP-ROLLOVER-ACCT Alpha 17 PR29.1 PR529
Element: Rollover Acct PR560 PR82.1
PNP-MISCELLANEOUS Alpha 6 PR29.1 PR529
Element: Miscellaneous PR560 PR82.1
PNP-MISCELLANEOUS2 Alpha 6 PR29.1 PR529
Element: Miscellaneous2 PR560 PR82.1
PNP-WIRE-IND Numeric 1 PR29.1 PR529
Element: Wire Ind 1 = Foreign PR560 PR82.1
2 = Domestic
PNP-CA-EFT Alpha 1 PR29.1 PR529
Element: Ca Eft N = No PR560 PR82.1
Y = Yes
PNP-STATE-TAX-CAT Numeric 2
Element: Tax Category 00 = Regular
70 = Periodic
71 = Non-periodic;Not elig rollover
72 = Eligible for rollover
73 = Premature distribution
PRPENPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PNPSET1 COMPANY PR229 PR29.1
EMPLOYEE PR529 PR560
EFFECT-DATE PR82.1
PENS-SEQ-NBR
PNPSET2 COMPANY BN150 PR128
EMPLOYEE PR130 PR131
PENS-SEQ-NBR* PR132 PR134
PR136 PR160
PR180 PR197
PR229 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 PR85.1
...
PNPSET3 COMPANY PR29.1 PR529
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
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
|
