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
HR11.1 PA02.1 PA102 PA115 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 PA02.1 PA102
EMP-APP PA243 PA41.1
APPLICANT PA42.1 PA43.1
PA44.1 PA45.1
PA502
PRASET2 COMPANY HR11.1 HR170
EMP-APP HR70.1 PA115
APPLICANT PA120 PA231
REQUISITION PA244 PA43.2
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
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
Skill Emp EMPCODES
Valid When PRA-EMP-APP = Zeroes
PRA-COMPANY -> EPC-COMPANY
"SK" -> EPC-TYPE
Zeroes -> EPC-EMP-APP
PRA-APPLICANT -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Skills EMPCODES
Valid When PRA-EMP-APP = 1
PRA-COMPANY -> EPC-COMPANY
"SK" -> EPC-TYPE
1 -> EPC-EMP-APP
PRA-APPLICANT -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
|