Lawson Insight Technical Documentation

                            PRPENFSRCH FILE

REFERENCED BY

AC542     PR197

UPDATED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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

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

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

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

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


                         PRPENFSRCH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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