PRPENPAY

REFERENCED BY
PR229 BN150 BN66.1 PR521 EXI2.1 EXI4.1
LP130 PR128 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 PR36.4 PR37.1 PR45.1 PR530 PR80.1
PR80.2 PR80.4 PR85.1 PR89.1 PRAT.1 UK102
TA147


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNP-COMPANY
Element: Company Hr
Numeric 4
PR29.1 PR529
PR560 PR582
PR82.1
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
PNP-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
PR29.1 PR529
PR560 PR582
PR82.1
PNP-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The end date for this effort period.
PR29.1 PR529
PR560 PR582
PR82.1
PNP-PENS-SEQ-NBR
Element: Pens Seq Nbr
Numeric 4
PR29.1 PR529
PR560 PR582
PR82.1
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
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
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
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
PNP-ADDL-FED-TAX
Element: Addl Fed Tax
Signed 9.2
PR29.1 PR529
PR560 PR582
PR82.1
PNP-PERC-TOT-DIST
Element: Perc Tot Dist
Numeric 3
PR29.1 PR529
PR560 PR582
PR82.1
PNP-PAYABLE-TO
Element: Payable To
Alpha 38 (Lower Case)
PR29.1 PR529
PR560 PR582
PR82.1
PNP-FBO-NAME
Element: Fbo Name
Alpha 38 (Lower Case)
PR29.1 PR529
PR560 PR582
PR82.1
PNP-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
PR29.1 PR529
PR560 PR582
PR82.1
PNP-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
PR29.1 PR529
PR560 PR582
PR82.1
PNP-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
PR29.1 PR529
PR560 PR582
PR82.1
PNP-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
PR29.1 PR529
PR560 PR582
PR82.1
PNP-CITY
Element: Hr City
Alpha 58 (Lower Case)
This field contains the city of the address.
PR29.1 PR529
PR560 PR582
PR82.1
PNP-STATE
Element: State
Alpha 2
This field contains the two-character state code of the address.
PR29.1 PR529
PR560 PR582
PR82.1
PNP-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
PR29.1 PR529
PR560 PR582
PR82.1
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
PNP-ROLLOVER-ACCT
Element: Rollover Acct
Alpha 17
PR29.1 PR529
PR560 PR582
PR82.1
PNP-MISCELLANEOUS
Element: Miscellaneous
Alpha 6
PR29.1 PR529
PR560 PR582
PR82.1
PNP-MISCELLANEOUS2
Element: Miscellaneous2
Alpha 6
PR29.1 PR529
PR560 PR582
PR82.1
PNP-WIRE-IND
Element: Wire Ind
Numeric 1

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

N = No
Y = Yes
PR29.1 PR529
PR560 PR582
PR82.1
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
PNP-IAT-ACH
Element: Flag
Alpha 1

N
Y
PR29.1 PR529
PR560 PR582
PR82.1


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
PNPSET2 COMPANY
EMPLOYEE
PENS-SEQ-NBR*
...
BN150 BN66.1
PR521 EXI2.1
EXI4.1 LP130
PR128 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
PR33.2 PR33.3
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: Thu Jun 09 02:30:40 2016

Home
Contact Us



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