View to fetch values for external codes for category purpose

EXT_CODE_VW2_LG

(SQL View)
 Index Back

SELECT A.EXT_TYPE ,a.cd ,a.language_cd ,a.cd_name FROM PS_EXT_CODE_TBL_LN a WHERE A.EXT_TYPE = 'CAT'

  • Related Language Record for EXT_CODE_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_TYPE Character(3) VARCHAR2(3) NOT NULL External Type
    2 CD Character(30) VARCHAR2(30) NOT NULL Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 CD_NAME Character(254) VARCHAR2(254) NOT NULL Code Name