KB_APPLICATION_IDFIELDNAMERBN_KBAPPMAP_VW(SQL View) |
Index Back |
|---|---|
KB Application mapKB application mapping for Natural Language Process |
| SELECT A.KB_APPLICATION_ID ,B.FIELDNAME ,B.KB_CNTNT_FLD ,C.SEQ_NUM FROM PS_RBN_APPDEFN A ,PS_RBN_APPMAP B ,PS_RBN_KB_CNTNTFLD C WHERE A.KB_APPLICATION_ID= B.KB_APPLICATION_ID AND A.KB_ID = C.KB_ID AND B.KB_CNTNT_FLD = C.KB_CNTNT_FLD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | KB_APPLICATION_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used to identify the unique NLP application |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | KB_CNTNT_FLD | Character(40) | VARCHAR2(40) NOT NULL | NLP Framework knowledge content field name |
| 4 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |