HRS_ALL_APPL_LV

(SQL View)
Index Back

All Applicants

All applicants - Related language

SELECT A.HRS_PERSON_ID , B.LANGUAGE_CD , B.DESCR , C.NAME_DISPLAY FROM PS_HRS_APPLICANT A , PS_HRS_STS_APP_LVW B , PS_HRS_APP_NM_LNG C WHERE A.STATUS_CODE = B.STATUS_CODE AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND B.STATUS_AREA = '2' AND B.LANGUAGE_CD = C.LANGUAGE_CD UNION SELECT A.HRS_PERSON_ID , B.LANGUAGE_CD , B.DESCR , C.NAME_DISPLAY FROM PS_HRS_APPLICANT A , PS_HRS_STS_APP_LVW B , PS_HRS_APP_NAMES C WHERE A.STATUS_CODE = B.STATUS_CODE AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND B.STATUS_AREA = '2' AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_APP_NM_LNG NM WHERE NM.HRS_PERSON_ID = A.HRS_PERSON_ID AND NM.LANGUAGE_CD = B.LANGUAGE_CD) UNION SELECT A.HRS_PERSON_ID , C.LANGUAGE_CD , B.DESCR , C.NAME_DISPLAY FROM PS_HRS_APPLICANT A , PS_HRS_STS_APP_I B , PS_HRS_APP_NM_LNG C WHERE A.STATUS_CODE = B.STATUS_CODE AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND B.STATUS_AREA = '2' AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_STS_APP_LVW STS WHERE STS.STATUS_CODE = A.STATUS_CODE AND B.STATUS_AREA = '2' AND STS.LANGUAGE_CD = C.LANGUAGE_CD)

  • Related Language Record for HRS_ALL_APPL_V1 HRS_ALL_APPL_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country