PAEMPAPP FILE

REFERENCED BY

PA520     PA533     HR15.1    HR155     HR170     HR55.2
HR70.1    PA02.1    PA13.1    PA13.2    PA16.1    PA20.1
PA21.1    PA22.1    PA24.1    PA272     PA34.1    PA35.1
PA36.1    PA38.1    PA502     PA513     PA53.1    PA66.3
TR21.1    TR22.1    TR500     PR13.1

UPDATED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

                         PAEMPAPP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PPPSET1   COMPANY                                                HR511   PA520
          APPLICANT                                              PA533
          EMPLOYEE

PPPSET2   COMPANY                                                HR11.1  HR15.1
          EMPLOYEE                                               HR155   HR170
          APPLICANT                                              HR511   HR54.1
                                                                 HR55.2  HR70.1
                                                                 HR700   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA24.1  PA272
                                                                 PA34.1  PA35.1
                                                                 PA36.1  PA38.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 ...

                         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