PAREQLOG FILE
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.
REFERENCED BY
PA244 PA231 PA243 HR170 HR70.1
UPDATED BY
PA120 PA41.1 PA42.1 PA43.1 PA43.2 PA45.1
PA502
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PQL-COMPANY Numeric 4 PA41.1 PA43.1
Company Contains the company number, which PA43.2 PA45.1
represents an established company.
PQL-REQUISITION Numeric 9 PA41.1 PA43.1
Requisition Contains the system-assigned number PA43.2 PA45.1
that represents the requisition.
PQL-EMP-APP Numeric 1 PA41.1 PA43.1
Type Indicates whether the applicant is an PA43.2 PA45.1
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
PQL-APPLICANT Numeric 9 PA41.1 PA43.1
Applicant Contains the number that represents the PA43.2 PA45.1
applicant. The number correlates all
information about the applicant.
PQL-DATE Numeric 8 (yyyymmdd) PA243 PA41.1
Date Contains the date the applicant status PA43.1 PA43.2
is effective. PA45.1
PQL-SEQ-NBR Numeric 4 PA41.1 PA43.1
Sequence Number Contains the automatically assigned PA43.2 PA45.1
sequence number.
PQL-APP-STATUS Alpha 2 PA243 PA41.1
Applicant Status Contains the applicant's status. PA43.1 PA43.2
PA45.1
PQL-HIRE-SOURCE Alpha 10 PA41.1 PA43.1
Hire Source Contains the hire source that indicates PA43.2 PA45.1
where the applicant learned of the
opening.
PQL-CONTACT-EMP Numeric 9
Contact Emp Indicates the contact employee.
PAREQLOG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PQLSET1 COMPANY PA120 PA244
REQUISITION PA41.1 PA42.1
EMP-APP PA43.1 PA43.2
APPLICANT PA45.1 PA502
DATE
APP-STATUS
SEQ-NBR
PQLSET2 COMPANY PA120 PA231
REQUISITION PA243 PA41.1
EMP-APP PA43.1 PA43.2
APPLICANT PA45.1
DATE*
SEQ-NBR
PQLSET3 COMPANY KeyChange HR170 HR70.1
EMP-APP
APPLICANT
REQUISITION
DATE
SEQ-NBR
PAREQLOG FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
Employee EMPLOYEE Required
When PQL-EMP-APP = Zeroes
PQL-COMPANY -> EMP-COMPANY
PQL-APPLICANT -> EMP-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
|
