PAREQAPP – Job Requisition Application
- System
- Personnel (PA)
- 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.
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)
Column = COBOL field name without the PRA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PRA-COMPANY PKCOMPANY | Numeric 4 | Contains the company number, which represents an established company. | PA43.1, PA43.2, PA531 |
PRA-REQUISITION PKREQUISITION | Numeric 9 | Contains the system-assigned number that represents the requisition. | PA43.1, PA43.2, PA531 |
PRA-EMP-APP PKEMP_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 PKAPPLICANT | 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PRASET1 | COMPANY, REQUISITION, EMP-APP, APPLICANT | Primary | HR170, HR70.1, LT101, LT111, PA02.1, PA102, PA243, PA41.1 +8 more | |
PRASET2 | COMPANY, EMP-APP, APPLICANT, REQUISITION | HR11.1, HR170, HR70.1, PA115, PA120, PA231, PA244, PA43.2 |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Applicant | APPLICANT | Required | When PRA-EMP-APP = 1 | PRA-COMPANY → APL-COMPANY, PRA-APPLICANT → APL-APPLICANT |
| Company | PRSYSTEM | Required | PRA-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Employee | EMPLOYEE | Required | When PRA-EMP-APP = Zeroes | PRA-COMPANY → EMP-COMPANY, PRA-APPLICANT → EMP-EMPLOYEE |
| Hire Source | PCODES | Required | When PRA-HIRE-SOURCE != Spaces | "HS" → PCO-TYPE, PRA-HIRE-SOURCE → PCO-CODE |
| Paemployee | PAEMPLOYEE | Required | When PRA-EMP-APP = Zeroes | PRA-COMPANY → PEM-COMPANY, PRA-APPLICANT → PEM-EMPLOYEE |
| Requisition | PAJOBREQ | Required | PRA-COMPANY → PJR-COMPANY, PRA-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-TYPE, Zeroes → EPC-EMP-APP, PRA-APPLICANT → EPC-EMPLOYEE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR | |
| Certificates | EMPCODES | Valid When PRA-EMP-APP = 1 | PRA-COMPANY → EPC-COMPANY, "CE" → EPC-TYPE, 1 → EPC-EMP-APP, PRA-APPLICANT → EPC-EMPLOYEE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR | |
| Competency | EMPCODES | Valid When PRA-EMP-APP = 1 | PRA-COMPANY → EPC-COMPANY, 1 → EPC-EMP-APP, PRA-APPLICANT → EPC-EMPLOYEE, EPC-TYPE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR | |
| Competency Emp | EMPCODES | Valid When PRA-EMP-APP = Zeroes | PRA-COMPANY → EPC-COMPANY, Zeroes → EPC-EMP-APP, PRA-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-TYPE, Zeroes → EPC-EMP-APP, PRA-APPLICANT → EPC-EMPLOYEE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR | |
| Education | EMPCODES | Valid When PRA-EMP-APP = 1 | PRA-COMPANY → EPC-COMPANY, "ED" → EPC-TYPE, 1 → EPC-EMP-APP, PRA-APPLICANT → EPC-EMPLOYEE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR | |
| Employers | APPJOBHIST | Valid When PRA-EMP-APP = 1 | PRA-COMPANY → AJH-COMPANY, PRA-APPLICANT → AJH-APPLICANT, AJH-EMPLOYEE, AJH-EMPLOYER-NAME, AJH-SEQ-NBR | |
| Interview | INTERVIEW | PRA-COMPANY → ITV-COMPANY, PRA-REQUISITION → ITV-REQUISITION, PRA-EMP-APP → ITV-EMP-APP, PRA-APPLICANT → ITV-APPLICANT, ITV-SEQ-NBR | ||
| References | REFERENC | Valid When PRA-EMP-APP = 1 | PRA-COMPANY → REF-COMPANY, PRA-APPLICANT → REF-APPLICANT, REF-SEQ-NBR | |
| Req Log | PAREQLOG | Delete Cascades | PRA-COMPANY → PQL-COMPANY, PRA-REQUISITION → PQL-REQUISITION, PRA-EMP-APP → PQL-EMP-APP, PRA-APPLICANT → PQL-APPLICANT, PQL-DATE, PQL-SEQ-NBR |
Programs
Updated by (14)
- HR11.1 Employee
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA02.1 Position
- PA102 Position Update
- PA115 Employee Purge
- PA120 Applicant Purge
- PA42.1 Requisition
- PA42.3 Requisition Approval Override
- PA43.1 Requisition Applicants
- PA43.2 Applicant Requisitions
- PA502 Position Conversion
- PA531 Applicant Conversion
- PA535 e-Recruiting Requisition Conversion