PRPENPAY

REFERENCED BY
BN150 BN66.1 PR521 EXI2.1 EXI4.1 LP130
LP140 PR128 PR130 PR131 PR132 PR134
PR135 PR136 PR137 PR140 PR160 PR180
PR189 PR195 PR197 PR250 PR251 PR253
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR37.1 PR45.1 PR530 PR80.1
PR80.2 PR80.4 PR85.1 PR89.1 UK102 TA147


UPDATED BY
PR29.1 PR300 PR529 PR560 PR582 PR82.1
UK560 PR229

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNP-COMPANY
Element: Company Hr		Numeric 4
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-EMPLOYEE
Element: Employee		Numeric 9
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.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
The end date for this effort period.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-PENS-SEQ-NBR
Element: Pens Seq Nbr		Numeric 4
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-PENS-DIST-TYPE
Element: Pens Dist Type		Numeric 2

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
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-PENS-DIST-CODE
Element: Pens Dist Code		Alpha 1

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
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-PENS-DST-CODE2
Element: Pens Dst Code2		Alpha 1

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
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-TAX-CATEGORY
Element: Tax Category		Numeric 2

00 = Regular
70 = Periodic
71 = Non-periodic;Not elig rollover
72 = Eligible for rollover
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-ADDL-FED-TAX
Element: Addl Fed Tax		Signed 9.2
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-PERC-TOT-DIST
Element: Perc Tot Dist		Numeric 3
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-PAYABLE-TO
Element: Payable To		Alpha 38 (Lower Case)
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-FBO-NAME
Element: Fbo Name		Alpha 38 (Lower Case)
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-CITY
Element: City		Alpha 18 (Lower Case)
This field contains the city of the address.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-STATE
Element: State		Alpha 2
This field contains the two-character state code of the address.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-POSTAL-CODE
Element: Postal Code		Alpha 10 (Lower Case)
This field contains the postal code.
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-COUNTRY-CODE
Element: Country Code		Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-ROLLOVER-ACCT
Element: Rollover Acct		Alpha 17
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-MISCELLANEOUS
Element: Miscellaneous		Alpha 6
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-MISCELLANEOUS2
Element: Miscellaneous2		Alpha 6
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-WIRE-IND
Element: Wire Ind		Numeric 1

1 = Foreign
2 = Domestic
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-CA-EFT
Element: Ca Eft		Alpha 1

N = No
Y = Yes
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PNP-STATE-TAX-CAT
Element: Tax Category		Numeric 2

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
EMPLOYEE
EFFECT-DATE
PENS-SEQ-NBR
PR229 PR29.1
PR529 PR560
PR582 PR82.1
UK560
PNPSET2 COMPANY
EMPLOYEE
PENS-SEQ-NBR*
...
BN150 BN66.1
PR521 EXI2.1
EXI4.1 LP130
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR140
PR160 PR180
PR189 PR195
PR197 PR229
PR250 PR251
PR253 PR29.1
PR300 PR32.1
PR32.2 PR33.1
PNPSET3 COMPANY
EMPLOYEE
EFFECT-DATE*
PENS-SEQ-NBR
PR29.1 PR529


PRPENPAY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:51:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.