PAJOBREQ

Job Requisition

The Job Requisition file contains information about job or position requisitions.

REFERENCED BY
HR170 HR70.1 PA03.2 PA100 PA231 PA241
PA244 PA52.4 ZE531 WAOP.1 HPJR.1 SNEM.1


UPDATED BY
HR11.1 LT101 PA02.1 PA102 PA111 PA115
PA120 PA211 PA242 PA243 PA272 PA302
PA402 PA406 PA41.1 PA42.1 PA42.3 PA43.1
PA43.2 PA44.1 PA45.1 PA46.1 PA502 PA531
PA532 PA535 PA64.1 PA64.2 PA65.1 PA65.2
ZE532 WA01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PJR-COMPANY
Element: Company		Numeric 4
Contains the company number, which represents an established company.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-REQUISITION
Element: Requisition		Numeric 9
Contains the system-assigned number that represents the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535 ZE531
PJR-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Contains the description of the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-JOB-CODE
Element: Job Code		Alpha 9
Contains the code that represents the new or open job.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-REQ-STATUS
Element: Requisition Status		Alpha 10
Contains the status of the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA45.1
PA502 PA535
PJR-OPENINGS
Element: Openings		Numeric 3
Contains the number of open jobs or positions.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-REPLACEMENT
Element: Replacement		Alpha 1
Indicates whether the requisition is for a replacement of a current job and position.
Y = Yes
N = No
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-BUDGETED-FLAG
Element: Budgeted		Alpha 1
Indicates whether the requisition is for a job and position that is budgeted.
Y = Yes
N = No
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-REQUEST-DATE
Element: Requested		Numeric 8 (yyyymmdd)
Contains the date the requisition is requested.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-REQUEST-BY
Element: Requested By		Numeric 9
Contains the number that represents the employee who requested the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-DATE-NEEDED
Element: Needed		Numeric 8 (yyyymmdd)
Contains the date on which the job should be filled.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-OPEN-DATE
Element: Open		Numeric 8 (yyyymmdd)
Contains the date the requisition is open.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-CLOSED-DATE
Element: Closed		Numeric 8 (yyyymmdd)
Contains the date the requisition was closed.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA45.1
PA502 PA535
PJR-APP-STATUS
Element: Employee Status		Alpha 2
Contains the employee status of the job and position on the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-TEMP-BEGIN
Element: Temporary Begin Date		Numeric 8 (yyyymmdd)
Contains the date the temporary position begins.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-TEMP-END
Element: Temporary End Date		Numeric 8 (yyyymmdd)
Contains the date the temporary position ends.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-SCHEDULE
Element: Schedule		Alpha 9
Contains the step and grade schedule or the grade range schedule of the job on the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-PAY-GRADE
Element: Grade		Alpha 3
Contains the grade of the job on the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-PAY-STEP
Element: Step		Numeric 2
Contains the step of the job on the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-SALARY-CLASS
Element: Salary Class		Alpha 1
Contains the salary class of the job on the requisition.
H = Hourly
S = Salaried
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-BEG-PAY-RATE
Element: Beginning Pay Rate		Signed 13.4
Contains the minimum pay rate an employee receives in the job.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-END-PAY-RATE
Element: Ending Pay Rate		Signed 13.4
Contains the maximum pay rate an employee receives in the job.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-PROCESS-LEVEL
Element: Process Level		Alpha 5
Contains the process level in which the job and position are needed.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-DEPARTMENT
Element: Department		Alpha 5
Contains the department in which the job and position are needed.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-USER-LEVEL
Element: User Level		Alpha 10
Contains the user level in which the job and position are needed.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-LOCAT-CODE
Element: Location		Alpha 10
Contains the location at which the job and position are needed.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-UNION-CODE
Element: Union Code		Alpha 10
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-BARGAIN-UNIT
Element: Bargain Unit		Alpha 10
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-SUPERVISOR
Element: Supervisor		Alpha 10
Contains the employee who supervises the position.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-TOTAL-APPLIED
Element: Total Applicants		Numeric 3
Contains the total number of applicants who applied for the requisition.
PA115 PA120
PA43.1 PA43.2
PJR-INTERVIEWS
Element: Interviews		Numeric 3
Contains the total number of interviews for the requisition.
PA115 PA120
PA41.1
PJR-OFFERS-EXTEND
Element: Offers Extended		Numeric 3
Contains the number of times an offer was extended for the requisition.
PA115 PA120
PA45.1
PJR-OFFERS-ACCEPT
Element: Offers Accepted		Numeric 3
Contains the number of times an offer was accepted for the requisition.
LT101 PA02.1
PA102 PA115
PA120 PA42.1
PA42.3 PA45.1
PA502 PA535
PJR-OFFERS-DECLINE
Element: Offers Declined		Numeric 3
Contains the number of times an offer was declined for the requisition.
PA115 PA120
PA45.1
PJR-TOT-COST
Element: Total Cost		Signed 11.2
Contains the total cost of the requisition.
PA115 PA120
PA44.1
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-APPROVAL-DATE
Element: Date		Numeric 8 (yyyymmdd) Occurs 10 Times
Contains the date the person approved the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-APPROVAL-EMP
Element: Approved By		Numeric 9 Occurs 10 Times
Contains the number of the employee who approved the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-INTERNAL-START
Internal Posting
Dates - Start		Numeric 8 (yyyymmdd)
Contains the first date the requisition is posted in the company.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-INTERNAL-STOP
Internal Posting
Dates - Stop		Numeric 8 (yyyymmdd)
Contains the last date the requisition is posted in the company.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-EXTERNAL-START
External Posting
Dates - Start		Numeric 8 (yyyymmdd)
Contains the first date the requisition is posted outside the company.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-EXTERNAL-STOP
External Posting
Dates - Stop		Numeric 8 (yyyymmdd)
Contains the last date the requisition is posted outside the company.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-CONTACT-NBR
Element: Contact Employee		Numeric 9
Contains the number of the employee who should be contacted about the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-CONTACT-MI
Contact's Middle
Initial		Alpha 1
Contains the middle initial of the employee who should be contacted about the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-WK-PHONE-NBR
Element: Work Telephone		Alpha 15
Contains the telephone number of the employee who should be contacted about the requisition.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535 ZE531
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-LAST-CMT-SEQ
Last Comment
Sequence Number		Numeric 4
Contains the sequence number of the last comment.
PA46.1
PJR-OPEN-FTE
Element: Open FTE		Signed 11.6
Contains the total FTE for all open requisitions for a job.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-FILLED-FTE
Element: Filled FTE		Signed 11.6
Contains the FTE for requisitions which have been filled for a job.
HR11.1 LT101
PA02.1 PA102
PA42.1 PA42.3
PA45.1 PA502
PA535
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
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535 ZE531
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-POS-EFFECT-DAT
Element: Pos Effect Dat		Numeric 8 (yyyymmdd)
Contains the effective date for the position.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA45.1
PA502 PA535
PJR-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA45.1
PA502 PA535
PJR-USER-ID
Element: User		Alpha 10 (Lower Case)
LT101 PA02.1
PA102 PA42.1
PA42.3 PA45.1
PA502 PA535
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.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-CURR-CODE-2
Element: Curr Code 2		Alpha 5
Contains the currency in which requisition costs are recorded.
PA44.1
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.
PA44.1
PJR-BASE-BEG-PAY
Element: Salary		Signed 11.2
Contains the beginning pay in the company's base currency.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-BASE-END-PAY
Element: Salary		Signed 11.2
Contains the ending pay in the company's base currency.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-BASE-CURRENCY
Element: Base Currency		Alpha 5
Contains the company base currency.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA44.1
PA502 PA535
PJR-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
LT101 PA02.1
PA102 PA42.1
PA42.3 PA44.1
PA502 PA535
PJR-BASE-AMOUNT
Element: Base Amt		Signed 15.2
Contains the amount in the company's base currency.
PA44.1
PJR-APPROVAL-FLAG
Element: Approval Flag		Alpha 1

