RBN_SAMPLEAPP_V(SQL View) |
Index Back |
|---|---|
sample appSample Application View for Natural Language Process |
| SELECT DISTINCT A.KB_ID ,A.NLP_SAMPLE_ID ,B.KB_APPLICATION_ID ,C.NLP_DESCR254 FROM PS_RBN_KBDATADEFN A ,PS_RBN_KBDATADTL B ,PS_RBN_APPDEFN C WHERE A.NLP_SAMPLE_ID = B.NLP_SAMPLE_ID AND B.KB_APPLICATION_ID = C.KB_APPLICATION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(15) | VARCHAR2(15) NOT NULL | Knowledge Base ID | |
| 2 | Character(15) | VARCHAR2(15) NOT NULL | Used to identify the sample data definition | |
| 3 | Character(15) | VARCHAR2(15) NOT NULL |
Used to identify the unique NLP application
Prompt Table: RBN_APPDEFN |
|
| 4 | NLP_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | This field is a description field used in NLP. |