RBN_AECNTRLTBL

(SQL Table)
Index Back

Knowledge base control record

Application 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