JOBAUTH – Employee Job Authorization

System
Personnel (PA)
Prefix
JBA
Primary key
COMPANY, EMP-APP, JOB-CODE, POSITION, EMPLOYEE
Fields
5
Updated by
10 programs
Referenced by
32 programs

JOBAUTH is the Employee Job Authorization table in Lawson Personnel (prefix JBA). It is indexed by COMPANY, EMP-APP, JOB-CODE, POSITION, EMPLOYEE (JBASET1); alternate indexes: JBASET2 and JBASET3. It is related 1:1 to APPLICANT, PRSYSTEM, EMPLOYEE, JOBCODE and PAEMPLOYEE and 1:M to PAPOSITION. It is updated by HR11.1, LT101, LT111, PA02.1, PA115, PA120, PA23.1, PA302 and 2 more and referenced by HR06.1, HR506, HS11.1, HS11.2, HS12.1, HS12.2, HS13.1, HS13.2 and 24 more. The table has 5 fields, 3 indexes and 6 documented relations.

About JOBAUTH

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.

Fields (5)

Column = COBOL field name without the JBA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
JBA-COMPANY PK
COMPANY		Numeric 4Contains the company number which represents an established company.PA23.1, PA37.1
JBA-EMP-APP PK
EMP_APP		Numeric 1Indicates 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
HS11.1, HS11.2, HS12.1, HS12.2, HS13.1, HS13.2, HS50.1, HS50.2 +24 more
JBA-JOB-CODE PK
JOB_CODE		Alpha 9This field contains the job code. It must be valid in JOBCODE.PA23.1, PA37.1
JBA-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the number of the employee or applicant.HS11.1, HS11.2, HS12.1, HS12.2, HS13.1, HS13.2, HS50.1, HS50.2 +24 more
JBA-POSITION PK
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.PA23.1, PA37.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
JBASET1COMPANY, EMP-APP, JOB-CODE, POSITION, EMPLOYEEPrimaryHR06.1, HR506, LT101, LT111, HS11.1, HS11.2, HS12.1, HS12.2 +22 more (list truncated in source)
JBASET2COMPANY, EMP-APP, EMPLOYEE, JOB-CODE, POSITIONHR11.1, PA115, PA120, PA64.1, PA64.2, PA65.1, PA65.2
JBASET3COMPANY, POSITION, EMP-APP, EMPLOYEE, JOB-CODESubsetWhere (POSITION != Spaces)LT101, LT111, PA02.1, PA302, PA502

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen JBA-EMP-APP = 1JBA-COMPANY → APL-COMPANY, JBA-EMPLOYEE → APL-APPLICANT
CompanyPRSYSTEMRequiredJBA-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen JBA-EMP-APP = ZeroesJBA-COMPANY → EMP-COMPANY, JBA-EMPLOYEE → EMP-EMPLOYEE
Job CodeJOBCODERequiredWhen (JBA-JOB-CODE != Spaces)JBA-COMPANY → JBC-COMPANY, JBA-JOB-CODE → JBC-JOB-CODE
PaemployeePAEMPLOYEERequiredWhen JBA-EMP-APP = ZeroesJBA-COMPANY → PEM-COMPANY, JBA-EMPLOYEE → PEM-EMPLOYEE

One to many (1) — child tables

RelationTableRulesConditionField map
PositionPAPOSITIONRequiredWhen (JBA-POSITION != Spaces)JBA-COMPANY → POS-COMPANY, JBA-POSITION → POS-POSITION, → POS-EFFECT-DATE

Programs

Updated by (10)

Referenced by (32)