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 | KB_ID | Character(15) | VARCHAR2(15) NOT NULL | Knowledge Base ID |
2 | NLP_SAMPLE_ID | Character(15) | VARCHAR2(15) NOT NULL | Used to identify the sample data definition |
3 | KB_APPLICATION_ID | 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. |