Lawson Insight Technical Documentation

                            PRPENFSRCH FILE

REFERENCED BY

ET530     PR197

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PFH-COMPANY            Numeric 4                                 PR160   PR180
Element: Company Hr                                              PR560   PR80.2
                                                                 PR82.1  UK560

PFH-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.

PFH-CHECK-ID           Numeric 12                                PR160   PR180
Element: Check Id      Contains the payment identification       PR560   PR80.2
                       number (unique payment identifier used    PR82.1  PR85.1
                       in tracking payment information).         UK560

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

PFH-FUNDING-SOURCE     Alpha 6                                   PR160   PR180
Element: Funding Source                                          PR560   PR80.2
                                                                 PR82.1  UK560

PFH-FUND-AMOUNT        Signed 11.2                               PR160   PR180
Element: Fund Amount                                             PR560   PR80.2
                                                                 PR82.1  PR85.1
                                                                 UK560

PFH-PAYROLL-YEAR       Numeric 4                                 PR160   PR180
Element: Payroll Year  Contains the payroll year in which the    PR560   PR80.2
                       allocation was taken.                     PR82.1  PR85.1
                                                                 UK560

                         PRPENFSRCH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

PFHSET2   COMPANY                                                PR160   PR180
          EMPLOYEE                                               PR80.2
          PAYROLL-YEAR
          FUNDING-SOURCE
          CHECK-ID
          PENS-SEQ-NBR

                         PRPENFSRCH FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PFH-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            PFH-COMPANY         -> EMP-COMPANY
                            PFH-EMPLOYEE        -> EMP-EMPLOYEE

Pens Payment   PRPENPAY     Not Required

                            PFH-COMPANY         -> PNP-COMPANY
                            PFH-EMPLOYEE        -> PNP-EMPLOYEE
                            PFH-PENS-SEQ-NBR    -> PNP-PENS-SEQ-NBR

Prcheck        PRCHECK      Not Required

                            PFH-COMPANY         -> PCH-COMPANY
                            PFH-EMPLOYEE        -> PCH-EMPLOYEE
                            PFH-PENS-SEQ-NBR    -> PCH-PENS-SEQ-NBR
                            PFH-CHECK-ID        -> PCH-CHECK-ID