RBN_FDBKQUE_VW

(SQL View)
Index Back

NLP feedback queue view

Used to retrieve non-automated queue

SELECT A.KB_QUEUE_ID ,A.KB_QUEUE_NAME ,B.KB_ID ,B.KB_NAME_LANG FROM PS_RBN_FDBK_QUEUE A ,PS_RBN_LANGKB B WHERE A.NLP_STATUS = 'A' AND A.NLP_FDBK_AUTO_FLAG = 'N' AND A.KB_ID = B.KB_ID AND A.LANGUAGE_CD = B.LANGUAGE_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 KB_QUEUE_ID Number(15,0) DECIMAL(15) NOT NULL NLP feedback queue identifier

Default Value: 999999999999999

2 KB_QUEUE_NAME Character(30) VARCHAR2(30) NOT NULL NLP feedback queue name
3 KB_ID Character(15) VARCHAR2(15) NOT NULL Knowledge Base ID

Prompt Table: RBN_KB_VW

4 KB_NAME_LANG Character(34) VARCHAR2(34) NOT NULL Used as language related knowledge base name