|
|
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
Element: Company Contains the company number, which PA42.1 PA502
represents an established company.
PJR-REQUISITION Numeric 9 PA02.1 PA102
Element: Requisition Contains the system-assigned number PA42.1 PA502
that represents the requisition.
PJR-DESCRIPTION Alpha 30 (Lower Case) PA02.1 PA102
Element: Description Contains the description of the PA42.1 PA502
requisition.
PJR-POSITION Alpha 12 PA02.1 PA102
Element: Position Contains the user-defined code that PA42.1 PA502
represents a position in the company.
PJR-JOB-CODE Alpha 9 PA02.1 PA102
Element: Job Code Contains the code that represents the PA42.1 PA502
new or open job.
PJR-REQ-STATUS Alpha 10 PA02.1 PA102
Element: Requisition StContains the status of the requisition. PA42.1 PA45.1
PA502
PJR-OPENINGS Numeric 3 PA02.1 PA102
Element: Openings Contains the number of open jobs or PA42.1 PA502
positions.
PJR-REPLACEMENT Alpha 1 PA02.1 PA102
Element: 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
Element: Replacement FoContains 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
Element: 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
Element: Requested Contains the date the requisition is PA42.1 PA502
requested.
PJR-REQUEST-BY Numeric 9 PA02.1 PA102
Element: 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
Element: Needed Contains the date on which the job PA42.1 PA502
should be filled.
PJR-OPEN-DATE Numeric 8 (yyyymmdd) PA02.1 PA102
Element: Open Contains the date the requisition is PA42.1 PA502
open.
PJR-CLOSED-DATE Numeric 8 (yyyymmdd) PA02.1 PA102
Element: Closed Contains the date the requisition was PA42.1 PA45.1
closed. PA502
PJR-APP-STATUS Alpha 2 PA02.1 PA102
Element: Employee StatuContains the employee status of the job PA42.1 PA502
and position on the requisition.
PJR-TEMP-BEGIN Numeric 8 (yyyymmdd) PA02.1 PA102
Element: Temporary BegiContains the date the temporary PA42.1 PA502
position begins.
PJR-TEMP-END Numeric 8 (yyyymmdd) PA02.1 PA102
Element: Temporary End Contains the date the temporary PA42.1 PA502
position ends.
PJR-SCHEDULE Alpha 9 PA02.1 PA102
Element: 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
Element: Grade Contains the grade of the job on the PA42.1 PA502
requisition.
PJR-PAY-STEP Numeric 2 PA02.1 PA102
Element: Step Contains the step of the job on the PA42.1 PA502
requisition.
PJR-SALARY-CLASS Alpha 1 PA02.1 PA102
Element: 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
Element: Beginning Pay Contains the minimum pay rate an PA42.1 PA502
employee receives in the job.
PJR-END-PAY-RATE Signed 13.4 PA02.1 PA102
Element: Ending Pay RatContains the maximum pay rate an PA42.1 PA502
employee receives in the job.
PJR-EXEMPT-EMP Alpha 1 PA02.1 PA102
Element: 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
Element: 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
Element: Process Level Contains the process level in which the PA42.1 PA502
job and position are needed.
PJR-DEPARTMENT Alpha 5 PA02.1 PA102
Element: Department Contains the department in which the PA42.1 PA502
job and position are needed.
PJR-USER-LEVEL Alpha 10 PA02.1 PA102
Element: 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
Element: Location Contains the location at which the job PA42.1 PA502
and position are needed.
PJR-SUPERVISOR Alpha 10 PA02.1 PA102
Element: Supervisor Contains the employee who supervises PA42.1 PA502
the position.
PJR-TOTAL-APPLIED Numeric 3 PA115 PA120
Element: Total ApplicanContains the total number of applicants PA43.1 PA43.2
who applied for the requisition.
PJR-INTERVIEWS Numeric 3 PA115 PA120
Element: Interviews Contains the total number of interviews PA41.1
for the requisition.
PJR-OFFERS-EXTEND Numeric 3 PA115 PA120
Element: Offers ExtendeContains the number of times an offer PA45.1
was extended for the requisition.
PJR-OFFERS-ACCEPT Numeric 3 PA02.1 PA102
Element: Offers AccepteContains 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
Element: Offers DeclineContains the number of times an offer PA45.1
was declined for the requisition.
PJR-TOT-COST Signed 11.2 PA115 PA120
Element: Total Cost Contains the total cost of the PA44.1
requisition.
PJR-NBR-APPROVALS Numeric 2 PA02.1 PA102
Element: Number of ApprContains 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
Element: Title DescriptOccurs 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
Element: Date Contains the date the person approved PA42.1 PA502
the requisition.
PJR-APPROVAL-EMP Numeric 9 Occurs 10 Times PA02.1 PA102
Element: 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
Element: Contact EmployContains 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
Element: Contact's LastContains 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
Element: Contact's FirsContains 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
Element: Work TelephoneContains 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
Element: Short DescriptContains 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
Element: Short DescriptContains 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
Element: Short DescriptContains 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
Element: 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
Element: 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
Element: 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
Element: Effective DateContains 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
Element: Pos Effect DatContains the effective date for the PA42.1 PA502
position.
PJR-DATE-STAMP Numeric 8 (yyyymmdd) PA02.1 PA102
Element: 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
Element: 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
Element: User PA42.1 PA45.1
PA502
PJR-REMAINING-OPEN Derived
Element: Remaining OpenContains the number of open
requisitions remaining for a job.
PJR-REMAINING-FTE Derived
Element: Remaining FTE Contains the FTE remaining before total
budgeted FTE for a job is met.
PJR-CURRENCY-CODE Alpha 5 PA02.1 PA102
Element: Currency Code Contains the currency in which the PA42.1 PA502
salary is recorded.
PJR-CURR-ND Numeric 1 PA02.1 PA102
Account Currency PA42.1 PA502
Code
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
Account Currency
Code
PJR-BASE-BEG-PAY Signed 11.2 PA02.1 PA102
Element: 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
Element: Base End Pay Contains the ending pay in the PA42.1 PA502
company's base currency.
PJR-BASE-CURRENCY Alpha 5 PA02.1 PA102
To Company Base Contains the company base currency. PA42.1 PA44.1
Currency PA502
PJR-BASE-ND Numeric 1 PA02.1 PA102
Account Currency PA42.1 PA44.1
Code PA502
PJR-BASE-AMOUNT Signed 15.2 PA44.1
Element: Adj Amt Contains the amount in the company's
base currency.
PJR-APPROVAL-FLAG Alpha 1
Element: Approval " " = Yes
N = No
Y = Yes
PJR-WF-PEND-REQ Derived
Element: Wf Pend Req
PJR-LABEL-NAME Derived
Element: Label Name
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
|
