Lawson Insight Technical Documentation |
|
PAREQAPP
PAREQAPP FILE
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 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 Numeric 4 PA43.1 PA43.2
Element: Company Hr Contains the company number, which PA531
represents an established company.
PRA-REQUISITION Numeric 9 PA43.1 PA43.2
Element: Requisition Contains the system-assigned number PA531
that represents the requisition.
PRA-EMP-APP Numeric 1 PA43.1 PA43.2
Element: Emp App Indicates whether the applicant is an PA531
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
PRA-APPLICANT Numeric 9 PA43.1 PA43.2
Element: Applicant Contains the number that represents the PA531
applicant. The number correlates all
information about the applicant.
PRA-DATE-APPLIED Numeric 8 (yyyymmdd) PA43.1 PA43.2
Element: Date Applied Contains the applicant applied for the PA531
requisition.
PRA-HIRE-SOURCE Alpha 10 PA43.1 PA43.2
Element: Hire Source Contains the hire source that indicates
where the applicant learned of the
opening.
This must be valid in the Human
Resources Code file.
PRA-APPLICANT-NAME Derived
Element: Applicant Name
PAREQAPP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRASET1 COMPANY HR170 HR70.1
REQUISITION PA02.1 PA102
EMP-APP PA243 PA41.1
APPLICANT PA42.1 PA42.3
PA43.1 PA44.1
PA45.1 PA502
PA531 PA535
PRASET2 COMPANY HR11.1 HR170
EMP-APP HR70.1 PA115
APPLICANT PA120 PA231
REQUISITION PA244 PA43.2
PAREQAPP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|