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

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 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
PQLSET1
  1. COMPANY
  2. REQUISITION
  3. EMP-APP
  4. APPLICANT
  5. DATE
  6. APP-STATUS
  7. SEQ-NBR
PrimaryHR11.1, LT101, LT111, PA02.1, PA102, PA115, PA244, PA41.1 +7 more
PQLSET2
  1. COMPANY
  2. REQUISITION
  3. EMP-APP
  4. APPLICANT
  5. DATE ↓
  6. SEQ-NBR
PA120, PA231, PA243, PA41.1, PA43.1, PA43.2, PA45.1
PQLSET3
  1. COMPANY
  2. EMP-APP
  3. APPLICANT
  4. REQUISITION
  5. DATE
  6. SEQ-NBR
KeyChangeHR170, HR70.1, PA120

Relations

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

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen PQL-EMP-APP = 1
PQL-COMPANY→APL-COMPANY
PQL-APPLICANT→APL-APPLICANT
CompanyPRSYSTEMRequired
PQL-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Emp ContactEMPLOYEERequiredWhen PQL-CONTACT-EMP != Zeroes
PQL-COMPANY→EMP-COMPANY
PQL-CONTACT-EMP→EMP-EMPLOYEE
EmployeeEMPLOYEERequiredWhen PQL-EMP-APP = Zeroes
PQL-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 = Zeroes
PQL-COMPANY→PEM-COMPANY
PQL-APPLICANT→PEM-EMPLOYEE
Req AppPAREQAPPRequired
PQL-COMPANY→PRA-COMPANY
PQL-REQUISITION→PRA-REQUISITION
PQL-EMP-APP→PRA-EMP-APP
PQL-APPLICANT→PRA-APPLICANT
RequisitionPAJOBREQRequired
PQL-COMPANY→PJR-COMPANY
PQL-REQUISITION→PJR-REQUISITION
StatusEMSTATUSRequired
PQL-COMPANY→EMS-COMPANY
PQL-APP-STATUS→EMS-EMP-STATUS

Programs

Updated by (15)

Referenced by (5)