RUNCONTROLIDC=Completed
F=Failed
P=Processing
Q=Queued
S=Start
Default Value: S
0=Locked
1=Unlocked
Default Value: 0
Prompt Table: RBN_FDBKQUE_VW
RBN_QUE_SRCH_V(SQL View) |
Index Back |
|---|---|
KN QueueKnowledge Base queue view for Natural Language Process |
| SELECT A.RUNCONTROLID , A.NLP_PROCESS_STATUS , A.NLP_LOCK_STATUS , A.OPRID , A.RUNDATE , A.KB_QUEUE_ID , B.KB_QUEUE_NAME FROM PS_RBN_AECNTRLTBL A ,PS_RBN_FDBK_QUEUE B WHERE A.NLP_TXN_TYPE = '6' AND A.KB_QUEUE_ID = B.KB_QUEUE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUNCONTROLID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | NLP_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Used to specify the sample data analysis status
C=Completed F=Failed P=Processing Q=Queued S=Start Default Value: S |
| 3 | NLP_LOCK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate the lock status
0=Locked 1=Unlocked Default Value: 0 |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | RUNDATE | Date(10) | DATE | Process Scheduler Run Date |
| 6 | KB_QUEUE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
NLP feedback queue identifier
Prompt Table: RBN_FDBKQUE_VW |
| 7 | KB_QUEUE_NAME | Character(30) | VARCHAR2(30) NOT NULL | NLP feedback queue name |