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    PR529     PR560     PR82.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


PNF-EMPLOYEE         Numeric 9                                   PR29.1  PR529
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.


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

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

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

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

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

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

                         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
                                                                 PR529   PR560
                                                                 PR80.1  PR80.2
                                                                 PR82.1  PR85.1
                                                                 PR89.1

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 PNF-DEPARTMENT != Spaces

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