PAREQLOG

Job Requisition Log

The Job Requisition Log file contains information about an applicant associated with a requisition. The Applicant Requisitions window of PA31.1 (Applicant) is the primary file that updates this file.
UPDATED BY
PA02.1 PA102 PA120 PA41.1 PA42.1 PA42.3
PA43.1 PA43.2 PA45.1 PA502 PA535 HR11.1
PA115 PA244 PA231 PA243 HR170 HR70.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PQL-COMPANY
Element: Company Hr
Numeric 4
Contains the company number, which represents an established company.
PA41.1 PA43.1
PA43.2 PA45.1
PQL-REQUISITION
Element: Requisition
Numeric 9
Contains the system-assigned number that represents the requisition.
PA41.1 PA43.1
PA43.2 PA45.1
PQL-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
PA41.1 PA43.1
PA43.2 PA45.1
PQL-APPLICANT
Element: Applicant
Numeric 9
Contains the number that represents the applicant. The number correlates all information about the applicant.
PA41.1 PA43.1
PA43.2 PA45.1
PQL-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the date the applicant status is effective.
PA243 PA41.1
PA43.1 PA43.2
PA45.1
PQL-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains the automatically assigned sequence number.
PA41.1 PA43.1
PA43.2 PA45.1
PQL-APP-STATUS
Element: App Status
Alpha 2
Contains the applicant's status.
PA243 PA41.1
PA43.1 PA43.2
PA45.1
PQL-HIRE-SOURCE
Element: Hire Source
Alpha 10
Contains the hire source that indicates where the applicant learned of the opening.
PA41.1 PA43.1
PA43.2 PA45.1
PQL-CONTACT-EMP
Element: Contact Emp
Numeric 9
Indicates the contact employee.


PAREQLOG FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PQLSET1 COMPANY
REQUISITION
EMP-APP
APPLICANT
DATE
APP-STATUS
SEQ-NBR
HR11.1 PA02.1
PA102 PA115
PA120 PA244
PA41.1 PA42.1
PA42.3 PA43.1
PA43.2 PA45.1
PA502 PA535
PQLSET2 COMPANY
REQUISITION
EMP-APP
APPLICANT
DATE*
SEQ-NBR
PA120 PA231
PA243 PA41.1
PA43.1 PA43.2
PA45.1
PQLSET3 COMPANY
EMP-APP
APPLICANT
REQUISITION
DATE
SEQ-NBR
KeyChange
HR170 HR70.1


PAREQLOG FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When PQL-EMP-APP =1
PQL-COMPANY->APL-COMPANY
PQL-APPLICANT->APL-APPLICANT
Company PRSYSTEM Required
PQL-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Emp Contact EMPLOYEE Required
When PQL-CONTACT-EMP !=Zeroes
PQL-COMPANY->EMP-COMPANY
PQL-CONTACT-EMP->EMP-EMPLOYEE
Employee EMPLOYEE Required
When PQL-EMP-APP =Zeroes
PQL-COMPANY->EMP-COMPANY
PQL-APPLICANT->EMP-EMPLOYEE
Hire Source PCODES Required
When PQL-HIRE-SOURCE !=Spaces
"HS"->PCO-TYPE
PQL-HIRE-SOURCE->PCO-CODE
Paemployee PAEMPLOYEE Required
When PQL-EMP-APP =Zeroes
PQL-COMPANY->PEM-COMPANY
PQL-APPLICANT->PEM-EMPLOYEE
Req App PAREQAPP Required
PQL-COMPANY->PRA-COMPANY
PQL-REQUISITION->PRA-REQUISITION
PQL-EMP-APP->PRA-EMP-APP
PQL-APPLICANT->PRA-APPLICANT
Requisition PAJOBREQ Required
PQL-COMPANY->PJR-COMPANY
PQL-REQUISITION->PJR-REQUISITION
Status EMSTATUS Required
PQL-COMPANY->EMS-COMPANY
PQL-APP-STATUS->EMS-EMP-STATUS


File created: Wed Jun 08 20:50:26 2016

Home
Contact Us



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