Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

JOBAUTH


                              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

HR06.1    HR506     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    TR21.1    TR22.1    TR26.1
TR500

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

JBA-EMP-APP            Numeric 1                                 HS50.1  HS50.2
Element: Type          Indicates whether the person is an        HS51.1  HS51.2
                       external or internal applicant.           HS52.1  HS52.2
                                                                 PA23.1  PA262
                       An external applicant is a person         PA263   PA37.1
                       applying from outside the company; an     PA62.1  PA63.1
                       internal applicant is an employee         PA64.1  PA64.2
                       applying from inside the company.         PA65.1  PA65.2
                       0 = Employee                              TR120   TR121
                       1 = Applicant                             TR20.1  TR20.2
                                                                 TR20.3  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

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

JBA-EMPLOYEE           Numeric 9                                 HS50.1  HS50.2
Element: Employee      Contains the number of the employee or    HS51.1  HS51.2
                       applicant.                                HS52.1  HS52.2
                                                                 PA23.1  PA262
                                                                 PA263   PA37.1
                                                                 PA62.1  PA63.1
                                                                 PA64.1  PA64.2
                                                                 PA65.1  PA65.2
                                                                 TR120   TR121
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

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

JBASET2   COMPANY                                                HR11.1  PA115
          EMP-APP                                                PA120   PA64.1
          EMPLOYEE                                               PA64.2  PA65.1
          JOB-CODE                                               PA65.2
          POSITION

JBASET3   COMPANY       Subset                                   PA02.1  PA302
          POSITION      Where (POSITION != Spaces )              PA502
          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