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 PA532
PA211 PA272 PA302 PA402 PA64.2 PA64.1
PA65.2 PA65.1
UPDATED BY
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 PA42.1 PA502
Company Contains the company number, which
represents an established company.
PJR-REQUISITION Numeric 9 PA42.1 PA502
Requisition Contains the system-assigned number
that represents the requisition.
PJR-DESCRIPTION Alpha 30 (Lower Case) PA42.1 PA502
Description Contains the description of the
requisition.
PJR-POSITION Alpha 12 PA42.1 PA502
Position Contains the user-defined code that
represents a position in the company.
PJR-JOB-CODE Alpha 9 PA42.1 PA502
Job Code Contains the code that represents the
new or open job.
PJR-REQ-STATUS Alpha 10 PA42.1 PA45.1
Requisition Status Contains the status of the requisition. PA502
PJR-OPENINGS Numeric 3 PA42.1 PA502
Openings Contains the number of open jobs or
positions.
PJR-REPLACEMENT Alpha 1 PA42.1 PA502
Replacement Indicates whether the requisition is
for a replacement of a current job and
position.
Y = Yes
N = No
PJR-REP-EMPLOYEE Numeric 9 PA42.1 PA502
Replacement For Contains the number that represents the
employee being replaced.
This field is valid only when the
Replacement field is Yes.
PJR-BUDGETED-FLAG Alpha 1 PA42.1 PA502
Budgeted Indicates whether the requisition is
for a job and position that is budgeted.
Y = Yes
N = No
PJR-REQUEST-DATE Numeric 8 (yyyymmdd) PA42.1 PA502
Requested Contains the date the requisition is
requested.
PJR-REQUEST-BY Numeric 9 PA42.1 PA502
Requested By Contains the number that represents the
employee who requested the requisition.
PJR-DATE-NEEDED Numeric 8 (yyyymmdd) PA42.1 PA502
Needed Contains the date on which the job
should be filled.
PJR-OPEN-DATE Numeric 8 (yyyymmdd) PA42.1 PA502
Open Contains the date the requisition is
open.
PJR-CLOSED-DATE Numeric 8 (yyyymmdd) PA42.1 PA45.1
Closed Contains the date the requisition was PA502
closed.
PJR-APP-STATUS Alpha 2 PA42.1 PA502
Employee Status Contains the employee status of the job
and position on the requisition.
PJR-TEMP-BEGIN Numeric 8 (yyyymmdd) PA42.1 PA502
Temporary Begin Date Contains the date the temporary
position begins.
PJR-TEMP-END Numeric 8 (yyyymmdd) PA42.1 PA502
Temporary End Date Contains the date the temporary
position ends.
PJR-SCHEDULE Alpha 9 PA42.1 PA502
Schedule Contains the step and grade schedule or
the grade range schedule of the job on
the requisition.
PJR-PAY-GRADE Alpha 3 PA42.1 PA502
Grade Contains the grade of the job on the
requisition.
PJR-PAY-STEP Numeric 2 PA42.1 PA502
Step Contains the step of the job on the
requisition.
PJR-SALARY-CLASS Alpha 1 PA42.1 PA502
Salary Class Contains the salary class of the job on
the requisition.
H = Hourly
S = Salaried
PJR-BEG-PAY-RATE Signed 13.4 PA42.1 PA502
Beginning Pay Rate Contains the minimum pay rate an
employee receives in the job.
PJR-END-PAY-RATE Signed 13.4 PA42.1 PA502
Ending Pay Rate Contains the maximum pay rate an
employee receives in the job.
PJR-EXEMPT-EMP Alpha 1 PA42.1 PA502
Exempt Indicates whether an employee is exempt
from overtime pay when the requisition's
job or position.
Y = Yes
N = No
PJR-WORK-SCHED Alpha 10 PA42.1 PA502
Work Schedule Contains the work schedule of the job.
The work schedule must be valid in the
Human Resource Code file.
PJR-PROCESS-LEVEL Alpha 5 PA42.1 PA502
Process Level Contains the process level in which the
job and position are needed.
PJR-DEPARTMENT Alpha 5 PA42.1 PA502
Department Contains the department in which the
job and position are needed.
PJR-USER-LEVEL Alpha 10 PA42.1 PA502
User Level Contains the user level in which the
job and position are needed.
PJR-LOCAT-CODE Alpha 10 PA42.1 PA502
Location Contains the location at which the job
and position are needed.
PJR-SUPERVISOR Alpha 10 PA42.1 PA502
Supervisor Contains the employee who supervises
the position.
PJR-TOTAL-APPLIED Numeric 3 PA120 PA43.1
Total Applicants Contains the total number of applicants PA43.2
who applied for the requisition.
PJR-INTERVIEWS Numeric 3 PA120 PA41.1
Interviews Contains the total number of interviews
for the requisition.
PJR-OFFERS-EXTEND Numeric 3 PA120 PA45.1
Offers Extended Contains the number of times an offer
was extended for the requisition.
PJR-OFFERS-ACCEPT Numeric 3 PA120 PA42.1
Offers Accepted Contains the number of times an offer PA45.1 PA502
was accepted for the requisition.
PJR-OFFERS-DECLINE Numeric 3 PA120 PA45.1
Offers Declined Contains the number of times an offer
was declined for the requisition.
PJR-TOT-COST Signed 11.2 PA120 PA44.1
Total Cost Contains the total cost of the
requisition.
PJR-NBR-APPROVALS Numeric 2 PA42.1 PA502
Number of Approvals Contains the number of people who need
to approve the requisition before
applicants can be hired.
PJR-APPROVAL-DESC Alpha 30 (Lower Case) PA42.1 PA502
Title Description Occurs 10 Times
Contains the title or name of the
person who needs to approve the
requisition.
PJR-APPROVAL-DATE Numeric 8 (yyyymmdd) Occurs 10 Times PA42.1 PA502
Date Contains the date the person approved
the requisition.
PJR-APPROVAL-EMP Numeric 9 Occurs 10 Times PA42.1 PA502
Approved By Contains the number of the employee who
approved the requisition.
PJR-INTERNAL-START Numeric 8 (yyyymmdd) PA42.1 PA502
Internal Posting Contains the first date the requisition
Dates - Start is posted in the company.
PJR-INTERNAL-STOP Numeric 8 (yyyymmdd) PA42.1 PA502
Internal Posting Contains the last date the requisition
Dates - Stop is posted in the company.
PJR-EXTERNAL-START Numeric 8 (yyyymmdd) PA42.1 PA502
External Posting Contains the first date the requisition
Dates - Start is posted outside the company.
PJR-EXTERNAL-STOP Numeric 8 (yyyymmdd) PA42.1 PA502
External Posting Contains the last date the requisition
Dates - Stop is posted outside the company.
PJR-CONTACT-NBR Numeric 9 PA42.1 PA502
Contact Employee Contains the number of the employee who
should be contacted about the
requisition.
PJR-CONTACT-LAST Alpha 30 (Lower Case) PA42.1 PA502
Contact's Last Name Contains the last name of the employee
who should be contacted about the
requisition.
PJR-CONTACT-FIRST Alpha 15 (Lower Case) PA42.1 PA502
Contact's First Name Contains the first name of the employee
who should be contacted about the
requisition.
PJR-CONTACT-MI Alpha 1 PA42.1 PA502
Contact's Middle Contains the middle initial of the
Initial employee who should be contacted about
the requisition.
PJR-WK-PHONE-CNTRY Alpha 6 PA42.1 PA502
Work Telephone Contains the prefix of the telephone
Country number of the employee who should be
contacted about the requisition.
PJR-WK-PHONE-NBR Alpha 15 PA42.1 PA502
Work Telephone Contains the telephone number of the
employee who should be contacted about
the requisition.
PJR-WK-PHONE-EXT Alpha 5 PA42.1 PA502
Work Telephone Contains the extension of the telephone
Extension number of the employee who should be
contacted about the requisition.
PJR-SHORT-DESC1 Alpha 30 (Lower Case) PA42.1 PA502
Short Description 1 Contains the first line of either
(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) PA42.1 PA502
Short Description 2 Contains the second line of either
(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) PA42.1 PA502
Short Description 3 Contains the third line of either
(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) PA42.1 PA502
Special Contains the first line of either
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) PA42.1 PA502
Special Contains the second line of either
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) PA42.1 PA502
Special Contains the first line of either
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 PA42.1 PA502
Open FTE Contains the total FTE for all open
requisitions for a job.
PJR-FILLED-FTE Signed 8.3 PA42.1 PA45.1
Filled FTE Contains the FTE for requisitions which PA502
have been filled for a job.
PJR-SHIFT Numeric 1 PA42.1 PA502
Shift Contains the shift number associated
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) PA42.1 PA502
Effective Date Contains the effective date of the
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) PA42.1 PA502
Pos Effect Dat Contains the effective date for the
position.
PJR-DATE-STAMP Numeric 8 (yyyymmdd) PA42.1 PA45.1
Date Stamp This field contains the server date PA502
(month, date, and year) of the last
change to this record.
PJR-TIME-STAMP Numeric 6 (hhmmss) PA42.1 PA45.1
Time Stamp Contains the server time (hour, minute, PA502
and second) when the record was last
changed.
PJR-USER-ID Alpha 10 (Lower Case) PA42.1 PA45.1
User ID Name Contains the user ID of the person who PA502
last changed this record.
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 PA42.1 PA502
Currency Code Contains the currency in which the
salary is recorded.
PJR-CURR-ND Numeric 1 PA42.1 PA502
Currency Number of Represents the number of decimals
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 PA42.1 PA502
Base Beg Pay Contains the beginning pay in the
company's base currency.
PJR-BASE-END-PAY Signed 11.2 PA42.1 PA502
Base End Pay Contains the ending pay in the
company's base currency.
PJR-BASE-CURRENCY Alpha 5 PA42.1 PA44.1
Base Currency Contains the company base currency. PA502
PJR-BASE-ND Numeric 1 PA42.1 PA44.1
Base Number Of The number of decimal positions defined PA502
Decimals for the company base currency.
PJR-BASE-AMOUNT Signed 15.2 PA44.1
Base Amount Contains the amount in the company's
base currency.
PAJOBREQ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PJRSET1 COMPANY HPJR.1 HR170
REQUISITION HR70.1 PA03.2
PA111 PA120
PA231 PA241
PA242 PA243
PA244 PA406
PA41.1 PA42.1
PA43.1 PA43.2
PA44.1 PA45.1
PA46.1 PA502
PA532
PJRSET2 COMPANY KeyChange, Subset PA211 PA272
POSITION Where (POSITION != Spaces ) PA302 PA402
REQUISITION 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
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
|
