PAJOBREQ – Job Requisition

System
Personnel (PA)
Prefix
PJR
Primary key
COMPANY, REQUISITION
Fields
83
Updated by
18 programs
Referenced by
24 programs

PAJOBREQ is the Job Requisition table in Lawson Personnel (prefix PJR). It is indexed by COMPANY, REQUISITION (PJRSET1); alternate indexes: PJRSET2, PJRSET3, PJRSET4, PJRSET5, PJRSET6 and PJRSET7. It is related 1:1 to EMSTATUS, EMPLOYEE, PCODES, CUCODES, PRSYSTEM, DEPTCODE, JOBCODE, PAPOSITION and 1 more and 1:M to PAREQAPP, PACOMMENTS, PAREQCOST, PRSAGDTL, PAREQOFFER, PAPOSERR, PAPOSRULE, PAPOSITION and 2 more. It is updated by HR11.1, LT101, LT111, PA02.1, PA102, PA115, PA120, PA41.1 and 10 more and referenced by HPJR.1, HR170, HR70.1, PA03.2, PA100, PA111, PA211, PA231 and 16 more. The table has 83 fields, 7 indexes and 32 documented relations.

About PAJOBREQ

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

Fields (83)

Column = COBOL field name without the PJR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PJR-COMPANY PK
COMPANY		Numeric 4Contains the company number, which represents an established company.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-REQUISITION PK
REQUISITION		Numeric 9Contains the system-assigned number that represents the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the description of the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-POSITION SET2
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-JOB-CODE SET3 SET4
JOB_CODE		Alpha 9Contains the code that represents the new or open job.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-REQ-STATUS
REQ_STATUS		Alpha 10Contains the status of the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA45.1, PA502 +1 more
#PJR-OPENINGS
OPENINGS		Numeric 3Contains the number of open jobs or positions.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-REPLACEMENT
REPLACEMENT		Alpha 1Indicates whether the requisition is for a replacement of a current job and position.
  • Y Yes
  • N No
LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-REP-EMPLOYEE
REP_EMPLOYEE		Numeric 9Contains the number that represents the employee being replaced. This field is valid only when the Replacement field is Yes.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-BUDGETED-FLAG
BUDGETED_FLAG		Alpha 1Indicates whether the requisition is for a job and position that is budgeted.
  • Y Yes
  • N No
LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-REQUEST-DATE SET7
REQUEST_DATE		Numeric 8 (yyyymmdd)Contains the date the requisition is requested.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-REQUEST-BY
REQUEST_BY		Numeric 9Contains the number that represents the employee who requested the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-DATE-NEEDED
DATE_NEEDED		Numeric 8 (yyyymmdd)Contains the date on which the job should be filled.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-OPEN-DATE
OPEN_DATE		Numeric 8 (yyyymmdd)Contains the date the requisition is open.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-CLOSED-DATE
CLOSED_DATE		Numeric 8 (yyyymmdd)Contains the date the requisition was closed.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA45.1, PA502 +1 more
#PJR-APP-STATUS
APP_STATUS		Alpha 2Contains the employee status of the job and position on the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-TEMP-BEGIN
TEMP_BEGIN		Numeric 8 (yyyymmdd)Contains the date the temporary position begins.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-TEMP-END
TEMP_END		Numeric 8 (yyyymmdd)Contains the date the temporary position ends.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-SCHEDULE
SCHEDULE		Alpha 9Contains the step and grade schedule or the grade range schedule of the job on the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-PAY-GRADE
PAY_GRADE		Alpha 3Contains the grade of the job on the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-PAY-STEP
PAY_STEP		Numeric 2Contains the step of the job on the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-SALARY-CLASS
SALARY_CLASS		Alpha 1Contains the salary class of the job on the requisition.
  • H Hourly
  • S Salaried
LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-BEG-PAY-RATE
BEG_PAY_RATE		Signed 13.4Contains the minimum pay rate an employee receives in the job.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-END-PAY-RATE
END_PAY_RATE		Signed 13.4Contains the maximum pay rate an employee receives in the job.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-EXEMPT-EMP
EXEMPT_EMP		Alpha 1Indicates whether an employee is exempt from overtime pay when the requisition's job or position.
  • Y Yes
  • N No
LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-WORK-SCHED
WORK_SCHED		Alpha 10Contains the work schedule of the job. The work schedule must be valid in the Human Resource Code file.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-PROCESS-LEVEL SET3
PROCESS_LEVEL		Alpha 5Contains the process level in which the job and position are needed.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-DEPARTMENT SET3
DEPARTMENT		Alpha 5Contains the department in which the job and position are needed.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-USER-LEVEL
USER_LEVEL		Alpha 10Contains the user level in which the job and position are needed.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-LOCAT-CODE
LOCAT_CODE		Alpha 10Contains the location at which the job and position are needed.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-UNION-CODE
UNION_CODE		Alpha 10—LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-BARGAIN-UNIT
BARGAIN_UNIT		Alpha 10—LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-SUPERVISOR SET5
SUPERVISOR		Alpha 10Contains the employee who supervises the position.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-TOTAL-APPLIED
TOTAL_APPLIED		Numeric 3Contains the total number of applicants who applied for the requisition.PA115, PA120, PA43.1, PA43.2
#PJR-INTERVIEWS
INTERVIEWS		Numeric 3Contains the total number of interviews for the requisition.PA115, PA120, PA41.1
#PJR-OFFERS-EXTEND
OFFERS_EXTEND		Numeric 3Contains the number of times an offer was extended for the requisition.PA115, PA120, PA45.1
#PJR-OFFERS-ACCEPT
OFFERS_ACCEPT		Numeric 3Contains the number of times an offer was accepted for the requisition.LT101, LT111, PA02.1, PA102, PA115, PA120, PA42.1, PA42.3 +3 more
#PJR-OFFERS-DECLINE
OFFERS_DECLINE		Numeric 3Contains the number of times an offer was declined for the requisition.PA115, PA120, PA45.1
#PJR-TOT-COST
TOT_COST		Signed 11.2Contains the total cost of the requisition.PA115, PA120, PA44.1
#PJR-NBR-APPROVALS
NBR_APPROVALS		Numeric 2Contains the number of people who need to approve the requisition before applicants can be hired.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-APPROVAL-DESC
APPROVAL_DESC		Alpha 30 (Lower Case)Occurs 10 Times Contains the title or name of the person who needs to approve the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-APPROVAL-DATE
APPROVAL_DATE		Numeric 8 (yyyymmdd) Occurs 10 Times ×10Contains the date the person approved the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-APPROVAL-EMP
APPROVAL_EMP		Numeric 9 Occurs 10 Times ×10Contains the number of the employee who approved the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-INTERNAL-START
INTERNAL_START		Numeric 8 (yyyymmdd)Contains the first date the requisition is posted in the company.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-INTERNAL-STOP
INTERNAL_STOP		Numeric 8 (yyyymmdd)Contains the last date the requisition is posted in the company.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-EXTERNAL-START
EXTERNAL_START		Numeric 8 (yyyymmdd)Contains the first date the requisition is posted outside the company.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-EXTERNAL-STOP
EXTERNAL_STOP		Numeric 8 (yyyymmdd)Contains the last date the requisition is posted outside the company.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-CONTACT-NBR
CONTACT_NBR		Numeric 9Contains the number of the employee who should be contacted about the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-CONTACT-LAST
CONTACT_LAST		Alpha 30 (Lower Case)Contains the last name of the employee who should be contacted about the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-CONTACT-FIRST
CONTACT_FIRST		Alpha 15 (Lower Case)Contains the first name of the employee who should be contacted about the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-CONTACT-MI
CONTACT_MI		Alpha 1Contains the middle initial of the employee who should be contacted about the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-WK-PHONE-CNTRY
WK_PHONE_CNTRY		Alpha 6Contains the prefix of the telephone number of the employee who should be contacted about the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-WK-PHONE-NBR
WK_PHONE_NBR		Alpha 15Contains the telephone number of the employee who should be contacted about the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-WK-PHONE-EXT
WK_PHONE_EXT		Alpha 5Contains the extension of the telephone number of the employee who should be contacted about the requisition.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-SHORT-DESC1
SHORT_DESC1		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, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-SHORT-DESC2
SHORT_DESC2		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, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-SHORT-DESC3
SHORT_DESC3		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, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-SPEC-REQ1
SPEC_REQ1		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, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-SPEC-REQ2
SPEC_REQ2		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, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-SPEC-REQ3
SPEC_REQ3		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, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-LAST-CMT-SEQ
LAST_CMT_SEQ		Numeric 4Contains the sequence number of the last comment.PA46.1
#PJR-OPEN-FTE
OPEN_FTE		Signed 11.6Contains the total FTE for all open requisitions for a job.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-FILLED-FTE
FILLED_FTE		Signed 11.6Contains the FTE for requisitions which have been filled for a job.HR11.1, LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA45.1 +2 more
#PJR-SHIFT
SHIFT		Numeric 1Contains 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, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-EFFECT-DATE
EFFECT_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, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-POS-EFFECT-DAT
POS_EFFECT_DAT		Numeric 8 (yyyymmdd)Contains the effective date for the position.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-DATE-STAMP SET7
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA45.1, PA502 +1 more
#PJR-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA45.1, PA502 +1 more
#PJR-USER-ID
USER_ID		Alpha 10 (Lower Case)—LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA45.1, PA502 +1 more
#PJR-REMAINING-OPEN
REMAINING_OPEN		DerivedContains the number of open requisitions remaining for a job.—
#PJR-REMAINING-FTE
REMAINING_FTE		DerivedContains the FTE remaining before total budgeted FTE for a job is met.—
#PJR-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which the salary is recorded.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-CURR-CODE-2
CURR_CODE_2		Alpha 5Contains the currency in which requisition costs are recorded.PA44.1
#PJR-CURR-CODE-ND-2
CURR_CODE_ND_2		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PA44.1
#PJR-BASE-BEG-PAY
BASE_BEG_PAY		Signed 11.2Contains the beginning pay in the company's base currency.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-BASE-END-PAY
BASE_END_PAY		Signed 11.2Contains the ending pay in the company's base currency.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the company base currency.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA44.1, PA502 +1 more
#PJR-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA44.1, PA502 +1 more
#PJR-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2Contains the amount in the company's base currency.PA44.1
#PJR-APPROVAL-FLAG
APPROVAL_FLAG		Alpha 1" " = Yes
  • N No
  • Y Yes
