Lawson Insight Technical Documentation

                             PAEMPAPP FILE

REFERENCED BY

PA520     PA533     HR15.1    HR155     HR170     HR515
HR55.2    HR650     HR70.1    PA02.1    PA113     PA13.1
PA13.2    PA16.1    PA20.1    PA21.1    PA22.1    PA24.1
PA27.1    PA272     PA34.1    PA35.1    PA36.1    PA38.1
PA502     PA513     PA53.1    PA66.3    TR21.1    TR22.1
TR26.1    TR500     PR110     PR113     PR120     PR13.1
PR13.5    PR13.6    PR13.8

UPDATED BY

HR511     HR54.1    HRS1.1    HRSC.1    PA100     PA102
PA52.1    PA52.3    PA52.4    PA52.5    PA54.1    PRSC.1
HR11.1    PA115

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       PA100   PA102
                     all function codes.                         PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PRSC.1

PPP-APPLICANT        Numeric 9                                   HR511   HR54.1
Applicant                                                        HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PRSC.1

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


                         PAEMPAPP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PPPSET1   COMPANY                                                HR511   PA520
          APPLICANT                                              PA533
          EMPLOYEE

PPPSET2   COMPANY                                                HR11.1  HR11.2
          EMPLOYEE                                               HR15.1  HR155
          APPLICANT                                              HR170   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  HR650
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA115
                                                                 PA13.1  PA13.2
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA24.1  PA27.1
                                                                 PA272   PA34.1
                                                                 PA35.1  PA36.1
                                                                 ...

                         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