RUNCONTROLIDC=Completed
F=Failed
P=Processing
Q=Queued
S=Start
Default Value: S
0=Locked
1=Unlocked
Default Value: 0
Prompt Table: RBN_KB
RBN_CATG_SRCH_V(SQL View) |
Index Back |
|---|---|
Category importer viewUsed to search category importer run control ID |
| SELECT RUNCONTROLID , NLP_PROCESS_STATUS , NLP_LOCK_STATUS , OPRID , RUNDATE , KB_ID , LANGUAGE_CD , KB_NAME_LANG FROM PS_RBN_AECNTRLTBL WHERE NLP_TXN_TYPE = '4' |
| # | 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_ID | Character(15) | VARCHAR2(15) NOT NULL |
Knowledge Base ID
Prompt Table: RBN_KB |
| 7 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | KB_NAME_LANG | Character(34) | VARCHAR2(34) NOT NULL | Used as language related knowledge base name |