PAREQLOG – Job Requisition Log

System
Personnel (PA)
Prefix
PQL
Primary key
COMPANY, REQUISITION, EMP-APP, APPLICANT, DATE, APP-STATUS, SEQ-NBR
Fields
9
Updated by
15 programs
Referenced by
5 programs

PAREQLOG is the Job Requisition Log table in Lawson Personnel (prefix PQL). It is indexed by COMPANY, REQUISITION, EMP-APP, APPLICANT, DATE, APP-STATUS, SEQ-NBR (PQLSET1); alternate indexes: PQLSET2 and PQLSET3. It is related 1:1 to APPLICANT, PRSYSTEM, EMPLOYEE, PCODES, PAEMPLOYEE, PAREQAPP, PAJOBREQ and EMSTATUS. It is updated by HR11.1, LT101, LT111, PA02.1, PA102, PA115, PA120, PA41.1 and 7 more and referenced by HR170, HR70.1, PA231, PA243 and PA244. The table has 9 fields, 3 indexes and 9 documented relations.

About PAREQLOG

The Job Requisition Log file contains information about an applicant associated with a requisition. The Applicant Requisitions window of PA31.1 (Applicant) is the primary file that updates this file.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
PQL-COMPANY PK
COMPANY		Numeric 4Contains the company number, which represents an established company.PA41.1, PA43.1, PA43.2, PA45.1
PQL-REQUISITION PK
REQUISITION		Numeric 9Contains the system-assigned number that represents the requisition.PA41.1, PA43.1, PA43.2, PA45.1
PQL-EMP-APP PK
EMP_APP		Numeric 1Indicates whether the applicant is an internal or external applicant. An external applicant is a person applying from outside the company; an internal applicant is an employee applying from inside the company.
  • 0 Internal
  • 1 External
PA41.1, PA43.1, PA43.2, PA45.1
PQL-APPLICANT PK
APPLICANT		Numeric 9Contains the number that represents the applicant. The number correlates all information about the applicant.PA41.1, PA43.1, PA43.2, PA45.1
PQL-DATE PK
DATE		Numeric 8 (yyyymmdd)Contains the date the applicant status is effective.PA243, PA41.1, PA43.1, PA43.2, PA45.1
PQL-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the automatically assigned sequence number.PA41.1, PA43.1, PA43.2, PA45.1
PQL-APP-STATUS PK
APP_STATUS		Alpha 2Contains the applicant's status.PA243, PA41.1, PA43.1, PA43.2, PA45.1
PQL-HIRE-SOURCE
HIRE_SOURCE		Alpha 10Contains the hire source that indicates where the applicant learned of the opening.PA41.1, PA43.1, PA43.2, PA45.1
PQL-CONTACT-EMP
CONTACT_EMP		Numeric 9Indicates the contact employee.—

Indexes (3)

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

IndexKeysFlagsConditionUsed in
PQLSET1COMPANY, REQUISITION, EMP-APP, APPLICANT, DATE, APP-STATUS, SEQ-NBRPrimaryHR11.1, LT101, LT111, PA02.1, PA102, PA115, PA244, PA41.1 +7 more
PQLSET2COMPANY, REQUISITION, EMP-APP, APPLICANT, DATE*, SEQ-NBRPA120, PA231, PA243, PA41.1, PA43.1, PA43.2, PA45.1
PQLSET3COMPANY, EMP-APP, APPLICANT, REQUISITION, DATE, SEQ-NBRKeyChangeHR170, HR70.1, PA120

Relations

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen PQL-EMP-APP = 1PQL-COMPANY → APL-COMPANY, PQL-APPLICANT → APL-APPLICANT
CompanyPRSYSTEMRequiredPQL-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Emp ContactEMPLOYEERequiredWhen PQL-CONTACT-EMP != ZeroesPQL-COMPANY → EMP-COMPANY, PQL-CONTACT-EMP → EMP-EMPLOYEE
EmployeeEMPLOYEERequiredWhen PQL-EMP-APP = ZeroesPQL-COMPANY → EMP-COMPANY, PQL-APPLICANT → EMP-EMPLOYEE
Hire SourcePCODESRequiredWhen PQL-HIRE-SOURCE != Spaces"HS" → PCO-TYPE, PQL-HIRE-SOURCE → PCO-CODE
PaemployeePAEMPLOYEERequiredWhen PQL-EMP-APP = ZeroesPQL-COMPANY → PEM-COMPANY, PQL-APPLICANT → PEM-EMPLOYEE
Req AppPAREQAPPRequiredPQL-COMPANY → PRA-COMPANY, PQL-REQUISITION → PRA-REQUISITION, PQL-EMP-APP → PRA-EMP-APP, PQL-APPLICANT → PRA-APPLICANT
RequisitionPAJOBREQRequiredPQL-COMPANY → PJR-COMPANY, PQL-REQUISITION → PJR-REQUISITION
StatusEMSTATUSRequiredPQL-COMPANY → EMS-COMPANY, PQL-APP-STATUS → EMS-EMP-STATUS

Programs

Updated by (15)

Referenced by (5)