RBN_SERVER_VW (SQL View)	Index Back
Server View KB Sever View for Natural Language Process

RBN_SERVER_VW

(SQL View)

Server View

KB Sever View for Natural Language Process

SELECT NLP_SERVER_ID , MSGNODENAME , NLP_SRVR_USAGE , KB_MACHNAME FROM PS_RBN_SERVERDEFN WHERE NLP_STATUS = 'A'

# 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
Prompt Table: RBN_SERVERDEFN

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_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

4 KB_MACHNAME Character(30) VARCHAR2(30) NOT NULL Used as machine name field

#	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 Prompt Table: RBN_SERVERDEFN
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_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
4	KB_MACHNAME	Character(30)	VARCHAR2(30) NOT NULL	Used as machine name field