Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRPENFSRCH


                            PRPENFSRCH FILE

REFERENCED BY

PR197

UPDATED BY

PR160     PR180     PR560     PR82.1    PR85.1    PR29.1
PR529

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PFH-COMPANY            Numeric 4                                 PR160   PR180
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.

PFH-EMPLOYEE           Numeric 9                                 PR160   PR180
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.

PFH-CHECK-ID           Numeric 12                                PR160   PR180
Internal Check ID      Contains the payment identification       PR560   PR82.1
Number                 number (unique payment identifier used    PR85.1
                       in tracking payment information).

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

PFH-FUNDING-SOURCE     Alpha 6                                   PR160   PR180
Element: Funding Source                                          PR560   PR82.1

PFH-FUND-AMOUNT        Signed 11.2                               PR160   PR180
Element: Fund Amount                                             PR560   PR82.1
                                                                 PR85.1

PFH-PAYROLL-YEAR       Numeric 4                                 PR160   PR180
Element: Current PayrolContains the payroll year in which the    PR560   PR82.1
                       allocation was taken.                     PR85.1

                         PRPENFSRCH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PFHSET1   COMPANY                                                PR197   PR29.1
          EMPLOYEE                                               PR529   PR560
          CHECK-ID                                               PR82.1  PR85.1
          PENS-SEQ-NBR
          FUNDING-SOURCE

PFHSET2   COMPANY                                                PR160   PR180
          EMPLOYEE
          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