Lawson Docs › 10 MSP6 › Personnel › PAREQAPP PAREQAPP – Job Requisition Application
Prefix PRA
Primary key COMPANY, REQUISITION, EMP-APP, APPLICANT
Fields 7
Updated by 14 programs
Referenced by 8 programs
PAREQAPP is the Job Requisition Application table in Lawson Personnel (prefix PRA). It is indexed by COMPANY, REQUISITION, EMP-APP, APPLICANT (PRASET1); alternate indexes: PRASET2. It is related 1:1 to APPLICANT , PRSYSTEM , EMPLOYEE , PCODES , PAEMPLOYEE and PAJOBREQ and 1:M to EMPCODES , APPJOBHIST , INTERVIEW , REFERENC and PAREQLOG . It is updated by HR11.1 , LT101 , LT111 , PA02.1 , PA102 , PA115 , PA120 , PA42.1 and 6 more and referenced by HR170 , HR70.1 , PA231 , PA243 , PA244 , PA41.1 , PA44.1 and PA45.1 . The table has 7 fields, 2 indexes and 16 documented relations.
Jump to About Fields (7) Indexes (2) 1:1 relations (6) 1:M relations (10) Updated by (14) Referenced by (8) About PAREQAPP The Job Requisition Application file contains information about the internal and external applicants associated with a requisition. PA43.1 (Requisition Applicants) and the Applicant Requisitions window of PA31.1 (Applicant) are the primary programs that update this file.
Fields (7) Copy as SQL
Column = COBOL field name without the PRA- 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 / column Type Description & values Updated by
# PRA-COMPANY PK COMPANY Numeric 4 Contains the company number, which represents an established company. PA43.1, PA43.2, PA531 # PRA-REQUISITION PK REQUISITION Numeric 9 Contains the system-assigned number that represents the requisition. PA43.1, PA43.2, PA531 # PRA-EMP-APP PK EMP_APP Numeric 1 Indicates 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. PA43.1, PA43.2, PA531 # PRA-APPLICANT PK APPLICANT Numeric 9 Contains the number that represents the applicant. The number correlates all information about the applicant. PA43.1, PA43.2, PA531 # PRA-DATE-APPLIEDDATE_APPLIED Numeric 8 (yyyymmdd) Contains the applicant applied for the requisition. PA43.1, PA43.2, PA531 # PRA-HIRE-SOURCEHIRE_SOURCE Alpha 10 Contains the hire source that indicates where the applicant learned of the opening. This must be valid in the Human Resources Code file. PA43.1, PA43.2 # PRA-APPLICANT-NAMEAPPLICANT_NAME Derived — —
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.
Index Keys Flags Condition Used in PRASET1COMPANYREQUISITIONEMP-APPAPPLICANTPrimary HR170, HR70.1, LT101, LT111, PA02.1, PA102, PA243, PA41.1 +8 more PRASET2COMPANYEMP-APPAPPLICANTREQUISITIONHR11.1, HR170, HR70.1, PA115, PA120, PA231, PA244, PA43.2
Relations Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each) APPLICANT PRSYSTEM EMPLOYEE PCODES PAEMPLOYEE PAJOBREQ EMPCODES APPJOBHIST INTERVIEW REFERENC PAREQLOG PAREQAPP One to one (6) — lookups and parents
Relation Table Rules Condition Field map Applicant APPLICANT Required When PRA-EMP-APP = 1 PRA-COMPANY→ APL-COMPANYPRA-APPLICANT→ APL-APPLICANT
Company PRSYSTEM Required PRA-COMPANY→ PRS-COMPANYSpaces→ PRS-PROCESS-LEVEL
Employee EMPLOYEE Required When PRA-EMP-APP = Zeroes PRA-COMPANY→ EMP-COMPANYPRA-APPLICANT→ EMP-EMPLOYEE
Hire Source PCODES Required When PRA-HIRE-SOURCE != Spaces "HS"→ PCO-TYPEPRA-HIRE-SOURCE→ PCO-CODE
Paemployee PAEMPLOYEE Required When PRA-EMP-APP = Zeroes PRA-COMPANY→ PEM-COMPANYPRA-APPLICANT→ PEM-EMPLOYEE
Requisition PAJOBREQ Required PRA-COMPANY→ PJR-COMPANYPRA-REQUISITION→ PJR-REQUISITION
One to many (10) — child tables
Relation Table Rules Condition Field map Cert Emp EMPCODES Valid When PRA-EMP-APP = Zeroes PRA-COMPANY→ EPC-COMPANY"CE"→ EPC-TYPEZeroes→ EPC-EMP-APPPRA-APPLICANT→ EPC-EMPLOYEE— → EPC-CODE— → EPC-SUBJECT— → EPC-SEQ-NBR
Certificates EMPCODES Valid When PRA-EMP-APP = 1 PRA-COMPANY→ EPC-COMPANY"CE"→ EPC-TYPE1→ EPC-EMP-APPPRA-APPLICANT→ EPC-EMPLOYEE— → EPC-CODE— → EPC-SUBJECT— → EPC-SEQ-NBR
Competency EMPCODES Valid When PRA-EMP-APP = 1 PRA-COMPANY→ EPC-COMPANY1→ EPC-EMP-APPPRA-APPLICANT→ EPC-EMPLOYEE— → EPC-TYPE— → EPC-CODE— → EPC-SUBJECT— → EPC-SEQ-NBR
Competency Emp EMPCODES Valid When PRA-EMP-APP = Zeroes PRA-COMPANY→ EPC-COMPANYZeroes→ EPC-EMP-APPPRA-APPLICANT→ EPC-EMPLOYEE— → EPC-TYPE— → EPC-CODE— → EPC-SUBJECT— → EPC-SEQ-NBR
Educ Emp EMPCODES Valid When PRA-EMP-APP = Zeroes PRA-COMPANY→ EPC-COMPANY"ED"→ EPC-TYPEZeroes→ EPC-EMP-APPPRA-APPLICANT→ EPC-EMPLOYEE— → EPC-CODE— → EPC-SUBJECT— → EPC-SEQ-NBR
Education EMPCODES Valid When PRA-EMP-APP = 1 PRA-COMPANY→ EPC-COMPANY"ED"→ EPC-TYPE1→ EPC-EMP-APPPRA-APPLICANT→ EPC-EMPLOYEE— → EPC-CODE— → EPC-SUBJECT— → EPC-SEQ-NBR
Employers APPJOBHIST Valid When PRA-EMP-APP = 1 PRA-COMPANY→ AJH-COMPANYPRA-APPLICANT→ AJH-APPLICANT— → AJH-EMPLOYEE— → AJH-EMPLOYER-NAME— → AJH-SEQ-NBR
Interview INTERVIEW PRA-COMPANY→ ITV-COMPANYPRA-REQUISITION→ ITV-REQUISITIONPRA-EMP-APP→ ITV-EMP-APPPRA-APPLICANT→ ITV-APPLICANT— → ITV-SEQ-NBR
References REFERENC Valid When PRA-EMP-APP = 1 PRA-COMPANY→ REF-COMPANYPRA-APPLICANT→ REF-APPLICANT— → REF-SEQ-NBR
Req Log PAREQLOG Delete Cascades PRA-COMPANY→ PQL-COMPANYPRA-REQUISITION→ PQL-REQUISITIONPRA-EMP-APP→ PQL-EMP-APPPRA-APPLICANT→ PQL-APPLICANT— → PQL-DATE— → PQL-SEQ-NBR
Programs Updated by (14) Referenced by (8)
