Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRPENFSRC


                             PRPENFSRC FILE

REFERENCED BY

PR160     PR180     PR229     PR04.1

UPDATED BY

PR197     PR29.1    PR529     PR560     PR82.1    PR85.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PNF-COMPANY            Numeric 4                                 PR29.1  PR529
Element: Company Hr    Identifies the AP company if the          PR560   PR82.1
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PNF-EMPLOYEE           Numeric 9                                 PR29.1  PR529
Element: 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
Element: Pens Seq Nbr                                            PR560   PR82.1

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

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

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

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

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

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

                         PRPENFSRC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PNFSET1   COMPANY                                                PR160   PR180
          EMPLOYEE                                               PR197   PR229
          PENS-SEQ-NBR                                           PR29.1  PR529
          FUNDING-SOURCE                                         PR560   PR82.1
          RETRO-PAYMENT                                          PR85.1

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