Lawson Insight Technical Documentation |
|
PRPENPAY
PRPENPAY FILE
REFERENCED BY
PR229 BN150 BN66.1 ET530 ETI2.1 LP130
PR128 PR130 PR131 PR132 PR134 PR136
PR140 PR160 PR180 PR189 PR195 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 PR80.1 PR80.2 PR85.1 PR89.1
UK102 TA147
UPDATED BY
PR29.1 PR300 PR529 PR560 PR82.1 UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNP-COMPANY Numeric 4 PR29.1 PR529
Element: Company Hr PR560 PR82.1
UK560
PNP-EMPLOYEE Numeric 9 PR29.1 PR529
Element: Employee Contains the employee number. Each PR560 PR82.1
person employed by the company is UK560
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: Effect Date PR560 PR82.1
UK560
PNP-END-DATE Numeric 8 (yyyymmdd) PR29.1 PR529
Element: End Date The end date for this effort period. PR560 PR82.1
UK560
PNP-PENS-SEQ-NBR Numeric 4 PR29.1 PR529
Element: Pens Seq Nbr PR560 PR82.1
UK560
PNP-PENS-DIST-TYPE Numeric 2 PR29.1 PR529
Element: Pens Dist Type01 = Partial; Hardship PR560 PR82.1
02 = Partial; Non-hardship UK560
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 UK560
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 UK560
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 UK560
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
UK560
PNP-PERC-TOT-DIST Numeric 3 PR29.1 PR529
Element: Perc Tot Dist PR560 PR82.1
UK560
PNP-PAYABLE-TO Alpha 38 (Lower Case) PR29.1 PR529
Element: Payable To PR560 PR82.1
UK560
PNP-FBO-NAME Alpha 38 (Lower Case) PR29.1 PR529
Element: Fbo Name PR560 PR82.1
UK560
PNP-ADDR1 Alpha 30 (Lower Case) PR29.1 PR529
Element: Addr1 This field contains the first line of PR560 PR82.1
address information. UK560
PNP-ADDR2 Alpha 30 (Lower Case) PR29.1 PR529
Element: Addr1 This field contains the first line of PR560 PR82.1
address information. UK560
PNP-ADDR3 Alpha 30 (Lower Case) PR29.1 PR529
Element: Addr1 This field contains the first line of PR560 PR82.1
address information. UK560
PNP-ADDR4 Alpha 30 (Lower Case) PR29.1 PR529
Element: Addr1 This field contains the first line of PR560 PR82.1
address information. UK560
PNP-CITY Alpha 18 (Lower Case) PR29.1 PR529
Element: City This field contains the city of the PR560 PR82.1
address. UK560
PNP-STATE Alpha 2 PR29.1 PR529
Element: State This field contains the two-character PR560 PR82.1
state code of the address. UK560
PNP-POSTAL-CODE Alpha 10 (Lower Case) PR29.1 PR529
Element: Postal Code This field contains the postal code. PR560 PR82.1
UK560
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 UK560
IN01.1 (Country Maintenance).
PNP-ROLLOVER-ACCT Alpha 17 PR29.1 PR529
Element: Rollover Acct PR560 PR82.1
UK560
PNP-MISCELLANEOUS Alpha 6 PR29.1 PR529
Element: Miscellaneous PR560 PR82.1
UK560
PNP-MISCELLANEOUS2 Alpha 6 PR29.1 PR529
Element: Miscellaneous2 PR560 PR82.1
UK560
PNP-WIRE-IND Numeric 1 PR29.1 PR529
Element: Wire Ind 1 = Foreign PR560 PR82.1
2 = Domestic UK560
PNP-CA-EFT Alpha 1 PR29.1 PR529
Element: Ca Eft N = No PR560 PR82.1
Y = Yes UK560
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 UK560
PENS-SEQ-NBR
PNPSET2 COMPANY BN150 BN66.1
EMPLOYEE ET530 ETI2.1
PENS-SEQ-NBR* LP130 PR128
PR130 PR131
PR132 PR134
PR136 PR140
PR160 PR180
PR189 PR195
PR197 PR229
PR29.1 PR300
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
...
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
|