Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRPENHIST


                             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