RBN_SERVERDEFN(SQL Table) |
Index Back |
---|---|
NLP server defnition tableUsed to save ther server definition data |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | NLP_SERVER_ID | Character(15) | VARCHAR2(15) NOT NULL | Used as the server unique identifier |
2 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Prompt Table: RBN_IBNODE_VW |
3 | NLP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate the KB status.
A=Active I=Inactive Default Value: A |
4 | NLP_SRVR_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate if NLP server is used for production or development
D=Development Environment P=Production Environment Default Value: P |
5 | KB_MACHNAME | Character(30) | VARCHAR2(30) NOT NULL | Used as machine name field |
6 | NLP_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | This field is a description field used in NLP. |
7 | NLP_DB_SERVER | Character(30) | VARCHAR2(30) NOT NULL | Used as the db server field |
8 | NLP_DBNAME | Character(30) | VARCHAR2(30) NOT NULL | Used as the database name field |
9 | NLP_SERVER_VERSION | Character(10) | VARCHAR2(10) NOT NULL | used as the server version field |
10 | NLP_LICENSE | Character(254) | VARCHAR2(254) NOT NULL | Used as the license field |
11 | NLP_EXPIRE_DTTM | DateTime(26) | TIMESTAMP | Used to inidicate the license expiration datetime |
12 | NLP_MAX_MACHINE | Signed Number(31,0) | DECIMAL(30) NOT NULL | Used as the Maximum Machines fields -1 means unlimited |
13 | NLP_MAX_KB | Signed Number(31,0) | DECIMAL(30) NOT NULL | Used as the maximum kbs fields. -1 means unlimited |
14 | NLP_ACCR_RQST | Signed Number(31,0) | DECIMAL(30) NOT NULL | Used as the accumulated request fields. -1 mean unlimited |
15 | NLP_YEAR_RQSTS | Signed Number(31,0) | DECIMAL(30) NOT NULL | Used as the yearly request field -1 means unlimited |
16 | NLP_SYSAPI_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Used as the api field
Y/N Table Edit |
17 | NLP_SPAN_DAYS | Signed Number(31,0) | DECIMAL(30) NOT NULL | Used as the span day field -1 mean unlimited |
18 | NLP_FDBK_MINUTES | Number(10,0) | DECIMAL(10) NOT NULL |
Used as the feedback field
Default Value: 30 |
19 | NLP_FDBK_NUM | Number(10,0) | DECIMAL(10) NOT NULL |
Used as the feedback field
Default Value: 500 |
20 | NLP_CKB_PROCESS | Character(2) | VARCHAR2(2) NOT NULL |
Used to specify how many composite knowledge bases per process
-1=All In One Process 1=1 10=10 2=2 3=3 4=4 5=5 6=6 7=7 8=8 9=9 Default Value: 1 |
21 | NLP_AUTHENTICATED | Character(1) | VARCHAR2(1) NOT NULL |
Use to indicate if the authentication is required
N=Not required Y=Required Default Value: N |
22 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
23 | OPERPSWD | Character(32) | VARCHAR2(32) NOT NULL | An user's password |
24 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
Prompt Table: PSURLDEFN |
25 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
26 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
27 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
28 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
29 | 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. |
30 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |