HRS_JO_LOC_ARLV

(SQL View)
Index Back

Job Opening Location Rel Lang

Job opening recruiting location related language

SELECT A.HRS_JOB_OPENING_ID , A.HRS_LOCATION_ID , D.LANGUAGE_CD , D.DESCR FROM PS_HRS_JO_LOC_AREA A , PS_HRS_JO_I B , PS_SET_CNTRL_REC C , PS_HRS_LOC_LNG D WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND C.RECNAME = 'HRS_LOC_AREA_I' AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND A.HRS_LOCATION_ID = D.HRS_LOCATION_ID AND C.SETID = D.SETID

  • Related Language Record for HRS_JO_LOC_AR_V
  • # 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

    Prompt Table: HRS_JO_I

    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 HRS_RECR_LOCATION Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location