HRS_APPI_UPD_LN

(SQL View)
 Index Back

Related Language Record

Related Language Record for HRS_APPI_UPD_VW

SELECT APPIDX.HRS_PERSON_ID , APPIDX.HRS_PROFILE_SEQ , NM.LANGUAGE_CD , NM.NAME_DISPLAY FROM PS_HRS_APPLICANT APP , PS_HRS_APP_PROFILE PROF , PS_HRS_APP_ADDRESS ADDR , PS_HRS_APPINDX_CTL APPIDX , PS_HRS_APP_NM_LNG NM , PS_HRS_STS_REC_I ST WHERE APPIDX.INDEX_ACTION = 'U' AND APP.HRS_PERSON_ID = PROF.HRS_PERSON_ID AND APPIDX.HRS_PROFILE_SEQ = PROF.HRS_PROFILE_SEQ AND APP.HRS_PERSON_ID = ADDR.HRS_PERSON_ID AND APP.HRS_PERSON_ID = APPIDX.HRS_PERSON_ID AND APP.HRS_PERSON_ID = NM.HRS_PERSON_ID AND APP.STATUS_CODE = ST.STATUS_CODE AND ST.HRS_DRFT_STS_IND <> 'Y'

  • Related Language Record for HRS_APPI_UPD_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_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