HRS_JO_SEC_L_I1

(SQL View)
 Index Back

Job Opening w/Sec Rel Lang Int

Related language record for HRS_PE_QKSRCH_I and HRS_PE_JOHM_I

SELECT A.HRS_JOB_OPENING_ID , B.OPRID , A.LANGUAGE_CD , A.HRS_PRM_PST_TITLE , NM.NAME_DISPLAY FROM PS_HRS_JO_LNG A ,PS_HRS_JO_SEC_VW B ,PS_HRS_JOB_OPENING JO ,PS_HRS_PERSON_NM_L NM WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND B.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND NM.EMPLID = JO.MANAGER_ID AND NM.LANGUAGE_CD = A.LANGUAGE_CD UNION SELECT A.HRS_JOB_OPENING_ID , B.OPRID , A.LANGUAGE_CD , A.HRS_PRM_PST_TITLE , NM.NAME_DISPLAY FROM PS_HRS_JO_LNG A ,PS_HRS_JO_SEC_VW B ,PS_HRS_JOB_OPENING JO ,PS_HRS_PERSON_NM_I NM WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND B.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND NM.EMPLID = JO.MANAGER_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_PERSON_NM_L NML WHERE NML.EMPLID = NM.EMPLID AND NML.LANGUAGE_CD = A.LANGUAGE_CD) UNION SELECT A.HRS_JOB_OPENING_ID , B.OPRID , NM.LANGUAGE_CD , A.HRS_PRM_PST_TITLE , NM.NAME_DISPLAY FROM PS_HRS_JO_SEC_VW B ,PS_HRS_JOB_OPENING A ,PS_HRS_PERSON_NM_L NM WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND NM.EMPLID = A.MANAGER_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_JO_LNG JOL WHERE JOL.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID AND JOL.LANGUAGE_CD = NM.LANGUAGE_CD)

  • Related Language Record for HRS_PE_JOHM_I HRS_PE_QKSRCH_I

    • # 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    5 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country