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
HR11.1 HR170 HR70.1 LT101 PA02.1 PA102
PA115 PA120 PA231 PA243 PA244 PA41.1
PA42.1 PA42.3 PA43.1 PA43.2 PA45.1 PA502
PA535

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 LT101
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: Thu Jun 09 11:22:22 2016

Home
Contact Us



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