HRS_APP_FWD_VWL

(SQL View)
 Index Back

Forward Applicant View

Forward Applicant View

SELECT A.HRS_CRSP_ID , A.HRS_PERSON_ID , D.LANGUAGE_CD , NML.NAME_DISPLAY , D.HRS_RESUME_TITLE FROM PS_HRS_APP_FRWD A , PS_HRS_APP_RES_LNG D , PS_HRS_APP_NAME_LN NML WHERE A.HRS_PERSON_ID = D.HRS_PERSON_ID AND A.HRS_RESUME_ID = D.HRS_RESUME_ID AND NML.HRS_PERSON_ID = A.HRS_PERSON_ID AND NML.LANGUAGE_CD = D.LANGUAGE_CD UNION SELECT A.HRS_CRSP_ID , A.HRS_PERSON_ID , D.LANGUAGE_CD , NM.NAME_DISPLAY , D.HRS_RESUME_TITLE FROM PS_HRS_APP_FRWD A , PS_HRS_APP_RES_LNG D , PS_HRS_APP_NAME_I NM WHERE A.HRS_PERSON_ID = D.HRS_PERSON_ID AND A.HRS_RESUME_ID = D.HRS_RESUME_ID AND NM.HRS_PERSON_ID = A.HRS_PERSON_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_APP_NAME_LN NML WHERE NML.HRS_PERSON_ID = A.HRS_PERSON_ID AND NML.LANGUAGE_CD = D.LANGUAGE_CD) UNION SELECT A.HRS_CRSP_ID , A.HRS_PERSON_ID , NML.LANGUAGE_CD , NML.NAME_DISPLAY , D.HRS_RESUME_TITLE FROM PS_HRS_APP_FRWD A , PS_HRS_APP_RES D , PS_HRS_APP_NAME_LN NML WHERE A.HRS_PERSON_ID = D.HRS_PERSON_ID AND A.HRS_RESUME_ID = D.HRS_RESUME_ID AND NML.HRS_PERSON_ID = A.HRS_PERSON_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_APP_RES_LNG DL WHERE DL.HRS_PERSON_ID = A.HRS_PERSON_ID AND DL.HRS_RESUME_ID = A.HRS_RESUME_ID AND DL.LANGUAGE_CD = NML.LANGUAGE_CD)

  • Related Language Record for HRS_APP_FWRD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_CRSP_ID Number(15,0) DECIMAL(15) NOT NULL Correspondence ID
    2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    5 HRS_RESUME_TITLE Character(60) VARCHAR2(60) NOT NULL Profile ID