PRPENHIST

REFERENCED BY
PR197


UPDATED BY
BN66.1 PR140 PR160 PR180 PR189 PR195
PR29.1 PR300 PR529 PR560 PR582 PR80.1
PR80.2 PR80.4 PR82.1 PR85.1 PR89.1 UK560

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNH-COMPANY
Element: Company Hr
Numeric 4
PR160 PR180
PR560 PR582
PR80.2 PR82.1
UK560
PNH-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.
PR160 PR180
PR560 PR582
PR80.2 PR82.1
UK560
PNH-CHECK-ID
Element: Check Id
Numeric 12
Contains the payment identification number (unique payment identifier used in tracking payment information).
PR160 PR180
PR560 PR582
PR80.2 PR82.1
PR85.1 UK560
PNH-PENS-SEQ-NBR
Element: Pens Seq Nbr
Numeric 4
PR160 PR180
PR560 PR582
PR80.2 PR82.1
UK560
PNH-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
PR160 PR180
PR560 PR582
PR80.2 PR82.1
UK560
PNH-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
PR160 PR180
PR560 PR582
PR80.2 PR82.1
UK560
PNH-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
PR160 PR180
PR560 PR582
PR80.2 PR82.1
UK560
PNH-TAX-CATEGORY
Element: Tax Category
Numeric 2

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

1 = Foreign
2 = Domestic
PR160 PR180
PR560 PR80.2
UK560
PNH-CA-EFT
Element: Ca Eft
Alpha 1

N = No
Y = Yes
PR160 PR180
PR560 PR80.2
UK560


PRPENHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PNHSET1 COMPANY
EMPLOYEE
CHECK-ID
PENS-SEQ-NBR
BN66.1 PR140
PR160 PR180
PR189 PR195
PR197 PR29.1
PR300 PR529
PR560 PR582
PR80.1 PR80.2
PR80.4 PR82.1
PR85.1 PR89.1
UK560
PNHSET2 COMPANY
EMPLOYEE
PENS-SEQ-NBR*
CHECK-ID
PR29.1 PR529
PR560 PR582
PR82.1 UK560


PRPENHIST FILE RELATIONS


ONE TO ONE RELATIONS

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


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

Home
Contact Us



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