JOBAUTH FILE

                       Employee Job Authorization

The Employee Qualification Override file contains job and position codes
which employees are authorized to hold. This information is used by the
employee job and position qualification searchs and by reporting features of
the system.

REFERENCED BY

HR06.1    PA262     PA263     PA62.1    PA63.1    PA64.1
PA64.2    PA65.1    PA65.2

UPDATED BY

PA120     PA23.1    PA37.1    PA115     PA02.1    PA302

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

JBA-COMPANY          Numeric 4                                   PA23.1  PA37.1
Company              Contains the company number which
                     represents an established company.

JBA-EMP-APP          Numeric 1                                   PA23.1  PA37.1
Type                 Indicates whether the person is an
                     external or internal applicant.

                     An external applicant is a person
                     applying from outside the company; an
                     internal applicant is an employee
                     applying from inside the company.
                     0 = Employee
                     1 = Applicant

JBA-JOB-CODE         Alpha 9                                     PA23.1  PA37.1
Job Code             This field contains the job code.  It
                     must be valid in JOBCODE.

JBA-EMPLOYEE         Numeric 9                                   PA23.1  PA37.1
Employee             Contains the number of the employee or
                     applicant.

JBA-POSITION         Alpha 12                                    PA23.1  PA37.1
Position             Contains the user-defined code that
                     represents a position in the company.

                         JOBAUTH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

JBASET1   COMPANY                                                HR06.1  PA23.1
          EMP-APP                                                PA262   PA263
          JOB-CODE                                               PA37.1  PA62.1
          POSITION                                               PA63.1  PA64.1
          EMPLOYEE                                               PA64.2  PA65.1
                                                                 PA65.2

JBASET2   COMPANY                                                PA115   PA120
          EMP-APP
          EMPLOYEE
          JOB-CODE
          POSITION

JBASET3   COMPANY       Subset                                   PA02.1  PA302
          POSITION      Where (POSITION != Spaces )
          EMP-APP
          EMPLOYEE
          JOB-CODE

                         JOBAUTH FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required
                            When JBA-EMP-APP = 1

                            JBA-COMPANY     -> APL-COMPANY
                            JBA-EMPLOYEE    -> APL-APPLICANT

Company        PRSYSTEM     Required

                            JBA-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required
                            When JBA-EMP-APP = Zeroes

                            JBA-COMPANY     -> EMP-COMPANY
                            JBA-EMPLOYEE    -> EMP-EMPLOYEE

Job Code       JOBCODE      Required
                            When (JBA-JOB-CODE != Spaces )

                            JBA-COMPANY     -> JBC-COMPANY
                            JBA-JOB-CODE    -> JBC-JOB-CODE

                         JOBAUTH FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Position       PAPOSITION   Required
                            When (JBA-POSITION != Spaces )

                            JBA-COMPANY     -> POS-COMPANY
                            JBA-POSITION    -> POS-POSITION
                                               POS-EFFECT-DATE