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.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
PRA-COMPANY
Element: Company Hr | Numeric 4
Contains the company number, which
represents an established company.
|
|
PRA-REQUISITION
Element: Requisition | Numeric 9
Contains the system-assigned number
that represents the requisition.
|
|
PRA-EMP-APP
Element: 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.
0 = Internal
1 = External |
|
PRA-APPLICANT
Element: Applicant | Numeric 9
Contains the number that represents the
applicant. The number correlates all
information about the applicant.
|
|
PRA-DATE-APPLIED
Element: Date Applied | Numeric 8 (yyyymmdd)
Contains the applicant applied for the
requisition.
|
|
PRA-HIRE-SOURCE
Element: Hire 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.
|
|
PRA-APPLICANT-NAME
Element: Applicant Name | Derived
|
|
RELATION
NAME |
RELATED 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 |
|