LT101, LT111, PA02.1, PA102, PA42.1, PA42.3, PA502, PA535
#PJR-WF-PEND-REQ
WF_PEND_REQ		Derived——
#PJR-LABEL-NAME
LABEL_NAME		Derived——

Indexes (7)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PJRSET1
  1. COMPANY
  2. REQUISITION
PrimaryHPJR.1, HR11.1, HR170, HR70.1, LT101, LT111, PA02.1, PA03.2 +22 more (list truncated in source)
PJRSET2
  1. COMPANY
  2. POSITION
  3. REQUISITION
KeyChange, SubsetWhere (POSITION != Spaces)LT101, LT111, PA02.1, PA102, PA211, PA272, PA302, PA402 +5 more
PJRSET3
  1. COMPANY
  2. PROCESS-LEVEL
  3. DEPARTMENT
  4. JOB-CODE
  5. REQUISITION
KeyChange, SubsetWhere (POSITION = Spaces)PA211, PA272
PJRSET4
  1. COMPANY
  2. JOB-CODE
  3. REQUISITION
KeyChangePA64.1, PA65.1
PJRSET5
  1. COMPANY
  2. SUPERVISOR
  3. REQUISITION
KeyChange, SubsetWhere SUPERVISOR != Spaces—
PJRSET6
  1. COMPANY
  2. REQUISITION ↓
—
PJRSET7
  1. COMPANY
  2. REQUEST-DATE ↓
  3. DATE-STAMP ↓
  4. REQUISITION
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EMSTATUSEMPLOYEEPCODESCUCODESPRSYSTEMDEPTCODEJOBCODEPAPOSITIONHRSUPERPAREQAPPPACOMMENTSPAREQCOSTPRSAGDTLPAREQOFFERPAPOSERRPAPOSRULEPAPOSITIONPRSAGHEADHRWRKSCHDPAJOBREQ

One to one (19) — lookups and parents

