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 | 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 |