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.

Field / column	Type	Description & values	Updated by
`PJI-COMPANY` PK COMPANY	Numeric 4	—	HS50.5
`PJI-EMP-APP` PK EMP_APP	Numeric 1	Indicates 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 9	Contains 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 9	Contains a user-defined code that represents a type of job.	HS50.5
`PJI-POSITION` PK POSITION	Alpha 12	Contains 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PJISET1`	`COMPANY`, `EMP-APP`, `EMPLOYEE`, `JOB-CODE`, `POSITION`	Primary		HR00.1, HR01.1, HR11.1, HS50.5, PA115, PA120
`PJISET2`	`COMPANY`, `JOB-CODE`, `POSITION`, `EMP-APP`, `EMPLOYEE`			HR06.1, HR506, LT101, LT111, PA02.1, PA302, PA502

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Condition	Field map
Applicant	APPLICANT	Required	When PJI-EMP-APP = 1	`PJI-COMPANY` → `APL-COMPANY`, `PJI-EMPLOYEE` → `APL-APPLICANT`
Employee	EMPLOYEE	Required	When PJI-EMP-APP = Zeroes	`PJI-COMPANY` → `EMP-COMPANY`, `PJI-EMPLOYEE` → `EMP-EMPLOYEE`
Job Code	JOBCODE	Required	When PJI-JOB-CODE != Spaces	`PJI-COMPANY` → `JBC-COMPANY`, `PJI-JOB-CODE` → `JBC-JOB-CODE`
Paemployee	PAEMPLOYEE	Required		`PJI-COMPANY` → `PEM-COMPANY`, `PJI-EMPLOYEE` → `PEM-EMPLOYEE`

One to many (3) — child tables

Relation	Table	Condition	Field map
Job Requis	PAJOBREQ	Valid When PJI-JOB-CODE != Spaces	`PJI-COMPANY` → `PJR-COMPANY`, `PJI-JOB-CODE` → `PJR-JOB-CODE`, → `PJR-REQUISITION`
Pos Requis	PAJOBREQ	Valid When PJI-POSITION != Spaces	`PJI-COMPANY` → `PJR-COMPANY`, `PJI-POSITION` → `PJR-POSITION`, → `PJR-REQUISITION`
Position	PAPOSITION	Valid When PJI-POSITION != Spaces	`PJI-COMPANY` → `POS-COMPANY`, `PJI-POSITION` → `POS-POSITION`, → `POS-EFFECT-DATE`

Programs

Updated by (13)

HR00.1 Company
HR01.1 Process Level
HR06.1 Job Code
HR11.1 Employee
HR506 Job Code Conversion
HS50.5 Employee Job Interest
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA115 Employee Purge
PA120 Applicant Purge
PA302 Position Purge
PA502 Position Conversion