|
|
PRPENHIST FILE
REFERENCED BY
PR197
UPDATED BY
PR160 PR180 PR29.1 PR529 PR560 PR82.1
PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNH-COMPANY Numeric 4 PR160 PR180
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.
PNH-EMPLOYEE Numeric 9 PR160 PR180
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.
PNH-CHECK-ID Numeric 12 PR160 PR180
Internal Check ID Contains the payment identification PR560 PR82.1
Number number (unique payment identifier used PR85.1
in tracking payment information).
PNH-PENS-SEQ-NBR Numeric 4 PR160 PR180
Element: Pens Seq Nbr PR560 PR82.1
PNH-PENS-DIST-TYPE Numeric 2 PR160 PR180
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
PNH-PENS-DIST-CODE Alpha 1 PR160 PR180
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
PNH-PENS-DST-CODE2 Alpha 1 PR160 PR180
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
PNH-TAX-CATEGORY Numeric 2 PR160 PR180
Element: Tax Category 00 = Regular PR560
70 = Periodic
71 = Non-periodic;Not elig rollover
72 = Eligible for rollover
PNH-ADDL-FED-TAX Signed 9.2 PR160 PR180
Element: Addl Fed Tax PR560
PNH-PERC-TOT-DIST Numeric 3 PR160 PR180
Element: Perc Tot Dist PR560 PR82.1
PNH-PAYABLE-TO Alpha 38 (Lower Case) PR160 PR180
Element: Payable To PR560
PNH-FBO-NAME Alpha 38 (Lower Case) PR160 PR180
Element: Fbo Name PR560
PNH-ADDR1 Alpha 30 (Lower Case) PR160 PR180
Element: Address 1 This field contains the first line of PR560
address information.
PNH-ADDR2 Alpha 30 (Lower Case) PR160 PR180
Element: Address 1 This field contains the second line of PR560
address information.
PNH-ADDR3 Alpha 30 (Lower Case) PR160 PR180
Element: Address 1 This field contains the third line of PR560
address information.
PNH-ADDR4 Alpha 30 (Lower Case) PR160 PR180
Element: Address 1 This field contains the fourth line of PR560
address information.
PNH-CITY Alpha 18 (Lower Case) PR160 PR180
Element: City This field contains the city of the PR560
address.
PNH-STATE Alpha 2 PR160 PR180
Element: State or ProviThis field contains the two-character PR560
state code of the address.
PNH-POSTAL-CODE Alpha 10 (Lower Case) PR160 PR180
Element: Postal Code This field contains the postal code. PR560
PNH-COUNTRY-CODE Alpha 2 PR160 PR180
Element: Country Code The country code. Required for VAT and PR560
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PNH-ROLLOVER-ACCT Alpha 17 PR160 PR180
Element: Rollover Acct PR560
PNH-MISCELLANEOUS Alpha 6 PR160 PR180
Element: Miscellaneous PR560
PNH-MISCELLANEOUS2 Alpha 6 PR160 PR180
Element: Miscellaneous2 PR560
PNH-WIRE-IND Numeric 1 PR160 PR180
Element: Wire Ind 1 = Foreign PR560
2 = Domestic
PNH-CA-EFT Alpha 1 PR160 PR180
Element: Ca Eft N = No PR560
Y = Yes
PRPENHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PNHSET1 COMPANY PR197 PR29.1
EMPLOYEE PR529 PR560
CHECK-ID PR82.1 PR85.1
PENS-SEQ-NBR
PNHSET2 COMPANY PR29.1 PR529
EMPLOYEE PR560 PR82.1
PENS-SEQ-NBR*
CHECK-ID
PRPENHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
