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. |