RBN_AECNTRLTBL(SQL Table) |
Index Back |
---|---|
Knowledge base control recordApplication Engine Run Control Table for the AE processes of the knowledge base process |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RUNCONTROLID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
2 | NLP_TXN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Used as the nlp transaction type
0=Knowledge Base Setup 1=Knowledge Base Export 2=Sample Data Analysis 3=Knowledge Base Analysis 4=Category Import 5=Feedback Daemon 6=Manual Feedback 7=Feedback Teaching |
3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
4 | NLP_SERVER_ID | Character(15) | VARCHAR2(15) NOT NULL |
Used as the server unique identifier
Prompt Table: RBN_SERVER_VW |
5 | KB_BUILD_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Used to specify how to build the knowledge base
1=Training Source 2=Knowledge Base File (*.kb) 3=Category File (.txt) Default Value: 1 |
6 | 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 |
7 | NLP_LOCK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate the lock status
0=Locked 1=Unlocked Default Value: 0 |
8 | RUNDATE | Date(10) | DATE |
Process Scheduler Run Date
Default Value: %date |
9 | RUNTIME | Time(15) | TIMESTAMP |
Process Scheduler Process Run Time
Default Value: %time |
10 | KB_ID | Character(15) | VARCHAR2(15) NOT NULL |
Knowledge Base ID
Prompt Table: RBN_KB_VW |
11 | KB_QUEUE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
NLP feedback queue identifier
Prompt Table: RBN_FDBKQUE_VW |
12 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
13 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
14 | KB_RUN_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Used as KB run mode
C=Composite D=Distributed N=Not In Use Default Value: C |
15 | KB_MACHNAME | Character(30) | VARCHAR2(30) NOT NULL |
Used as machine name field
Prompt Table: RBN_MACHINE |
16 | KB_MACHINE_INSTNCE | Character(30) | VARCHAR2(30) NOT NULL |
store the kb instance machine
Prompt Table: RBN_MACHINE |
17 | NLP_IDLE_TIME | Number(4,0) | SMALLINT NOT NULL |
Used as knowledge base machine idle time
Default Value: 5 |
18 | NLP_MAX_INSTANCE | Number(3,0) | SMALLINT NOT NULL |
Used as knowledge base maximum instances
Default Value: 3 |
19 | NLP_MIN_INSTANCE | Number(3,0) | SMALLINT NOT NULL |
Used as knowledge base minimum instances
Default Value: 1 |
20 | NLP_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate the notification event
1=Always 2=On Success 3=On Failure Default Value: 3 |
21 | NLP_MATCH_NUM | Number(2,0) | SMALLINT NOT NULL |
NLP match number
1=1 2=2 3=3 4=4 5=5 Default Value: 5 |
22 | NLP_RPT_PERF | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate if the knowledge base overall performance report is generated
Y/N Table Edit |
23 | NLP_RPT_SUCCESS | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate if the category-based cumulative success report is generated
Y/N Table Edit |
24 | NLP_RPT_THRESHOLD | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate if the precision-recall threshold report is generated
Y/N Table Edit |
25 | NLP_PERF_FILENAME | Character(254) | VARCHAR2(254) NOT NULL | Used as file name in the NLP framework |
26 | NLP_THRSH_FILENAME | Character(254) | VARCHAR2(254) NOT NULL | Used as file name in the NLP framework |
27 | NLP_CATG_FILENAME | Character(254) | VARCHAR2(254) NOT NULL | Used as file name in the NLP framework |
28 | NLP_SAMPLE_ID | Character(15) | VARCHAR2(15) NOT NULL |
Used to identify the sample data definition
Prompt Table: RBN_KBDATADFN_V |
29 | NLP_CATEGORY_MAX | Number(5,0) | INTEGER NOT NULL | Usde to specify the minimum samples per category |
30 | NLP_CATEGORY_MIN | Number(5,0) | INTEGER NOT NULL | Usde to specify the minimum samples per category |
31 | NLP_CATEGORY_NUM | Number(15,0) | DECIMAL(15) NOT NULL | Usde to specify the minimum samples per category |
32 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
Prompt Table: RBN_KBLANG_VW |
33 | KB_NAME_LANG | Character(34) | VARCHAR2(34) NOT NULL | Used as language related knowledge base name |
34 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
35 | PROCESSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
36 | RUNDTTM | DateTime(26) | TIMESTAMP | Run Date/Time |
37 | NLP_RETRY_INTERVAL | Number(3,0) | SMALLINT NOT NULL |
Used to indicate the retry interval
Default Value: 180 |
38 | NLP_RETRY_NUM | Number(3,0) | SMALLINT NOT NULL |
Used to indicate the retry times of creating server object
Default Value: 3 |
39 | SERVERNAMERUN | Character(8) | VARCHAR2(8) NOT NULL | Server Name - Runtime |
40 | NLP_PRCSGRP_ID | Number(15,0) | DECIMAL(15) NOT NULL | NLP feedback parallel process group number |
41 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
42 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
43 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
44 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
45 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
46 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |