RBN_SERVERDEFN

(SQL Table)
 Index Back

NLP server defnition table

Used to save ther server definition data

  • Related Language Record: RBN_SRVRDEFNLNG

  • Parent Record Of RBN_LANGDEFN RBN_MACHINE

    • # 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