KB_QUEUE_IDKB_FDBKCATG_ID0=Queued
1=Processing
2=Submitted
3=Failed
RBN_FDBKHS_CATG(SQL Table) |
Index Back |
|---|---|
feedback history tablefeedback category history table |
| # | 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_FDBKCATG_ID |
Number(30,0) | DECIMAL(30) NOT NULL | NLP knowledge base feedback category identifier |
| 3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | NLP_CATEGORY | Character(100) | VARCHAR2(100) NOT NULL | Used as category field |
| 5 | KB_FDBK_TASK_ID | Number(30,0) | DECIMAL(30) NOT NULL | NLP feedback task identifier |
| 6 | KB_FDBK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
NLP feedback status
0=Queued 1=Processing 2=Submitted 3=Failed |
| 7 | KB_APPLICATION_ID | Character(15) | VARCHAR2(15) NOT NULL | Used to identify the unique NLP application |
| 8 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 9 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |