RBN_FDBKQUE_VW(SQL View) |
Index Back |
|---|---|
NLP feedback queue viewUsed 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 | 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 |