HRS_JOB_LOC_LV1

(SQL View)
 Index Back

Job Opening Location Rel Lang

Related language location of Job Opening

SELECT A.HRS_JOB_OPENING_ID , B.LANGUAGE_CD , C.DESCR , E.HRS_RECR_LOCATION FROM PS_HRS_JOB_OPENING A LEFT OUTER JOIN PS_HRS_LOCATION_L4 C ON (A.HRS_PRM_LOCATION = C.LOCATION AND A.BUSINESS_UNIT = %Substring(C.SETCNTRLVALUE,1,5)) LEFT OUTER JOIN PS_HRS_JOB_LOC_LN2 E ON (A.HRS_JOB_OPENING_ID = E.HRS_JOB_OPENING_ID) , PS_HRS_JO_LNG B WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND (C.LANGUAGE_CD IS NULL OR C.LANGUAGE_CD = B.LANGUAGE_CD) AND (E.LANGUAGE_CD IS NULL OR E.LANGUAGE_CD = B.LANGUAGE_CD)

  • Related Language Record for HRS_JOB_LOC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location
    4 HRS_RECR_LOCATION Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location