HRS_JOB_LOC_LN2

(SQL View)
Index Back

Job Opening Location

Location of Job Opening

SELECT A.HRS_JOB_OPENING_ID , E.language_cd , A.HRS_PRM_LOC_AREA , E.DESCR FROM PS_HRS_JOB_OPENING A , PS_SET_CNTRL_GROUP D , PS_HRS_LOC_lng E WHERE A.BUSINESS_UNIT = %Substring(D.SETCNTRLVALUE,1,5) AND D.REC_GROUP_ID = 'RS_LOC' AND D.SETID = E.SETID AND A.HRS_PRM_LOC_AREA = E.HRS_LOCATION_ID

  • Related Language Record for HRS_JOB_LOC_VW2
  • # 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 HRS_PRM_LOC_AREA Number(15,0) DECIMAL(15) NOT NULL Primary recruiting location area
    4 HRS_RECR_LOCATION Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location