RBN_CATGSYNDEFN

(SQL Table)
Index Back

Category

Category Sync Definition for Natural Language Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RUNCONTROLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
2 NLP_SERVER_ID Character(15) VARCHAR2(15) NOT NULL Used as the server unique identifier

Prompt Table: RBN_SERVERDEFN

3 KB_ID Character(15) VARCHAR2(15) NOT NULL Knowledge Base ID

Prompt Table: RBN_KB_VW

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Prompt Table: RBN_KBLANG_VW

5 KB_NAME_LANG Character(34) VARCHAR2(34) NOT NULL Used as language related knowledge base name
6 NLP_LOCK_STATUS Character(1) VARCHAR2(1) NOT NULL Used to indicate the lock status
0=Locked
1=Unlocked

Default Value: 0

7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 RUNDATE Date(10) DATE Process Scheduler Run Date
9 RUNTIME Time(15) TIMESTAMP Process Scheduler Process Run Time
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_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

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