RBN_LANGVW_LANG

(SQL View)
 Index Back

Kb language

KB language view for Natural Language Process

SELECT A.KB_ID ,A.LANGUAGE_CD ,C.LANGUAGE_CD ,C.XLATLONGNAME FROM PS_RBN_LANGKB A ,PSXLATITEM B ,PSXLATITEMLANG C WHERE A.LANGUAGE_CD = B.FIELDVALUE AND B.FIELDNAME = 'LANGUAGE_CD' AND B.EFF_STATUS = 'A' AND B.FIELDNAME = C.FIELDNAME AND B.FIELDVALUE = C.FIELDVALUE AND B.EFFDT = C.EFFDT

  • Related Language Record for RBN_KBLANG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 KB_ID Character(15) VARCHAR2(15) NOT NULL Knowledge Base ID
    2 NLP_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Used as language code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NLP_LANGUAGE Character(30) VARCHAR2(30) NOT NULL Used as the language field