PAJOBREQ FILE
Job Requisition
The Job Requisition file contains information about job or position
requisitions.
REFERENCED BY
HPJR.1 HR170 HR70.1 PA03.2 PA111 PA231
PA241 PA242 PA243 PA244 PA406 PA52.4
PA532 PA211 PA272 PA302 PA402 PA64.2
PA64.1 PA65.2 PA65.1
UPDATED BY
HR11.1 PA02.1 PA102 PA115 PA120 PA41.1
PA42.1 PA43.1 PA43.2 PA44.1 PA45.1 PA46.1
PA502
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PJR-COMPANY Numeric 4 PA02.1 PA102
Company Contains the company number, which PA42.1 PA502
represents an established company.
PJR-REQUISITION Numeric 9 PA02.1 PA102
Requisition Contains the system-assigned number PA42.1 PA502
that represents the requisition.
PJR-DESCRIPTION Alpha 30 (Lower Case) PA02.1 PA102
Description Contains the description of the PA42.1 PA502
requisition.
PJR-POSITION Alpha 12 PA02.1 PA102
Position Contains the user-defined code that PA42.1 PA502
represents a position in the company.
PJR-JOB-CODE Alpha 9 PA02.1 PA102
Job Code Contains the code that represents the PA42.1 PA502
new or open job.
PJR-REQ-STATUS Alpha 10 PA02.1 PA102
Requisition Status Contains the status of the requisition. PA42.1 PA45.1
PA502
PJR-OPENINGS Numeric 3 PA02.1 PA102
Openings Contains the number of open jobs or PA42.1 PA502
positions.
PJR-REPLACEMENT Alpha 1 PA02.1 PA102
Replacement Indicates whether the requisition is PA42.1 PA502
for a replacement of a current job and
position.
Y = Yes
N = No
PJR-REP-EMPLOYEE Numeric 9 PA02.1 PA102
Replacement For Contains the number that represents the PA42.1 PA502
employee being replaced.
This field is valid only when the
Replacement field is Yes.
PJR-BUDGETED-FLAG Alpha 1 PA02.1 PA102
Budgeted Indicates whether the requisition is PA42.1 PA502
for a job and position that is budgeted.
Y = Yes
N = No
PJR-REQUEST-DATE Numeric 8 (yyyymmdd) PA02.1 PA102
Requested Contains the date the requisition is PA42.1 PA502
requested.
PJR-REQUEST-BY Numeric 9 PA02.1 PA102
Requested By Contains the number that represents the PA42.1 PA502
employee who requested the requisition.
PJR-DATE-NEEDED Numeric 8 (yyyymmdd) PA02.1 PA102
Needed Contains the date on which the job PA42.1 PA502
should be filled.
PJR-OPEN-DATE Numeric 8 (yyyymmdd) PA02.1 PA102
Open Contains the date the requisition is PA42.1 PA502
open.
PJR-CLOSED-DATE Numeric 8 (yyyymmdd) PA02.1 PA102
Closed Contains the date the requisition was PA42.1 PA45.1
closed. PA502
PJR-APP-STATUS Alpha 2 PA02.1 PA102
Employee Status Contains the employee status of the job PA42.1 PA502
and position on the requisition.
PJR-TEMP-BEGIN Numeric 8 (yyyymmdd) PA02.1 PA102
Temporary Begin Date Contains the date the temporary PA42.1 PA502
position begins.
PJR-TEMP-END Numeric 8 (yyyymmdd) PA02.1 PA102
Temporary End Date Contains the date the temporary PA42.1 PA502
position ends.
PJR-SCHEDULE Alpha 9 PA02.1 PA102
Schedule Contains the step and grade schedule or PA42.1 PA502
the grade range schedule of the job on
the requisition.
PJR-PAY-GRADE Alpha 3 PA02.1 PA102
Grade Contains the grade of the job on the PA42.1 PA502
requisition.
PJR-PAY-STEP Numeric 2 PA02.1 PA102
Step Contains the step of the job on the PA42.1 PA502
requisition.
PJR-SALARY-CLASS Alpha 1 PA02.1 PA102
Salary Class Contains the salary class of the job on PA42.1 PA502
the requisition.
H = Hourly
S = Salaried
PJR-BEG-PAY-RATE Signed 13.4 PA02.1 PA102
Beginning Pay Rate Contains the minimum pay rate an PA42.1 PA502
employee receives in the job.
PJR-END-PAY-RATE Signed 13.4 PA02.1 PA102
Ending Pay Rate Contains the maximum pay rate an PA42.1 PA502
employee receives in the job.
PJR-EXEMPT-EMP Alpha 1 PA02.1 PA102
Exempt Indicates whether an employee is exempt PA42.1 PA502
from overtime pay when the requisition's
job or position.
Y = Yes
N = No
PJR-WORK-SCHED Alpha 10 PA02.1 PA102
Work Schedule Contains the work schedule of the job. PA42.1 PA502
The work schedule must be valid in the
Human Resource Code file.
PJR-PROCESS-LEVEL Alpha 5 PA02.1 PA102
Process Level Contains the process level in which the PA42.1 PA502
job and position are needed.
PJR-DEPARTMENT Alpha 5 PA02.1 PA102
Department Contains the department in which the PA42.1 PA502
job and position are needed.
PJR-USER-LEVEL Alpha 10 PA02.1 PA102
User Level Contains the user level in which the PA42.1 PA502
job and position are needed.
PJR-LOCAT-CODE Alpha 10 PA02.1 PA102
Location Contains the location at which the job PA42.1 PA502
and position are needed.
PJR-SUPERVISOR Alpha 10 PA02.1 PA102
Supervisor Contains the employee who supervises PA42.1 PA502
the position.
PJR-TOTAL-APPLIED Numeric 3 PA115 PA120
Total Applicants Contains the total number of applicants PA43.1 PA43.2
who applied for the requisition.
PJR-INTERVIEWS Numeric 3 PA115 PA120
Interviews Contains the total number of interviews PA41.1
for the requisition.
PJR-OFFERS-EXTEND Numeric 3 PA115 PA120
Offers Extended Contains the number of times an offer PA45.1
was extended for the requisition.
PJR-OFFERS-ACCEPT Numeric 3 PA02.1 PA102
Offers Accepted Contains the number of times an offer PA115 PA120
was accepted for the requisition. PA42.1 PA45.1
PA502
PJR-OFFERS-DECLINE Numeric 3 PA115 PA120
Offers Declined Contains the number of times an offer PA45.1
was declined for the requisition.
PJR-TOT-COST Signed 11.2 PA115 PA120
Total Cost Contains the total cost of the PA44.1
requisition.
PJR-NBR-APPROVALS Numeric 2 PA02.1 PA102
Number of Approvals Contains the number of people who need PA42.1 PA502
to approve the requisition before
applicants can be hired.
PJR-APPROVAL-DESC Alpha 30 (Lower Case) PA02.1 PA102
Title Description Occurs 10 Times PA42.1 PA502
Contains the title or name of the
person who needs to approve the
requisition.
PJR-APPROVAL-DATE Numeric 8 (yyyymmdd) Occurs 10 Times PA02.1 PA102
Date Contains the date the person approved PA42.1 PA502
the requisition.
PJR-APPROVAL-EMP Numeric 9 Occurs 10 Times PA02.1 PA102
Approved By Contains the number of the employee who PA42.1 PA502
approved the requisition.
PJR-INTERNAL-START Numeric 8 (yyyymmdd) PA02.1 PA102
Internal Posting Contains the first date the requisition PA42.1 PA502
Dates - Start is posted in the company.
PJR-INTERNAL-STOP Numeric 8 (yyyymmdd) PA02.1 PA102
Internal Posting Contains the last date the requisition PA42.1 PA502
Dates - Stop is posted in the company.
PJR-EXTERNAL-START Numeric 8 (yyyymmdd) PA02.1 PA102
External Posting Contains the first date the requisition PA42.1 PA502
Dates - Start is posted outside the company.
PJR-EXTERNAL-STOP Numeric 8 (yyyymmdd) PA02.1 PA102
External Posting Contains the last date the requisition PA42.1 PA502
Dates - Stop is posted outside the company.
PJR-CONTACT-NBR Numeric 9 PA02.1 PA102
Contact Employee Contains the number of the employee who PA42.1 PA502
should be contacted about the
requisition.
PJR-CONTACT-LAST Alpha 30 (Lower Case) PA02.1 PA102
Contact's Last Name Contains the last name of the employee PA42.1 PA502
who should be contacted about the
requisition.
PJR-CONTACT-FIRST Alpha 15 (Lower Case) PA02.1 PA102
Contact's First Name Contains the first name of the employee PA42.1 PA502
who should be contacted about the
requisition.
PJR-CONTACT-MI Alpha 1 PA02.1 PA102
Contact's Middle Contains the middle initial of the PA42.1 PA502
Initial employee who should be contacted about
the requisition.
PJR-WK-PHONE-CNTRY Alpha 6 PA02.1 PA102
Work Telephone Contains the prefix of the telephone PA42.1 PA502
Country number of the employee who should be
contacted about the requisition.
PJR-WK-PHONE-NBR Alpha 15 PA02.1 PA102
Work Telephone Contains the telephone number of the PA42.1 PA502
employee who should be contacted about
the requisition.
PJR-WK-PHONE-EXT Alpha 5 PA02.1 PA102
Work Telephone Contains the extension of the telephone PA42.1 PA502
Extension number of the employee who should be
contacted about the requisition.
PJR-SHORT-DESC1 Alpha 30 (Lower Case) PA02.1 PA102
Short Description 1 Contains the first line of either PA42.1 PA502
(1) a description of the job and
position on the requisition, or
(2) any other information you want.
PJR-SHORT-DESC2 Alpha 30 (Lower Case) PA02.1 PA102
Short Description 2 Contains the second line of either PA42.1 PA502
(1) a description of the job and
position on the requisition, or
(2) any other information the you want.
PJR-SHORT-DESC3 Alpha 30 (Lower Case) PA02.1 PA102
Short Description 3 Contains the third line of either PA42.1 PA502
(1) a description of the job and
position on the requisition, or
(2) any other information the you want.
PJR-SPEC-REQ1 Alpha 30 (Lower Case) PA02.1 PA102
Special Contains the first line of either PA42.1 PA502
Requirements 1
(1) a description of the requirements
of the job and position on the
requisition, or
(2) any other information you want.
PJR-SPEC-REQ2 Alpha 30 (Lower Case) PA02.1 PA102
Special Contains the second line of either PA42.1 PA502
Requirements 2
(1) a description of the requirements
of the job and position on the
requisition, or
(2) any other information the you want.
PJR-SPEC-REQ3 Alpha 30 (Lower Case) PA02.1 PA102
Special Contains the first line of either PA42.1 PA502
Requirements 3
(1) a description of the requirements
of the job and position on the
requisition, or
(2) any other information you want.
PJR-LAST-CMT-SEQ Numeric 4 PA46.1
Last Comment Contains the sequence number of the
Sequence Number last comment.
PJR-OPEN-FTE Signed 8.3 PA02.1 PA102
Open FTE Contains the total FTE for all open PA42.1 PA502
requisitions for a job.
PJR-FILLED-FTE Signed 8.3 HR11.1 PA02.1
Filled FTE Contains the FTE for requisitions which PA102 PA42.1
have been filled for a job. PA45.1 PA502
PJR-SHIFT Numeric 1 PA02.1 PA102
Shift Contains the shift number associated PA42.1 PA502
with the pay.
1 = Shift 1
2 = Shift 2
3 = Shift 3
4 = Shift 4
5 = Shift 5
6 = Shift 6
7 = Shift 7
8 = Shift 8
9 = Shift 9
PJR-EFFECT-DATE Numeric 8 (yyyymmdd) PA02.1 PA102
Effective Date Contains the effective date of the PA42.1 PA502
information about this requisition. Job
requisition changes are not kept
historically at this time. This field is
primarily used to provide consistency
in the look of the form.
PJR-POS-EFFECT-DAT Numeric 8 (yyyymmdd) PA02.1 PA102
Pos Effect Dat Contains the effective date for the PA42.1 PA502
position.
PJR-DATE-STAMP Numeric 8 (yyyymmdd) PA02.1 PA102
Date Stamp This field contains the server date PA42.1 PA45.1
(month, date, and year) of the last PA502
change to this record.
PJR-TIME-STAMP Numeric 6 (hhmmss) PA02.1 PA102
Time Stamp Contains the server time (hour, minute, PA42.1 PA45.1
and second) when the record was last PA502
changed.
PJR-USER-ID Alpha 10 (Lower Case) PA02.1 PA102
User ID Name Contains the user ID of the person who PA42.1 PA45.1
last changed this record. PA502
PJR-REMAINING-OPEN Derived
Remaining Openins Contains the number of open
requisitions remaining for a job.
PJR-REMAINING-FTE Derived
Remaining FTE Contains the FTE remaining before total
budgeted FTE for a job is met.
PJR-CURRENCY-CODE Alpha 5 PA02.1 PA102
Currency Code Contains the currency in which the PA42.1 PA502
salary is recorded.
PJR-CURR-ND Numeric 1 PA02.1 PA102
Currency Number of Represents the number of decimals PA42.1 PA502
Decimals defined for the currency of the object.
PJR-CURR-CODE-2 Alpha 5 PA44.1
Report Currency 2 Contains the currency in which
Code requisition costs are recorded.
PJR-CURR-CODE-ND-2 Numeric 1 PA44.1
Curr Code Nd 2 The number of decimal positions defined
for Report Currency 2.
PJR-BASE-BEG-PAY Signed 11.2 PA02.1 PA102
Base Beg Pay Contains the beginning pay in the PA42.1 PA502
company's base currency.
PJR-BASE-END-PAY Signed 11.2 PA02.1 PA102
Base End Pay Contains the ending pay in the PA42.1 PA502
company's base currency.
PJR-BASE-CURRENCY Alpha 5 PA02.1 PA102
Base Currency Contains the company base currency. PA42.1 PA44.1
PA502
PJR-BASE-ND Numeric 1 PA02.1 PA102
Base Number Of The number of decimal positions defined PA42.1 PA44.1
Decimals for the company base currency. PA502
PJR-BASE-AMOUNT Signed 15.2 PA44.1
Base Amount Contains the amount in the company's
base currency.
PJR-APPROVAL-FLAG Alpha 1
Approval " " = Yes
N = No
Y = Yes
PJR-WF-PEND-REQ Derived
Wf Pend Req
PAJOBREQ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PJRSET1 COMPANY HPJR.1 HR11.1
REQUISITION HR170 HR70.1
PA02.1 PA03.2
PA102 PA111
PA115 PA120
PA231 PA241
PA242 PA243
PA244 PA406
PA41.1 PA42.1
PA43.1 PA43.2
PA44.1 PA45.1
PA46.1 PA502
PA52.4 PA532
PJRSET2 COMPANY KeyChange, Subset PA02.1 PA102
POSITION Where (POSITION != Spaces ) PA211 PA272
REQUISITION PA302 PA402
PA406 PA502
PA64.2 PA65.2
PJRSET3 COMPANY KeyChange, Subset PA211 PA272
PROCESS-LEVEL Where (POSITION = Spaces )
DEPARTMENT
JOB-CODE
REQUISITION
PJRSET4 COMPANY KeyChange PA64.1 PA65.1
JOB-CODE
REQUISITION
PJRSET5 COMPANY KeyChange, Subset
SUPERVISOR Where SUPERVISOR != Spaces
REQUISITION
PAJOBREQ FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
App Status EMSTATUS Required
When PJR-APP-STATUS != Spaces
PJR-COMPANY -> EMS-COMPANY
PJR-APP-STATUS -> EMS-EMP-STATUS
Approval Emp EMPLOYEE Required
When PJR-APPROVAL-EMP != Zeroes
PJR-COMPANY -> EMP-COMPANY
PJR-APPROVAL-EMP -> EMP-EMPLOYEE
Base Currency CUCODES Required
When PJR-CURRENCY-CODE != Spaces
Or PJR-CURR-CODE-2 != Spaces
PJR-CURRENCY-CODE -> CUC-CURRENCY-CODE
Company PRSYSTEM Required
PJR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Contact Nbr EMPLOYEE Required
When PJR-CONTACT-NBR != Zeroes
PJR-COMPANY -> EMP-COMPANY
PJR-CONTACT-NBR -> EMP-EMPLOYEE
Currency CUCODES Required
When (PJR-CURRENCY-CODE != Spaces )
PJR-CURRENCY-CODE -> CUC-CURRENCY-CODE
Currency2 CUCODES Required
When (PJR-CURR-CODE-2 != Spaces )
PJR-CURR-CODE-2 -> CUC-CURRENCY-CODE
Department DEPTCODE Required
When PJR-DEPARTMENT != Spaces
PJR-COMPANY -> DPT-COMPANY
PJR-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
PJR-DEPARTMENT -> DPT-DEPARTMENT
Job Code JOBCODE Required
When PJR-JOB-CODE != Spaces
PJR-COMPANY -> JBC-COMPANY
PJR-JOB-CODE -> JBC-JOB-CODE
Location PCODES Required
When PJR-LOCAT-CODE != Spaces
"LO" -> PCO-TYPE
PJR-LOCAT-CODE -> PCO-CODE
Pos Date PAPOSITION Required
When (PJR-POSITION != Spaces )
PJR-COMPANY -> POS-COMPANY
PJR-POSITION -> POS-POSITION
PJR-POS-EFFECT-DAT -> POS-EFFECT-DATE
Process Level PRSYSTEM Required
When PJR-PROCESS-LEVEL != Spaces
PJR-COMPANY -> PRS-COMPANY
PJR-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Rep Employee EMPLOYEE Required
When PJR-REP-EMPLOYEE != Zeroes
PJR-COMPANY -> EMP-COMPANY
PJR-REP-EMPLOYEE -> EMP-EMPLOYEE
Req Status PCODES Required
When PJR-REQ-STATUS != Spaces
"RQ" -> PCO-TYPE
PJR-REQ-STATUS -> PCO-CODE
Request By EMPLOYEE Required
When PJR-REQUEST-BY != Zeroes
PJR-COMPANY -> EMP-COMPANY
PJR-REQUEST-BY -> EMP-EMPLOYEE
Supervisor HRSUPER Required
When PJR-SUPERVISOR != Spaces
PJR-COMPANY -> HSU-COMPANY
PJR-SUPERVISOR -> HSU-CODE
User Level PCODES Not Required
Valid When PJR-USER-LEVEL != Spaces
"UL" -> PCO-TYPE
PJR-USER-LEVEL -> PCO-CODE
Work Schedule PCODES Required
When PJR-WORK-SCHED != Spaces
"WS" -> PCO-TYPE
PJR-WORK-SCHED -> PCO-CODE
PAJOBREQ FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Applicants PAREQAPP Delete Cascades
PJR-COMPANY -> PRA-COMPANY
PJR-REQUISITION -> PRA-REQUISITION
PRA-EMP-APP
PRA-APPLICANT
Comments PACOMMENTS Delete Cascades
PJR-COMPANY -> PAC-COMPANY
2 -> PAC-EMP-APP
"JR" -> PAC-CMT-TYPE
PAC-EMPLOYEE
PAC-JOB-CODE
PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Cost PAREQCOST Delete Cascades
PJR-COMPANY -> PRC-COMPANY
PJR-REQUISITION -> PRC-REQUISITION
PRC-DATE
PRC-REASON
PRC-EMP-APP
PRC-APPLICANT
Ext Applicants PAREQAPP
PJR-COMPANY -> PRA-COMPANY
PJR-REQUISITION -> PRA-REQUISITION
1 -> PRA-EMP-APP
PRA-APPLICANT
Int Applicants PAREQAPP
PJR-COMPANY -> PRA-COMPANY
PJR-REQUISITION -> PRA-REQUISITION
Zeroes -> PRA-EMP-APP
PRA-APPLICANT
Offers PAREQOFFER Delete Cascades
PJR-COMPANY -> PRF-COMPANY
PJR-REQUISITION -> PRF-REQUISITION
PRF-EMP-APP
PRF-APPLICANT
PRF-DATE
PRF-OFFER-TYPE
Pos Chg Error PAPOSERR Delete Cascades
Valid When (PJR-POSITION != Spaces )
PJR-COMPANY -> PPE-COMPANY
Zeroes -> PPE-EMPLOYEE
PJR-REQUISITION -> PPE-REQUISITION
PJR-POSITION -> PPE-POSITION
PPE-EFFECT-DATE
PPE-UPDATE-TYPE
Pos Rules PAPOSRULE
PJR-COMPANY -> PPR-COMPANY
PJR-PROCESS-LEVEL -> PPR-PROCESS-LEVEL
PJR-DEPARTMENT -> PPR-DEPARTMENT
PPR-EFFECT-DATE
Position PAPOSITION Required
When (PJR-POSITION != Spaces )
PJR-COMPANY -> POS-COMPANY
PJR-POSITION -> POS-POSITION
POS-EFFECT-DATE
|