" " = Yes
N = No
Y = Yes
LT101 PA02.1
PA102 PA42.1
PA42.3 PA502
PA535
PJR-WF-PEND-REQ
Element: Wf Pend Req		Derived
PJR-LABEL-NAME
Element: Label Name		Derived


PAJOBREQ FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PJRSET1 COMPANY
REQUISITION
...
HPJR.1 HR11.1
HR170 HR70.1
LT101 PA02.1
PA03.2 PA100
PA102 PA111
PA115 PA120
PA231 PA241
PA242 PA243
PA244 PA406
PA41.1 PA42.1
PA42.3 PA43.1
PA43.2 PA44.1
PA45.1 PA46.1
PA502 PA52.4
PA531 PA532
PJRSET2 COMPANY
POSITION
REQUISITION
KeyChange, Subset
Where(POSITION !=Spaces)
LT101 PA02.1
PA102 PA211
PA272 PA302
PA402 PA406
PA502 PA64.2
PA65.2 SNEM.1
PJRSET3 COMPANY
PROCESS-LEVEL
DEPARTMENT
JOB-CODE
REQUISITION
KeyChange, Subset
Where(POSITION =Spaces)
PA211 PA272
PJRSET4 COMPANY
JOB-CODE
REQUISITION
KeyChange
PA64.1 PA65.1
PJRSET5 COMPANY
SUPERVISOR
REQUISITION
KeyChange, Subset
WhereSUPERVISOR !=Spaces
PJRSET6 COMPANY
REQUISITION*


