HRS_RCM_JOBS_LV

(SQL View)
 Index Back

Job Openings

Related language all job openings

SELECT A1.HRS_PERSON_ID , A1.HRS_RCMNT_ID , A.HRS_JOB_OPENING_ID , A.LANGUAGE_CD , CASE WHEN JL.HRS_PRM_PST_TITLE IS NULL THEN A.HRS_PRM_PST_TITLE ELSE JL.HRS_PRM_PST_TITLE END , COALESCE(( SELECT NML.NAME_DISPLAY FROM PS_HRS_PERSON_NM_L NML ,PS_HRS_JOB_OPENING JO WHERE NML.EMPLID = JO.MANAGER_ID AND NML.LANGUAGE_CD = A.LANGUAGE_CD AND JO.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID),( SELECT NM.NAME_DISPLAY FROM PS_HRS_PERSON_NM_I NM ,PS_HRS_JOB_OPENING JO WHERE NM.EMPLID = JO.MANAGER_ID AND JO.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID)) ,COALESCE(( SELECT NML.NAME_DISPLAY FROM PS_HRS_PERSON_NM_L NML ,PS_HRS_JOB_OPENING JO WHERE NML.EMPLID = JO.RECRUITER_ID AND NML.LANGUAGE_CD = A.LANGUAGE_CD AND JO.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID),( SELECT NM.NAME_DISPLAY FROM PS_HRS_PERSON_NM_I NM ,PS_HRS_JOB_OPENING JO WHERE NM.EMPLID = JO.RECRUITER_ID AND JO.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID)), CASE WHEN SL.DESCR IS NULL THEN B.DESCR ELSE SL.DESCR END , CASE WHEN BL.DESCR IS NULL THEN C.DESCR ELSE BL.DESCR END FROM PS_HRS_RCMN_IDX_VW A1 LEFT OUTER JOIN PS_HRS_ALL_JOBS_L1 A ON A1.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID LEFT OUTER JOIN PS_HRS_JO_LNG JL ON (A.HRS_JOB_OPENING_ID = JL.HRS_JOB_OPENING_ID AND A.LANGUAGE_CD = JL.LANGUAGE_CD) LEFT OUTER JOIN PS_HRS_STS_JO_LVW SL ON (SL.STATUS_AREA = '1' AND A.STATUS_CODE = SL.STATUS_CODE AND A.LANGUAGE_CD = SL.LANGUAGE_CD) LEFT OUTER JOIN PS_HRS_B_UN_HR_LNI BL ON (A.BUSINESS_UNIT = BL.BUSINESS_UNIT) , PS_HRS_STS_JO_I B , PS_HRS_BS_UNT_HR_J C WHERE B.STATUS_AREA = '1' AND A.STATUS_CODE = B.STATUS_CODE AND A.BUSINESS_UNIT = C.BUSINESS_UNIT

  • Related Language Record for HRS_JO_INFO_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 HRS_PRM_PST_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    6 HRS_HIRING_MGR Character(50) VARCHAR2(50) NOT NULL Hiring manager
    7 HRS_RECRUITER Character(50) VARCHAR2(50) NOT NULL Recruiter
    8 HRS_STATUS Character(30) VARCHAR2(30) NOT NULL Status
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description