RBN_KBAPP_LNG_V

(SQL View)
 Index Back

Application view

Used to retrieve active application definition

SELECT A.KB_ID , B.KB_APPLICATION_ID ,B.LANGUAGE_CD , B.NLP_DESCR254 FROM PS_RBN_KB A , PS_RBN_APPDEFNLANG B ,PS_RBN_APPDEFN C WHERE A.KB_ID = C.KB_ID AND B.KB_APPLICATION_ID =C.KB_APPLICATION_ID

  • Related Language Record for RBN_KBAPP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 KB_ID Character(15) VARCHAR2(15) NOT NULL Knowledge Base ID
    2 KB_APPLICATION_ID Character(15) VARCHAR2(15) NOT NULL Used to identify the unique NLP application
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NLP_DESCR254 Character(254) VARCHAR2(254) NOT NULL This field is a description field used in NLP.