PAREQAPP

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 LT101 LT111 PA02.1 PA102 PA115
PA120 PA42.1 PA42.3 PA43.1 PA43.2 PA502
PA531 PA535

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRA-COMPANY
Element: Company Hr		Numeric 4
Contains the company number, which represents an established company.
PA43.1 PA43.2
PA531
PRA-REQUISITION
Element: Requisition		Numeric 9
Contains the system-assigned number that represents the requisition.
PA43.1 PA43.2
PA531
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
PA43.1 PA43.2
PA531
PRA-APPLICANT
Element: 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-APPLIED
Element: Date Applied		Numeric 8 (yyyymmdd)
Contains the applicant applied for the requisition.
PA43.1 PA43.2
PA531
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.
PA43.1 PA43.2
PRA-APPLICANT-NAME
Element: Applicant Name		Derived


PAREQAPP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRASET1 COMPANY
REQUISITION
EMP-APP
APPLICANT
HR170 HR70.1
LT101 LT111
PA02.1 PA102
PA243 PA41.1
PA42.1 PA42.3
PA43.1 PA44.1
PA45.1 PA502
PA531 PA535
PRASET2 COMPANY
EMP-APP
APPLICANT
REQUISITION
HR11.1 HR170
HR70.1 PA115
PA120 PA231
PA244 PA43.2


PAREQAPP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
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


PAREQAPP FILE RELATIONS


ONE TO MANY RELATIONS

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

File created: Thu Jun 09 02:25:07 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.