Lawson Insight Technical Documentation

                             PRPENFSRC FILE

REFERENCED BY

AC542     BN66.1    PR140     PR160     PR180     PR189
PR195     PR197     PR229     PR80.1    PR80.2    PR85.1
PR89.1    PR04.1

UPDATED BY

PR29.1    PR300     PR529     PR560     PR82.1    UK560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PNF-COMPANY            Numeric 4                                 PR29.1  PR529
Element: Company       The company number represents an          PR560   PR82.1
                       established company and is entered on     UK560
                       all function codes.

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

PNF-PENS-SEQ-NBR       Numeric 4                                 PR29.1  PR529
Element: Pens Seq Nbr                                            PR560   PR82.1
                                                                 UK560

PNF-FUNDING-SOURCE     Alpha 6                                   PR29.1  PR529
Element: Funding Source                                          PR560   PR82.1
                                                                 UK560

PNF-FUND-AMOUNT        Signed 11.2                               PR29.1  PR529
Element: Fund Amount                                             PR560   PR82.1
                                                                 UK560

PNF-PAYMENT-DESC       Alpha 15  (Lower Case)                    PR29.1  PR529
Element: Payment Desc                                            PR560   PR82.1
                                                                 UK560

PNF-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PR29.1  PR529
Element: Date                                                    PR560   PR82.1
                                                                 UK560

PNF-END-DATE           Numeric 8  (yyyymmdd)                     PR29.1  PR529
Element: Date          The ending date in a range of dates.      PR560   PR82.1
                                                                 UK560

                         PRPENFSRC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PNFSET1   COMPANY                                                AC542   BN66.1
          EMPLOYEE                                               PR140   PR160
          PENS-SEQ-NBR                                           PR180   PR189
          FUNDING-SOURCE                                         PR195   PR197
                                                                 PR229   PR29.1
                                                                 PR300   PR529
                                                                 PR560   PR80.1
                                                                 PR80.2  PR82.1
                                                                 PR85.1  PR89.1
                                                                 UK560

PNFSET2   COMPANY                                                PR04.1
          FUNDING-SOURCE
          EMPLOYEE
          PENS-SEQ-NBR

                         PRPENFSRC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PNF-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            PNF-COMPANY           -> EMP-COMPANY
                            PNF-EMPLOYEE          -> EMP-EMPLOYEE

Pens Payment   PRPENPAY     Not Required

                            PNF-COMPANY           -> PNP-COMPANY
                            PNF-EMPLOYEE          -> PNP-EMPLOYEE
                            PNF-EFFECT-DATE       -> PNP-EFFECT-DATE
                            PNF-PENS-SEQ-NBR      -> PNP-PENS-SEQ-NBR

Prfundsrc      PRFUNDSRC    Not Required
                            Valid When EMP-DEPARTMENT != Spaces

                            PNF-COMPANY           -> PFS-COMPANY
                            EMP-PROCESS-LEVEL     -> PFS-PROCESS-LEVEL
                            EMP-DEPARTMENT        -> PFS-DEPARTMENT
                            PNF-FUNDING-SOURCE    -> PFS-FUNDING-SOURCE