RBN_CATGSYNDEFN(SQL Table) |
Index Back |
---|---|
CategoryCategory 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 |