HRS_MY_APPVWLNG

(SQL View)
 Index Back

My Applicants Related Language

This related language view is used by the My Applicants pagelet to return a list of applicants that have been linked to job openings.

SELECT A.HRS_PERSON_ID , B.HRS_RCMNT_ID , TM.EMPLID , E.LANGUAGE_CD , C.NAME_DISPLAY , E.HRS_PRM_PST_TITLE FROM PS_HRS_APPLICANT_I A , PS_HRS_RCMNT_I B , PS_HRS_APP_NM_LNG C , PS_HRS_JO_LNG E , PS_HRS_JO_TEAM TM WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND E.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND TM.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND C.HRS_PERSON_ID = A.HRS_PERSON_ID AND C.NAME_TYPE = 'PRI' AND C.LANGUAGE_CD = E.LANGUAGE_CD UNION SELECT A.HRS_PERSON_ID , B.HRS_RCMNT_ID , TM.EMPLID , E.LANGUAGE_CD , C.NAME_DISPLAY , E.HRS_PRM_PST_TITLE FROM PS_HRS_APPLICANT_I A , PS_HRS_RCMNT_I B , PS_HRS_APP_NAMES C , PS_HRS_JO_LNG E , PS_HRS_JO_TEAM TM WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND E.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND TM.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND C.HRS_PERSON_ID = A.HRS_PERSON_ID AND C.NAME_TYPE = 'PRI' AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_APP_NM_LNG NML WHERE NML.HRS_PERSON_ID = C.HRS_PERSON_ID AND NML.LANGUAGE_CD = E.LANGUAGE_CD AND C.NAME_TYPE = 'PRI') UNION SELECT A.HRS_PERSON_ID , B.HRS_RCMNT_ID , TM.EMPLID , C.LANGUAGE_CD , C.NAME_DISPLAY , E.HRS_PRM_PST_TITLE FROM PS_HRS_APPLICANT_I A , PS_HRS_RCMNT_I B , PS_HRS_APP_NM_LNG C , PS_HRS_JOB_OPENING E , PS_HRS_JO_TEAM TM WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND E.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND TM.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND C.HRS_PERSON_ID = A.HRS_PERSON_ID AND C.NAME_TYPE = 'PRI' AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_JO_LNG EL WHERE EL.HRS_JOB_OPENING_ID = E.HRS_JOB_OPENING_ID AND EL.LANGUAGE_CD = C.LANGUAGE_CD)

  • Related Language Record for HRS_MY_APP_VW

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    6 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title