RBN_KBAPP_VW

(SQL View)
 Index Back

Application view

Used to retrieve active application definition

SELECT A.KB_ID , B.KB_APPLICATION_ID ,B.NLP_STATUS , B.NLP_DESCR254 FROM PS_RBN_KB A , PS_RBN_APPDEFN B WHERE A.KB_ID = B.KB_ID

  • Related Language Record: RBN_KBAPP_LNG_V

    • # 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 NLP_STATUS Character(1) VARCHAR2(1) NOT NULL Used to indicate the KB status.
    A=Active
    I=Inactive
    4 NLP_DESCR254 Character(254) VARCHAR2(254) NOT NULL This field is a description field used in NLP.