RBN_FDBK_SRCH_V (SQL View)	Index Back
Feddback Bk Feedback Search Data table for Natural Language Process

RBN_FDBK_SRCH_V

(SQL View)

Feddback Bk

Feedback Search Data table for Natural Language Process

SELECT A.KB_QUEUE_ID ,B.KB_QUEUE_NAME ,B.NLP_STATUS ,A.KB_ID ,A.LANGUAGE_CD FROM PS_RBN_FDBK_KB A ,PS_RBN_FDBK_QUEUE B WHERE A.KB_QUEUE_ID = B.KB_QUEUE_ID

# 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

2 KB_QUEUE_NAME Character(30) VARCHAR2(30) NOT NULL NLP feedback queue name

3 NLP_STATUS Character(1) VARCHAR2(1) NOT NULL Used to indicate the KB status.
A=Active
I=Inactive

4 KB_ID Character(15) VARCHAR2(15) NOT NULL Knowledge Base ID
Prompt Table: RBN_KB_VW

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

#	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
2	KB_QUEUE_NAME	Character(30)	VARCHAR2(30) NOT NULL	NLP feedback queue name
3	NLP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate the KB status. A=Active I=Inactive
4	KB_ID	Character(15)	VARCHAR2(15) NOT NULL	Knowledge Base ID Prompt Table: RBN_KB_VW
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code