Lawson Insight Technical Documentation

                             PRPENFSRC FILE

REFERENCED BY

BN66.1    PR140     PR160     PR180     PR189     PR229
PR80.1    PR80.2    PR89.1    PR04.1

UPDATED BY

ET530     PR195     PR197     PR29.1    PR300     PR529
PR560     PR82.1    PR85.1    UK560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PNF-COMPANY            Numeric 4                                 PR29.1  PR529
Element: Company Hr                                              PR560   PR82.1
                                                                 UK560

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
                                                                 PR85.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: Effect Date                                             PR560   PR82.1
                                                                 UK560

PNF-END-DATE           Numeric 8  (yyyymmdd)                     PR29.1  PR529
Element: End Date      The end date for this effort period.      PR560   PR82.1
                                                                 UK560

PNF-RETRO-PAYMENT      Alpha 1                                   ET530   PR195
Element: Retro Payment " " = No                                  PR197   PR29.1
                       N = No                                    PR529   PR560
                       Y = Yes; open payment                     PR82.1  PR85.1
                       P = Closed; retro payment                 UK560

                         PRPENFSRC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

PNFSET2   COMPANY                                                PR04.1
          FUNDING-SOURCE
          RETRO-PAYMENT
          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