POI_KEYWORDS
This table contains the keyword statistics for every transaction record on which the classification process was run. For each transaction, details about all the available keywords in the transaction, and the weightage assigned to each keyword by the artificial intelligence or machine learning engine is stored. This type of keyword analysis is performed during the classification process and stored in this table. Users can see this keyword analysis in the transaction details page.
Details
-
Schema: FUSION
-
Object owner: POI
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
POI_KEYWORDS_PK |
KEYWORD_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
KEYWORD_ID | NUMBER | 18 | Yes | Identifies the transaction keyword. | |
TXN_ID | NUMBER | 18 | Yes | Unique identifier for each transaction row. | |
KEYWORD | VARCHAR2 | 160 | Keyword value for the transaction. | ||
WEIGHTAGE | NUMBER | 10 | Weightage contribution in arriving at the classification result. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
PHRASE_ATTRIBUTE | VARCHAR2 | 60 | Value that determines if the attribute used as a phrase as opposed to individual keywords for classification. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
POI_KEYWORDS_N1 | Non Unique | Default | TXN_ID |
POI_KEYWORDS_U1 | Unique | Default | KEYWORD_ID |