HRS_APPI_ALL_L1

(SQL View)
 Index Back

Related Language Record

Related Language Record for HRS_APPI_ALL_V1

SELECT APP.HRS_PERSON_ID , PROF.HRS_PROFILE_SEQ , NM.LANGUAGE_CD , NM.NAME_DISPLAY FROM PS_HRS_APPLICANT APP LEFT OUTER JOIN PS_HRS_APP_ADDR_I AD ON APP.HRS_PERSON_ID = AD.HRS_PERSON_ID , PS_HRS_APP_PROFILE PROF LEFT OUTER JOIN PS_HRS_APPINDX_CTL AI ON (PROF.HRS_PERSON_ID = AI.HRS_PERSON_ID AND PROF.HRS_PROFILE_SEQ = AI.HRS_PROFILE_SEQ) , PS_HRS_APP_NM_LNG NM , PS_HRS_APPIDXDT_TM TM WHERE APP.HRS_PERSON_ID = PROF.HRS_PERSON_ID AND APP.HRS_PERSON_ID = NM.HRS_PERSON_ID AND (APP.STATUS_CODE IN ( SELECT STATUS_CODE FROM PS_HRS_SRCHIDX_APS APS WHERE APS.HRS_SRCH_INDEX_CD = 'A') OR NOT EXISTS ( SELECT 1 FROM PS_HRS_SRCHIDX_APS APS WHERE APS.HRS_SRCH_INDEX_CD = 'A')) AND TM.HRS_PERSON_ID = APP.HRS_PERSON_ID AND TM.HRS_PROFILE_SEQ = PROF.HRS_PROFILE_SEQ

  • Related Language Record for HRS_APPI_ALL_V1

    • # 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_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    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