Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRPENHIST


                             PRPENHIST FILE

REFERENCED BY

AC542     PR197

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PNH-COMPANY            Numeric 4                                 PR160   PR180
Element: Company       The company number represents an          PR560   PR80.2
                       established company and is entered on     PR82.1  UK560
                       all function codes.

PNH-EMPLOYEE           Numeric 9                                 PR160   PR180
Element: Employee      Contains the employee number. Each        PR560   PR80.2
                       person employed by the company is         PR82.1  UK560
                       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   PR80.2
Number                 number (unique payment identifier used    PR82.1  PR85.1
                       in tracking payment information).         UK560

PNH-PENS-SEQ-NBR       Numeric 4                                 PR160   PR180
Element: Pens Seq Nbr                                            PR560   PR80.2
                                                                 PR82.1  UK560

PNH-PENS-DIST-TYPE     Numeric 2                                 PR160   PR180
Element: Pens Dist Type01 = Partial; Hardship                    PR560   PR80.2
                       02 = Partial; Non-hardship                PR82.1  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

PNH-PENS-DIST-CODE     Alpha 1                                   PR160   PR180
Element: Pens Dist Code1 = Early distrib; No exception           PR560   PR80.2
                       2 = Early distrib; With exception         PR82.1  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

PNH-PENS-DST-CODE2     Alpha 1                                   PR160   PR180
Element: Pens Dst Code2A = Qualified for 5/10yr averaging        PR560   PR80.2
                       D = Exs cntrb;Txb in pri yr;Pri yr        PR82.1  UK560
                       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   PR80.2
                       70 = Periodic                             UK560
                       71 = Non-periodic;Not elig rollover
                       72 = Eligible for rollover

PNH-ADDL-FED-TAX       Signed 9.2                                PR160   PR180
Element: Addl Fed Tax                                            PR560   PR80.2
                                                                 UK560

PNH-PERC-TOT-DIST      Numeric 3                                 PR160   PR180
Element: Perc Tot Dist                                           PR560   PR80.2
                                                                 PR82.1  UK560

PNH-PAYABLE-TO         Alpha 38  (Lower Case)                    PR160   PR180
Element: Payable To                                              PR560   PR80.2
                                                                 UK560

PNH-FBO-NAME           Alpha 38  (Lower Case)                    PR160   PR180
Element: Fbo Name                                                PR560   PR80.2
                                                                 UK560

PNH-ADDR1              Alpha 30  (Lower Case)                    PR160   PR180
Element: Address 1     This field contains the first line of     PR560   PR80.2
                       address information.                      UK560

PNH-ADDR2              Alpha 30  (Lower Case)                    PR160   PR180
Element: Address 1                                               PR560   PR80.2
                                                                 UK560

PNH-ADDR3              Alpha 30  (Lower Case)                    PR160   PR180
Element: Address 1                                               PR560   PR80.2
                                                                 UK560

PNH-ADDR4              Alpha 30  (Lower Case)                    PR160   PR180
Element: Address 1                                               PR560   PR80.2
                                                                 UK560

PNH-CITY               Alpha 18  (Lower Case)                    PR160   PR180
Element: City          This field contains the city of the       PR560   PR80.2
                       address.                                  UK560

PNH-STATE              Alpha 2                                   PR160   PR180
Element: State or ProviThis field contains the two-character     PR560   PR80.2
                       state code of the address.                UK560

PNH-POSTAL-CODE        Alpha 10  (Lower Case)                    PR160   PR180
Element: Postal Code   This field contains the postal code.      PR560   PR80.2
                                                                 UK560

PNH-COUNTRY-CODE       Alpha 2                                   PR160   PR180
Element: Country Code  The country code.  Required for VAT and   PR560   PR80.2
                       intrastat reporting.  Must be defined in  UK560
                        IN01.1 (Country Maintenance).

PNH-ROLLOVER-ACCT      Alpha 17                                  PR160   PR180
Element: Rollover Acct                                           PR560   PR80.2
                                                                 UK560

PNH-MISCELLANEOUS      Alpha 6                                   PR160   PR180
Element: Miscellaneous                                           PR560   PR80.2
                                                                 UK560

PNH-MISCELLANEOUS2     Alpha 6                                   PR160   PR180
Element: Miscellaneous2                                          PR560   PR80.2
                                                                 UK560

PNH-WIRE-IND           Numeric 1                                 PR160   PR180
Element: Wire Ind      1 = Foreign                               PR560   PR80.2
                       2 = Domestic                              UK560

PNH-CA-EFT             Alpha 1                                   PR160   PR180
Element: Ca Eft        N = No                                    PR560   PR80.2
                       Y = Yes                                   UK560

                         PRPENHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PNHSET1   COMPANY                                                AC542   BN66.1
          EMPLOYEE                                               PR140   PR189
          CHECK-ID                                               PR195   PR197
          PENS-SEQ-NBR                                           PR29.1  PR300
                                                                 PR529   PR560
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1
                                                                 UK560

PNHSET2   COMPANY                                                PR29.1  PR529
          EMPLOYEE                                               PR560   PR82.1
          PENS-SEQ-NBR*                                          UK560
          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