HRS_FIND_M_LN_I

(SQL View)
 Index Back

Find My Applicants Lng Vw

Find My Applicants Language View

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , E.LANGUAGE_CD , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.NAME_DISPLAY , B.NAME_AC , E.DESCR FROM PS_HRS_RCMNT A , PS_HRS_STS_REC_I D , PS_HRS_STS_LNG E , PS_HRS_APP_NM_LNG B WHERE D.STATUS_CODE = A.STATUS_CODE AND D.STATUS_AREA = E.STATUS_AREA AND D.STATUS_CODE = E.STATUS_CODE AND A.HRS_PERSON_ID = B.HRS_PERSON_ID AND B.LANGUAGE_CD = E.LANGUAGE_CD UNION SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , E.LANGUAGE_CD , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.NAME_DISPLAY , B.NAME_AC , E.DESCR FROM PS_HRS_RCMNT A , PS_HRS_STS_REC_I D , PS_HRS_STS_LNG E , PS_HRS_APP_NAMES B WHERE D.STATUS_CODE = A.STATUS_CODE AND D.STATUS_AREA = E.STATUS_AREA AND D.STATUS_CODE = E.STATUS_CODE AND A.HRS_PERSON_ID = B.HRS_PERSON_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_APP_NM_LNG BL WHERE BL.HRS_PERSON_ID = B.HRS_PERSON_ID AND BL.LANGUAGE_CD = E.LANGUAGE_CD) UNION SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , B.LANGUAGE_CD , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.NAME_DISPLAY , B.NAME_AC , E.DESCR FROM PS_HRS_RCMNT A , PS_HRS_STS_REC_I D , PS_HRS_STS_TBL E , PS_HRS_APP_NM_LNG B WHERE D.STATUS_CODE = A.STATUS_CODE AND D.STATUS_AREA = E.STATUS_AREA AND D.STATUS_CODE = E.STATUS_CODE AND A.HRS_PERSON_ID = B.HRS_PERSON_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_STS_LNG BL WHERE BL.STATUS_AREA = E.STATUS_AREA AND BL.STATUS_CODE = E.STATUS_CODE AND BL.LANGUAGE_CD = B.LANGUAGE_CD)

  • Related Language Record for HRS_FIND_MY_I HRS_FIND_MY_I2

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    6 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    7 HRS_NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description