Job Requisition
The Job Requisition file contains information about job or position requisitions.
REFERENCED BY
HPJR.1 | HR170 | HR70.1 | PA03.2 | PA100 | PA111 |
PA231 | PA241 | PA242 | PA243 | PA244 | PA406 |
PA52.4 | PA532 | ZE532 | SNEM.1 | PA211 | PA272 |
PA302 | PA402 | PA64.2 | PA64.1 | PA65.2 | PA65.1 |
HR11.1 | LT101 | LT111 | PA02.1 | PA102 | PA115 |
PA120 | PA41.1 | PA42.1 | PA42.3 | PA43.1 | PA43.2 |
PA44.1 | PA45.1 | PA46.1 | PA502 | PA531 | PA535 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PJR-COMPANY Element: Company | Numeric 4 Contains the company number, which represents an established company. |
|
||||||||||||
PJR-REQUISITION Element: Requisition | Numeric 9 Contains the system-assigned number that represents the requisition. |
|
||||||||||||
PJR-DESCRIPTION Element: Description | Alpha 30 (Lower Case) Contains the description of the requisition. |
|
||||||||||||
PJR-POSITION Element: Position | Alpha 12 Contains the user-defined code that represents a position in the company. |
|
||||||||||||
PJR-JOB-CODE Element: Job Code | Alpha 9 Contains the code that represents the new or open job. |
|
||||||||||||
PJR-REQ-STATUS Element: Requisition Status | Alpha 10 Contains the status of the requisition. |
|
||||||||||||
PJR-OPENINGS Element: Openings | Numeric 3 Contains the number of open jobs or positions. |
|
||||||||||||
PJR-REPLACEMENT Element: Replacement | Alpha 1 Indicates whether the requisition is for a replacement of a current job and position. Y = Yes N = No |
|
||||||||||||
PJR-REP-EMPLOYEE Element: Replacement For | Numeric 9 Contains the number that represents the employee being replaced. This field is valid only when the Replacement field is Yes. |
|
||||||||||||
PJR-BUDGETED-FLAG Element: Budgeted | Alpha 1 Indicates whether the requisition is for a job and position that is budgeted. Y = Yes N = No |
|
||||||||||||
PJR-REQUEST-DATE Element: Requested | Numeric 8 (yyyymmdd) Contains the date the requisition is requested. |
|
||||||||||||
PJR-REQUEST-BY Element: Requested By | Numeric 9 Contains the number that represents the employee who requested the requisition. |
|
||||||||||||
PJR-DATE-NEEDED Element: Needed | Numeric 8 (yyyymmdd) Contains the date on which the job should be filled. |
|
||||||||||||
PJR-OPEN-DATE Element: Open | Numeric 8 (yyyymmdd) Contains the date the requisition is open. |
|
||||||||||||
PJR-CLOSED-DATE Element: Closed | Numeric 8 (yyyymmdd) Contains the date the requisition was closed. |
|
||||||||||||
PJR-APP-STATUS Element: Employee Status | Alpha 2 Contains the employee status of the job and position on the requisition. |
|
||||||||||||
PJR-TEMP-BEGIN Element: Temporary Begin Date | Numeric 8 (yyyymmdd) Contains the date the temporary position begins. |
|
||||||||||||
PJR-TEMP-END Element: Temporary End Date | Numeric 8 (yyyymmdd) Contains the date the temporary position ends. |
|
||||||||||||
PJR-SCHEDULE Element: Schedule | Alpha 9 Contains the step and grade schedule or the grade range schedule of the job on the requisition. |
|
||||||||||||
PJR-PAY-GRADE Element: Grade | Alpha 3 Contains the grade of the job on the requisition. |
|
||||||||||||
PJR-PAY-STEP Element: Step | Numeric 2 Contains the step of the job on the requisition. |
|
||||||||||||
PJR-SALARY-CLASS Element: Salary Class | Alpha 1 Contains the salary class of the job on the requisition. H = Hourly S = Salaried |
|
||||||||||||
PJR-BEG-PAY-RATE Element: Beginning Pay Rate | Signed 13.4 Contains the minimum pay rate an employee receives in the job. |
|
||||||||||||
PJR-END-PAY-RATE Element: Ending Pay Rate | Signed 13.4 Contains the maximum pay rate an employee receives in the job. |
|
||||||||||||
PJR-EXEMPT-EMP Element: Exempt | Alpha 1 Indicates whether an employee is exempt from overtime pay when the requisition's job or position. Y = Yes N = No |
|
||||||||||||
PJR-WORK-SCHED Element: Work Schedule | Alpha 10 Contains the work schedule of the job. The work schedule must be valid in the Human Resource Code file. |
|
||||||||||||
PJR-PROCESS-LEVEL Element: Process Level | Alpha 5 Contains the process level in which the job and position are needed. |
|
||||||||||||
PJR-DEPARTMENT Element: Department | Alpha 5 Contains the department in which the job and position are needed. |
|
||||||||||||
PJR-USER-LEVEL Element: User Level | Alpha 10 Contains the user level in which the job and position are needed. |
|
||||||||||||
PJR-LOCAT-CODE Element: Location | Alpha 10 Contains the location at which the job and position are needed. |
|
||||||||||||
PJR-UNION-CODE Element: Union Code | Alpha 10 |
|
||||||||||||
PJR-BARGAIN-UNIT Element: Bargain Unit | Alpha 10 |
|
||||||||||||
PJR-SUPERVISOR Element: Supervisor | Alpha 10 Contains the employee who supervises the position. |
|
||||||||||||
PJR-TOTAL-APPLIED Element: Total Applicants | Numeric 3 Contains the total number of applicants who applied for the requisition. |
|
||||||||||||
PJR-INTERVIEWS Element: Interviews | Numeric 3 Contains the total number of interviews for the requisition. |
|
||||||||||||
PJR-OFFERS-EXTEND Element: Offers Extended | Numeric 3 Contains the number of times an offer was extended for the requisition. |
|
||||||||||||
PJR-OFFERS-ACCEPT Element: Offers Accepted | Numeric 3 Contains the number of times an offer was accepted for the requisition. |
|
||||||||||||
PJR-OFFERS-DECLINE Element: Offers Declined | Numeric 3 Contains the number of times an offer was declined for the requisition. |
|
||||||||||||
PJR-TOT-COST Element: Total Cost | Signed 11.2 Contains the total cost of the requisition. |
|
||||||||||||
PJR-NBR-APPROVALS Element: Number of Approvals | Numeric 2 Contains the number of people who need to approve the requisition before applicants can be hired. |
|
||||||||||||
PJR-APPROVAL-DESC Element: Title Description | Alpha 30 (Lower Case) Occurs 10 Times Contains the title or name of the person who needs to approve the requisition. |
|
||||||||||||
PJR-APPROVAL-DATE Element: Date | Numeric 8 (yyyymmdd) Occurs 10 Times Contains the date the person approved the requisition. |
|
||||||||||||
PJR-APPROVAL-EMP Element: Approved By | Numeric 9 Occurs 10 Times Contains the number of the employee who approved the requisition. |
|
||||||||||||
PJR-INTERNAL-START Internal Posting Dates - Start | Numeric 8 (yyyymmdd) Contains the first date the requisition is posted in the company. |
|
||||||||||||
PJR-INTERNAL-STOP Internal Posting Dates - Stop | Numeric 8 (yyyymmdd) Contains the last date the requisition is posted in the company. |
|
||||||||||||
PJR-EXTERNAL-START External Posting Dates - Start | Numeric 8 (yyyymmdd) Contains the first date the requisition is posted outside the company. |
|
||||||||||||
PJR-EXTERNAL-STOP External Posting Dates - Stop | Numeric 8 (yyyymmdd) Contains the last date the requisition is posted outside the company. |
|
||||||||||||
PJR-CONTACT-NBR Element: Contact Employee | Numeric 9 Contains the number of the employee who should be contacted about the requisition. |
|
||||||||||||
PJR-CONTACT-LAST Element: Contact's Last Name | Alpha 30 (Lower Case) Contains the last name of the employee who should be contacted about the requisition. |
|
||||||||||||
PJR-CONTACT-FIRST Element: Contact's First Name | Alpha 15 (Lower Case) Contains the first name of the employee who should be contacted about the requisition. |
|
||||||||||||
PJR-CONTACT-MI Contact's Middle Initial | Alpha 1 Contains the middle initial of the employee who should be contacted about the requisition. |
|
||||||||||||
PJR-WK-PHONE-CNTRY Work Telephone Country | Alpha 6 Contains the prefix of the telephone number of the employee who should be contacted about the requisition. |
|
||||||||||||
PJR-WK-PHONE-NBR Element: Work Telephone | Alpha 15 Contains the telephone number of the employee who should be contacted about the requisition. |
|
||||||||||||
PJR-WK-PHONE-EXT Work Telephone Extension | Alpha 5 Contains the extension of the telephone number of the employee who should be contacted about the requisition. |
|
||||||||||||
PJR-SHORT-DESC1 Element: Short Description 1 | Alpha 30 (Lower Case) 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 Element: Short Description 2 | Alpha 30 (Lower Case) 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 Element: Short Description 3 | Alpha 30 (Lower Case) 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 Special Requirements 1 | Alpha 30 (Lower Case) Contains the first line of either (1) a description of the requirements of the job and position on the requisition, or (2) any other information you want. |
|
||||||||||||
PJR-SPEC-REQ2 Special Requirements 2 | Alpha 30 (Lower Case) Contains the second line of either (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 Special Requirements 3 | Alpha 30 (Lower Case) Contains the first line of either (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 Last Comment Sequence Number | Numeric 4 Contains the sequence number of the last comment. |
|
||||||||||||
PJR-OPEN-FTE Element: Open FTE | Signed 11.6 Contains the total FTE for all open requisitions for a job. |
|
||||||||||||
PJR-FILLED-FTE Element: Filled FTE | Signed 11.6 Contains the FTE for requisitions which have been filled for a job. |
|
||||||||||||
PJR-SHIFT Element: Shift | Numeric 1 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 Element: Effective Date | Numeric 8 (yyyymmdd) 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 Element: Pos Effect Dat | Numeric 8 (yyyymmdd) Contains the effective date for the position. |
|
||||||||||||
PJR-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) This field contains the server date (month, date, and year) of the last change to this record. |
|
||||||||||||
PJR-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||
PJR-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||||||||||
PJR-REMAINING-OPEN Element: Remaining Openins | Derived Contains the number of open requisitions remaining for a job. |
|
||||||||||||
PJR-REMAINING-FTE Element: Remaining FTE | Derived Contains the FTE remaining before total budgeted FTE for a job is met. |
|
||||||||||||
PJR-CURRENCY-CODE Element: Currency Code | Alpha 5 Contains the currency in which the salary is recorded. |
|
||||||||||||
PJR-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||
PJR-CURR-CODE-2 Element: Curr Code 2 | Alpha 5 Contains the currency in which requisition costs are recorded. |
|
||||||||||||
PJR-CURR-CODE-ND-2 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||
PJR-BASE-BEG-PAY Element: Salary | Signed 11.2 Contains the beginning pay in the company's base currency. |
|
||||||||||||
PJR-BASE-END-PAY Element: Salary | Signed 11.2 Contains the ending pay in the company's base currency. |
|
||||||||||||
PJR-BASE-CURRENCY Element: Base Currency | Alpha 5 Contains the company base currency. |
|
||||||||||||
PJR-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||||||||||||
PJR-BASE-AMOUNT Element: Base Amt | Signed 15.2 Contains the amount in the company's base currency. |
|
||||||||||||
PJR-APPROVAL-FLAG Element: Approval Flag | Alpha 1 " " = Yes N = No Y = Yes |
|
||||||||||||
PJR-WF-PEND-REQ Element: Wf Pend Req | Derived |
|
||||||||||||
PJR-LABEL-NAME Element: Label Name | Derived |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PJRSET1 |
COMPANY REQUISITION |
|
| ||||||||||||||||||||||||||||||||||||
PJRSET2 |
COMPANY POSITION REQUISITION |
|
| ||||||||||||||||||||||||||||||||||||
PJRSET3 |
COMPANY PROCESS-LEVEL DEPARTMENT JOB-CODE REQUISITION |
|
| ||||||||||||||||||||||||||||||||||||
PJRSET4 |
COMPANY JOB-CODE REQUISITION |
|
| ||||||||||||||||||||||||||||||||||||
PJRSET5 |
COMPANY SUPERVISOR REQUISITION |
|
|||||||||||||||||||||||||||||||||||||
PJRSET6 |
COMPANY REQUISITION* |
|
|||||||||||||||||||||||||||||||||||||
PJRSET7 |
COMPANY REQUEST-DATE* DATE-STAMP* REQUISITION |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
App Status | EMSTATUS |
Required
| |||||||||||||||
Approval Emp | EMPLOYEE |
Required
| |||||||||||||||
Bargain Unit | PCODES |
Required
| |||||||||||||||
Base Currency | CUCODES |
Required
| |||||||||||||||
Company | PRSYSTEM |
Required
| |||||||||||||||
Contact Nbr | EMPLOYEE |
Required
| |||||||||||||||
Currency | CUCODES |
Required
| |||||||||||||||
Currency2 | CUCODES |
Required
| |||||||||||||||
Department | DEPTCODE |
Required
| |||||||||||||||
Job Code | JOBCODE |
Required
| |||||||||||||||
Location | PCODES |
Required
| |||||||||||||||
Pos Date | PAPOSITION |
Required
| |||||||||||||||
Process Level | PRSYSTEM |
Required
| |||||||||||||||
Rep Employee | EMPLOYEE |
Required
| |||||||||||||||
Req Status | PCODES |
Required
| |||||||||||||||
Request By | EMPLOYEE |
Required
| |||||||||||||||
Supervisor | HRSUPER |
Required
| |||||||||||||||
Union Code | PCODES |
Required
| |||||||||||||||
User Level | PCODES |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Applicants | PAREQAPP |
Delete Cascades
| |||||||||||||||||||||||||||||||||
Comments | PACOMMENTS |
Delete Cascades
| |||||||||||||||||||||||||||||||||
Cost | PAREQCOST |
Delete Cascades
| |||||||||||||||||||||||||||||||||
Ext Applicants | PAREQAPP |
| |||||||||||||||||||||||||||||||||
Grade Step | PRSAGDTL |
| |||||||||||||||||||||||||||||||||
Int Applicants | PAREQAPP |
| |||||||||||||||||||||||||||||||||
Offers | PAREQOFFER |
Delete Cascades
| |||||||||||||||||||||||||||||||||
Pos Chg Error | PAPOSERR |
Delete Cascades
| |||||||||||||||||||||||||||||||||
Pos Rules | PAPOSRULE |
| |||||||||||||||||||||||||||||||||
Position | PAPOSITION |
Required
| |||||||||||||||||||||||||||||||||
Sched Grade | PRSAGDTL |
| |||||||||||||||||||||||||||||||||
Schedule | PRSAGHEAD |
| |||||||||||||||||||||||||||||||||
Work Schedule | HRWRKSCHD |
|
All trademarks and registered trademarks are the property of their
respective owners.