PAJOBINTRS – Employee Job Interest

System
Personnel (PA)
Prefix
PJI
Primary key
COMPANY, EMP-APP, EMPLOYEE, JOB-CODE, POSITION
Fields
8
Updated by
13 programs
Referenced by
0 programs

PAJOBINTRS is the Employee Job Interest table in Lawson Personnel (prefix PJI). It is indexed by COMPANY, EMP-APP, EMPLOYEE, JOB-CODE, POSITION (PJISET1); alternate indexes: PJISET2. It is related 1:1 to APPLICANT, EMPLOYEE, JOBCODE and PAEMPLOYEE and 1:M to PAJOBREQ and PAPOSITION. It is updated by HR00.1, HR01.1, HR06.1, HR11.1, HR506, HS50.5, LT101, LT111 and 5 more. The table has 8 fields, 2 indexes and 7 documented relations.

About PAJOBINTRS

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the PJI- 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
#PJI-COMPANY PK
COMPANY		Numeric 4—HS50.5
#PJI-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.HS50.5
#PJI-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.HS50.5
#PJI-JOB-CODE PK
JOB_CODE		Alpha 9Contains a user-defined code that represents a type of job.HS50.5
#PJI-POSITION PK
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.HS50.5
#PJI-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HS50.5
#PJI-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HS50.5
#PJI-USER-ID
USER_ID		Alpha 10 (Lower Case)—HS50.5

Indexes (2)

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
PJISET1
  1. COMPANY
  2. EMP-APP
  3. EMPLOYEE
  4. JOB-CODE
  5. POSITION
PrimaryHR00.1, HR01.1, HR11.1, HS50.5, PA115, PA120
PJISET2
  1. COMPANY
  2. JOB-CODE
  3. POSITION
  4. EMP-APP
  5. EMPLOYEE
HR06.1, HR506, 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)
APPLICANTEMPLOYEEJOBCODEPAEMPLOYEEPAJOBREQPAPOSITIONPAJOBINTRS

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen PJI-EMP-APP = 1
PJI-COMPANY→APL-COMPANY
PJI-EMPLOYEE→APL-APPLICANT
EmployeeEMPLOYEERequiredWhen PJI-EMP-APP = Zeroes
PJI-COMPANY→EMP-COMPANY
PJI-EMPLOYEE→EMP-EMPLOYEE
Job CodeJOBCODERequiredWhen PJI-JOB-CODE != Spaces
PJI-COMPANY→JBC-COMPANY
PJI-JOB-CODE→JBC-JOB-CODE
PaemployeePAEMPLOYEERequired
PJI-COMPANY→PEM-COMPANY
PJI-EMPLOYEE→PEM-EMPLOYEE

One to many (3) — child tables

RelationTableRulesConditionField map
Job RequisPAJOBREQValid When PJI-JOB-CODE != Spaces
PJI-COMPANY→PJR-COMPANY
PJI-JOB-CODE→PJR-JOB-CODE
—→PJR-REQUISITION
Pos RequisPAJOBREQValid When PJI-POSITION != Spaces
PJI-COMPANY→PJR-COMPANY
PJI-POSITION→PJR-POSITION
—→PJR-REQUISITION
PositionPAPOSITIONValid When PJI-POSITION != Spaces
PJI-COMPANY→POS-COMPANY
PJI-POSITION→POS-POSITION
—→POS-EFFECT-DATE

Programs

Updated by (13)