 |
Lawson Insight Technical Documentation |
|
PAREQAPP FILE
Job Requisition Application
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.
REFERENCED BY
HR170 HR70.1 PA243 PA41.1 PA44.1 PA45.1
PA231 PA244
UPDATED BY
PA120 PA42.1 PA43.1 PA43.2 PA502
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRA-COMPANY Numeric 4 PA43.1 PA43.2
Company Contains the company number, which
represents an established company.
PRA-REQUISITION Numeric 9 PA43.1 PA43.2
Requisition Contains the system-assigned number
that represents the requisition.
PRA-EMP-APP Numeric 1 PA43.1 PA43.2
Type 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.
0 = Internal
1 = External
PRA-APPLICANT Numeric 9 PA43.1 PA43.2
Applicant Contains the number that represents the
applicant. The number correlates all
information about the applicant.
PRA-DATE-APPLIED Numeric 8 (yyyymmdd) PA43.1 PA43.2
Date Applied Contains the applicant applied for the
requisition.
PRA-HIRE-SOURCE Alpha 10 PA43.1 PA43.2
Hire Source Contains the hire source that indicates
where the applicant learned of the
opening.
This must be valid in the Human
Resources Code file.
PAREQAPP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRASET1 COMPANY HR170 HR70.1
REQUISITION PA243 PA41.1
EMP-APP PA42.1 PA43.1
APPLICANT PA44.1 PA45.1
PA502
PRASET2 COMPANY HR170 HR70.1
EMP-APP PA120 PA231
APPLICANT PA244 PA43.2
REQUISITION
PAREQAPP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
Requisition PAJOBREQ Required
PRA-COMPANY -> PJR-COMPANY
PRA-REQUISITION -> PJR-REQUISITION
PAREQAPP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|