HRS_JO_RLOC_LVW

(SQL View)
 Index Back

RS JO Recruting Locations

This view lists all the recruting locations based on user's Job Opening security.

SELECT DISTINCT OPR.OPRID , RLOC.HRS_LOCATION_ID , LOC.LANGUAGE_CD , LOC.DESCR FROM PS_HRS_JOB_OPENING J , PSOPRDEFN OPR , PS_HRS_SJT_JO JO , PS_HRS_JO_LOC_AREA RLOC , PS_HRS_LOC_LNG LOC , PS_SET_CNTRL_REC SETCNTRL WHERE J.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND J.HRS_JOB_OPENING_ID = RLOC.HRS_JOB_OPENING_ID AND SETCNTRL.SETCNTRLVALUE = J.BUSINESS_UNIT AND SETCNTRL.RECNAME = 'HRS_LOCATION' AND SETCNTRL.SETID = LOC.SETID AND RLOC.HRS_LOCATION_ID = LOC.HRS_LOCATION_ID AND JO.EMPLID = OPR.EMPLID AND JO.EMPLID <> ' ' UNION SELECT DISTINCT OPR.OPRID , RLOC.HRS_LOCATION_ID , LOC.LANGUAGE_CD , LOC.DESCR FROM PS_HRS_JOB_OPENING J , PSOPRDEFN OPR , PS_HRS_SJT_JO JO , PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS RSC , PS_HRS_JO_LOC_AREA RLOC , PS_HRS_LOC_LNG LOC , PS_SET_CNTRL_REC SETCNTRL WHERE J.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND J.HRS_JOB_OPENING_ID = RLOC.HRS_JOB_OPENING_ID AND SETCNTRL.SETCNTRLVALUE = J.BUSINESS_UNIT AND SETCNTRL.RECNAME = 'HRS_LOCATION' AND SETCNTRL.SETID = LOC.SETID AND RLOC.HRS_LOCATION_ID = LOC.HRS_LOCATION_ID AND RSC.CLASSID = CLS.CLASSID AND RSC.OPRID = OPR.OPRID AND ((CLS.SCRTY_SET_CD = 'RSOPN' AND CLS.SCRTY_TYPE_CD = JO.SCRTY_TYPE_CD) OR (CLS.SCRTY_SET_CD = 'PPLJOB' AND CLS.SCRTY_TYPE_CD = '001' AND JO.SCRTY_TYPE_CD = '012')) AND CLS.SCRTY_KEY1 = JO.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = JO.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = JO.SCRTY_KEY3 AND JO.EMPLID = ' '

  • Related Language Record for HRS_JO_RLOC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 HRS_LOCATION_ID Number(15,0) DECIMAL(15) NOT NULL Recruiting location area
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description