RelationTableRulesConditionField map
App StatusEMSTATUSRequiredWhen PJR-APP-STATUS != Spaces
PJR-COMPANY→EMS-COMPANY
PJR-APP-STATUS→EMS-EMP-STATUS
Approval EmpEMPLOYEERequiredWhen PJR-APPROVAL-EMP != Zeroes
PJR-COMPANY→EMP-COMPANY
PJR-APPROVAL-EMP→EMP-EMPLOYEE
Bargain UnitPCODESRequiredWhen PJR-BARGAIN-UNIT != Spaces
"BU"→PCO-TYPE
PJR-BARGAIN-UNIT→PCO-CODE
Base CurrencyCUCODESRequiredWhen PJR-CURRENCY-CODE != Spaces Or PJR-CURR-CODE-2 != Spaces
PJR-CURRENCY-CODE→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
PJR-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Contact NbrEMPLOYEERequiredWhen PJR-CONTACT-NBR != Zeroes
PJR-COMPANY→EMP-COMPANY
PJR-CONTACT-NBR→EMP-EMPLOYEE
CurrencyCUCODESRequiredWhen (PJR-CURRENCY-CODE != Spaces)
PJR-CURRENCY-CODE→CUC-CURRENCY-CODE
Currency2CUCODESRequiredWhen (PJR-CURR-CODE-2 != Spaces)
PJR-CURR-CODE-2→CUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen PJR-DEPARTMENT != Spaces
PJR-COMPANY→DPT-COMPANY
PJR-PROCESS-LEVEL→DPT-PROCESS-LEVEL
PJR-DEPARTMENT→DPT-DEPARTMENT
Job CodeJOBCODERequiredWhen PJR-JOB-CODE != Spaces
PJR-COMPANY→JBC-COMPANY
PJR-JOB-CODE→JBC-JOB-CODE
LocationPCODESRequiredWhen PJR-LOCAT-CODE != Spaces
"LO"→PCO-TYPE
PJR-LOCAT-CODE→PCO-CODE
Pos DatePAPOSITIONRequiredWhen (PJR-POSITION != Spaces)
PJR-COMPANY→POS-COMPANY
PJR-POSITION→POS-POSITION
PJR-POS-EFFECT-DAT→POS-EFFECT-DATE
Process LevelPRSYSTEMRequiredWhen PJR-PROCESS-LEVEL != Spaces
PJR-COMPANY→PRS-COMPANY
PJR-PROCESS-LEVEL→PRS-PROCESS-LEVEL
Rep EmployeeEMPLOYEERequiredWhen PJR-REP-EMPLOYEE != Zeroes
PJR-COMPANY→EMP-COMPANY
PJR-REP-EMPLOYEE→EMP-EMPLOYEE
Req StatusPCODESRequiredWhen PJR-REQ-STATUS != Spaces
"RQ"→PCO-TYPE
PJR-REQ-STATUS→PCO-CODE
Request ByEMPLOYEERequiredWhen PJR-REQUEST-BY != Zeroes
PJR-COMPANY→EMP-COMPANY
PJR-REQUEST-BY→EMP-EMPLOYEE
SupervisorHRSUPERRequiredWhen PJR-SUPERVISOR != Spaces
PJR-COMPANY→HSU-COMPANY
PJR-SUPERVISOR→HSU-CODE
Union CodePCODESRequiredWhen PJR-UNION-CODE != Spaces
"UN"→PCO-TYPE
PJR-UNION-CODE→PCO-CODE
User LevelPCODESNot RequiredValid When PJR-USER-LEVEL != Spaces
"UL"→PCO-TYPE
PJR-USER-LEVEL→PCO-CODE

One to many (13) — child tables

RelationTableRulesConditionField map
ApplicantsPAREQAPPDelete Cascades
PJR-COMPANY→PRA-COMPANY
PJR-REQUISITION→PRA-REQUISITION
—→PRA-EMP-APP
—→PRA-APPLICANT
CommentsPACOMMENTSDelete 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
—→PAC-DATE
CostPAREQCOSTDelete Cascades
PJR-COMPANY→PRC-COMPANY
PJR-REQUISITION→PRC-REQUISITION
—→PRC-DATE
—→PRC-REASON
—→PRC-EMP-APP
—→PRC-APPLICANT
Ext ApplicantsPAREQAPP
PJR-COMPANY→PRA-COMPANY
PJR-REQUISITION→PRA-REQUISITION
1→PRA-EMP-APP
—→PRA-APPLICANT
Grade StepPRSAGDTLValid 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 ApplicantsPAREQAPP
PJR-COMPANY→PRA-COMPANY
PJR-REQUISITION→PRA-REQUISITION
Zeroes→PRA-EMP-APP
—→PRA-APPLICANT
OffersPAREQOFFERDelete Cascades
PJR-COMPANY→PRF-COMPANY
PJR-REQUISITION→PRF-REQUISITION
—→PRF-EMP-APP
—→PRF-APPLICANT
—→PRF-DATE
—→PRF-OFFER-TYPE
Pos Chg ErrorPAPOSERRDelete CascadesValid 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 RulesPAPOSRULE
PJR-COMPANY→PPR-COMPANY
PJR-PROCESS-LEVEL→PPR-PROCESS-LEVEL
PJR-DEPARTMENT→PPR-DEPARTMENT
—→PPR-EFFECT-DATE
PositionPAPOSITIONRequiredWhen (PJR-POSITION != Spaces)
PJR-COMPANY→POS-COMPANY
PJR-POSITION→POS-POSITION
—→POS-EFFECT-DATE
Sched GradePRSAGDTLValid 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
SchedulePRSAGHEADValid When (PJR-SCHEDULE != Spaces) And (PJR-PAY-STEP = Zeroes)
PJR-COMPANY→SGH-COMPANY
"G"→SGH-INDICATOR
PJR-SCHEDULE→SGH-SCHEDULE
—→SGH-EFFECT-DATE
Work ScheduleHRWRKSCHDValid When PJR-WORK-SCHED != Spaces
PJR-COMPANY→WSC-COMPANY
PJR-WORK-SCHED→WSC-WORK-SCHED
—→WSC-CONTRACT-YEAR
—→WSC-EFFECT-DATE

Programs

Updated by (18)

Referenced by (24)