RBN_KBDATADTL_V

(SQL View)
Index Back

KB data detail

Kb data detail view for Natural Language Process

SELECT NLP_SAMPLE_ID ,SEQ_NUM , KB_APPLICATION_ID , NLP_DATASOURCE , APPCLASSID , ATTACHSYSFILENAME , RECNAME , QRYNAME FROM PS_RBN_KBDATADTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 NLP_SAMPLE_ID Character(15) VARCHAR2(15) NOT NULL Used to identify the sample data definition
2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
3 KB_APPLICATION_ID Character(15) VARCHAR2(15) NOT NULL Used to identify the unique NLP application

Prompt Table: RBN_APPDEFN

4 NLP_DATASOURCE Character(1) VARCHAR2(1) NOT NULL Used to specify the sample data source
1=Application Class
2=PS Query
3=Simple SQL
4=Text File (CSV Format)
5 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

Prompt Table: RBN_APPCLASS_VW

6 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: RBN_SRCHREC_VW

8 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

Prompt Table: RBC_PSQRY_VW