HRS_JOB_LOC_LV

(SQL View)
 Index Back

Job Opening Location Rel Lang

Related language location of Job Opening

SELECT A.HRS_JOB_OPENING_ID , AL.LANGUAGE_CD , C.DESCR , E.DESCR FROM PS_HRS_JOB_OPENING A , PS_HRS_JO_LNG AL , PS_SET_CNTRL_GROUP B , PS_HRS_LOCATN_LNI C , PS_SET_CNTRL_GROUP D , PS_HRS_LOC_LNG E WHERE A.HRS_JOB_OPENING_ID = AL.HRS_JOB_OPENING_ID AND A.BUSINESS_UNIT = %Substring(B.SETCNTRLVALUE,1,5) AND B.REC_GROUP_ID = 'HR_03' AND B.SETID = C.SETID AND A.HRS_PRM_LOCATION = C.LOCATION AND C.EFFDT = ( SELECT MAX(C_I.EFFDT) FROM PS_HRS_LOCATN_LNI C_I WHERE C.SETID = C_I.SETID AND C.LOCATION = C_I.LOCATION AND C_I.EFFDT <= %CurrentDateIn AND C.LANGUAGE_CD = C_I.LANGUAGE_CD) AND AL.LANGUAGE_CD = C.LANGUAGE_CD AND 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 AND AL.LANGUAGE_CD = E.LANGUAGE_CD

# 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