PAJOBREQ FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
Bargain Unit PCODES Required
When PJR-BARGAIN-UNIT !=Spaces
"BU"->PCO-TYPE
PJR-BARGAIN-UNIT->PCO-CODE
Base Currency CUCODES Required
When PJR-CURRENCY-CODE !=Spaces
OrPJR-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
Union Code PCODES Required
When PJR-UNION-CODE !=Spaces
"UN"->PCO-TYPE
PJR-UNION-CODE->PCO-CODE
User Level PCODES Not Required
Valid When PJR-USER-LEVEL !=Spaces
"UL"->PCO-TYPE
PJR-USER-LEVEL->PCO-CODE


PAJOBREQ FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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
Zeroes->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
Grade Step PRSAGDTL
Valid When (PJR-SCHEDULE !=Spaces )
And(PJR-PAY-GRADE !=Spaces )
And(PJR-PAY-STEP !=Zeroes )
PJR-COMPANY->SGD-COMPANY
PJR-SCHEDULE->SGD-SCHEDULE
PJR-PAY-GRADE->SGD-PAY-GRADE
PJR-PAY-STEP->SGD-PAY-STEP
  SGD-EFFECT-DATE
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
Sched Grade PRSAGDTL
Valid When (PJR-SCHEDULE !=Spaces )
And(PJR-PAY-GRADE !=Spaces )
And(PJR-PAY-STEP =Zeroes )
PJR-COMPANY->SGD-COMPANY
PJR-SCHEDULE->SGD-SCHEDULE
PJR-PAY-GRADE->SGD-PAY-GRADE
  SGD-PAY-STEP
  SGD-EFFECT-DATE
Schedule PRSAGHEAD
Valid When (PJR-SCHEDULE !=Spaces )
And(PJR-PAY-STEP =Zeroes )
PJR-COMPANY->SGH-COMPANY
"G"->SGH-INDICATOR
PJR-SCHEDULE->SGH-SCHEDULE
  SGH-EFFECT-DATE
Work Schedule HRWRKSCHD
Valid When PJR-WORK-SCHED !=Spaces
PJR-COMPANY->WSC-COMPANY
PJR-WORK-SCHED->WSC-WORK-SCHED
  WSC-CONTRACT-YEAR
  WSC-EFFECT-DATE

File created: Thu Jun 09 11:22:16 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.