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 |
LT101 | LT111 | PA02.1 | PA102 | PA120 | PA41.1 |
PA42.1 | PA42.3 | PA43.1 | PA43.2 | PA45.1 | PA502 |
PA535 | HR11.1 | PA115 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||
---|---|---|---|---|---|---|---|---|
PQL-COMPANY Element: Company Hr | Numeric 4 Contains the company number, which represents an established company. |
|
||||||
PQL-REQUISITION Element: Requisition | Numeric 9 Contains the system-assigned number that represents the requisition. |
|
||||||
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 |
|
||||||
PQL-APPLICANT Element: Applicant | Numeric 9 Contains the number that represents the applicant. The number correlates all information about the applicant. |
|
||||||
PQL-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the date the applicant status is effective. |
|
||||||
PQL-SEQ-NBR Element: Seq Nbr | Numeric 4 Contains the automatically assigned sequence number. |
|
||||||
PQL-APP-STATUS Element: App Status | Alpha 2 Contains the applicant's status. |
|
||||||
PQL-HIRE-SOURCE Element: Hire Source | Alpha 10 Contains the hire source that indicates where the applicant learned of the opening. |
|
||||||
PQL-CONTACT-EMP Element: Contact Emp | Numeric 9 Indicates the contact employee. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PQLSET1 |
COMPANY REQUISITION EMP-APP APPLICANT DATE APP-STATUS SEQ-NBR |
|
| ||||||||||||||||||||||
PQLSET2 |
COMPANY REQUISITION EMP-APP APPLICANT DATE* SEQ-NBR |
|
| ||||||||||||||||||||||
PQLSET3 |
COMPANY EMP-APP APPLICANT REQUISITION DATE SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Applicant | APPLICANT |
Required
| ||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||
Emp Contact | EMPLOYEE |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Hire Source | PCODES |
Required
| ||||||||||||
Paemployee | PAEMPLOYEE |
Required
| ||||||||||||
Req App | PAREQAPP |
Required
| ||||||||||||
Requisition | PAJOBREQ |
Required
| ||||||||||||
Status | EMSTATUS |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.