RBN_KBLANG_VW (SQL View)	Index Back
language view record language view record for Natural Language Process

RBN_KBLANG_VW

(SQL View)

language view record

language view record for Natural Language Process

SELECT A.KB_ID ,A.LANGUAGE_CD ,B.XLATLONGNAME FROM PS_RBN_LANGKB A ,PSXLATITEM B WHERE A.LANGUAGE_CD = B.FIELDVALUE AND B.FIELDNAME = 'LANGUAGE_CD' AND B.EFF_STATUS = 'A'

Related Language Record: RBN_LANGVW_LANG

# 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_LANGUAGE Character(30) VARCHAR2(30) NOT NULL Used as the language field

#	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_LANGUAGE	Character(30)	VARCHAR2(30) NOT NULL	Used as the language field