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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
JBASET1
  1. COMPANY
  2. EMP-APP
  3. JOB-CODE
  4. POSITION
  5. EMPLOYEE
PrimaryHR06.1, HR506, LT101, LT111, HS11.1, HS11.2, HS12.1, HS12.2 +22 more (list truncated in source)
JBASET2
  1. COMPANY
  2. EMP-APP
  3. EMPLOYEE
  4. JOB-CODE
  5. POSITION
HR11.1, PA115, PA120, PA64.1, PA64.2, PA65.1, PA65.2
JBASET3
  1. COMPANY
  2. POSITION
  3. EMP-APP
  4. EMPLOYEE
  5. JOB-CODE
SubsetWhere (POSITION != Spaces)LT101, LT111, PA02.1, PA302, PA502

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APPLICANTPRSYSTEMEMPLOYEEJOBCODEPAEMPLOYEEPAPOSITIONJOBAUTH

One to one (5) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen JBA-EMP-APP = 1
JBA-COMPANY→APL-COMPANY
JBA-EMPLOYEE→APL-APPLICANT
CompanyPRSYSTEMRequired
JBA-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen JBA-EMP-APP = Zeroes
JBA-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 = Zeroes
JBA-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)