RBN_SYSTEMDEFN

(SQL Table)
Index Back

System Definition

KB System Definition for Natural Language Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 NLP_URL_TMP Character(30) VARCHAR2(30) NOT NULL Used as ftp server url

Prompt Table: PSURLDEFN

2 NLP_URL_KB Character(30) VARCHAR2(30) NOT NULL Used as ftp server url

Prompt Table: PSURLDEFN

3 NLP_FDBK_AUTO_FLAG Character(1) VARCHAR2(1) NOT NULL Used to indicate if the feedback process is executed automatically.

Y/N Table Edit

Default Value: Y

4 NLP_CATEGORY_MIN Number(5,0) INTEGER NOT NULL Usde to specify the minimum samples per category

Default Value: 10

5 NLP_MAX_FDBKPRCS Number(2,0) SMALLINT NOT NULL Used as the field for the maximum feedback parallel processes

Default Value: 5

6 NLP_FDBK_MINIMUM Number(15,0) DECIMAL(15) NOT NULL NLP minimum feedbacks before calling submit method

Default Value: 100

7 RB_REFRESH_TIME Number(3,0) SMALLINT NOT NULL Refresh Duration

Default Value: 5

8 NLP_VENDOR Character(1) VARCHAR2(1) NOT NULL Used to indicate the nlp vendor
1=Banter Server

Default Value: 1

9 MAX_FILE_SIZE Number(9,0) DECIMAL(9) NOT NULL Maximum File Size
10 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

11 NLP_CHUNCK_SIZE Number(5,0) INTEGER NOT NULL NLP chunck size for the kb analysis

Default Value: 100

12 NLP_EMAIL Character(254) VARCHAR2(254) NOT NULL NLP email address
13 NLP_RETRY_NUM Number(3,0) SMALLINT NOT NULL Used to indicate the retry times of creating server object

Default Value: 3

14 NLP_RETRY_INTERVAL Number(3,0) SMALLINT NOT NULL Used to indicate the retry interval

Default Value: 180

15 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
16 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
17 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
18 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
19 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.
20 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time