Lawson Insight Technical Documentation

                             PAEMPAPP FILE

REFERENCED BY

PA533     HR15.1    HR155     HR170     HR55.2    HR650
HR70.1    PA16.1    PA272     PA502     PA513     PA53.1
PA66.3    TR22.1    TR500     PR13.1    PR13.5    PR13.6
PR13.8

UPDATED BY

HR511     HR54.1    HRS1.1    HRSC.1    PA54.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PPP-COMPANY          Numeric 4                                   HR511   HR54.1
Company              The company number represents an            HRS1.1  HRSC.1
                     established company and is entered on       PA54.1
                     all function codes.

PPP-APPLICANT        Numeric 9                                   HR511   HR54.1
Applicant                                                        HRS1.1  HRSC.1
                                                                 PA54.1

PPP-EMPLOYEE         Numeric 9                                   HR511   HR54.1
Employee             Contains the employee number. Each          HRS1.1  HRSC.1
                     person employed by the company is           PA54.1
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.

                         PAEMPAPP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PPPSET1   COMPANY                                                HR511   PA533
          APPLICANT
          EMPLOYEE

PPPSET2   COMPANY                                                HR15.1  HR155
          EMPLOYEE                                               HR170   HR511
          APPLICANT                                              HR54.1  HR55.2
                                                                 HR650   HR70.1
                                                                 HRS1.1  HRSC.1
                                                                 PA16.1  PA272
                                                                 PA502   PA513
                                                                 PA53.1  PA54.1
                                                                 PA66.3  TR22.1
                                                                 TR500   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

                         PAEMPAPP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required
                            When (PPP-EMPLOYEE != Zeroes )

                            PPP-COMPANY     -> EMP-COMPANY
                            PPP-EMPLOYEE    -> EMP-EMPLOYEE