RBN_KBCFG_VW (SQL View)	Index Back
NLP KB configuration view KB configuration view for Natural Language Process

RBN_KBCFG_VW

(SQL View)

NLP KB configuration view

KB configuration view for Natural Language Process

SELECT A.KB_ID , A.NLP_LANGUAGE_CD ,A.NLP_SERVER_ID FROM PS_RBN_KBCONFG A ,PS_RBN_SERVERDEFN B WHERE A.NLP_STATUS = 'A' AND A.KB_RUN_MODE IN ('C','D') AND A.NLP_SERVER_ID = B.NLP_SERVER_ID AND B.NLP_STATUS='A' AND B.NLP_SRVR_USAGE = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 NLP_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Used as language code

3 NLP_SERVER_ID Character(15) VARCHAR2(15) NOT NULL Used as the server unique identifier

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	KB_ID	Character(15)	VARCHAR2(15) NOT NULL	Knowledge Base ID
2	NLP_LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Used as language code
3	NLP_SERVER_ID	Character(15)	VARCHAR2(15) NOT NULL	Used as the server unique identifier