Lawson Insight Technical Documentation

                              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 searches and by reporting features of
the system.

REFERENCED BY

HS50.1    HS50.2    HS51.1    HS51.2    HS52.1    HS52.2
PA262     PA263     PA62.1    PA63.1    PA64.1    PA64.2
PA65.1    PA65.2    TR120     TR121     TR20.1    TR20.2
TR20.3    TR22.1    TR500

UPDATED BY

PA120     PA23.1    PA37.1    PA302     PA502

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                                   HS50.1  HS50.2
Type                 Indicates whether the person is an          HS51.1  HS51.2
                     external or internal applicant.             HS52.1  HS52.2
                                                                 PA23.1  PA37.1
                     An external applicant is a person           TR120   TR121
                     applying from outside the company; an       TR20.1  TR20.2
                     internal applicant is an employee           TR20.3  TR22.1
                     applying from inside the company.           TR500
                     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                                   HS50.1  HS50.2
Employee             Contains the number of the employee or      HS51.1  HS51.2
                     applicant.                                  HS52.1  HS52.2
                                                                 PA23.1  PA37.1
                                                                 TR120   TR121
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR22.1
                                                                 TR500

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                                                HS50.1  HS50.2
          EMP-APP                                                HS51.1  HS51.2
          JOB-CODE                                               HS52.1  HS52.2
          POSITION                                               PA23.1  PA262
          EMPLOYEE                                               PA263   PA37.1
                                                                 PA62.1  PA63.1
                                                                 PA64.1  PA64.2
                                                                 PA65.1  PA65.2
                                                                 TR120   TR121
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR22.1
                                                                 TR500

JBASET2   COMPANY                                                PA120
          EMP-APP
          EMPLOYEE
          JOB-CODE
          POSITION

JBASET3   COMPANY       Subset                                   PA302   PA502
          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