POI_H_MODELS
This table contains information about the knowledge base. Knowledge base is an artificial intelligence or machine learning model that is generated using the training set data and taxonomy. Knowledge base is used by the user to classify their spend data that is unclassified or misclassified or is required to be classified using a different taxonomy.
Details
-
Schema: FUSION
-
Object owner: POI
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
POI_H_MODELS_PK |
MODEL_NAME |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
MODEL_NAME | VARCHAR2 | 90 | Yes | Name of the model in poi_models. | |
TAXONOMY_ID | NUMBER | 18 | Unique identifier of the taxonomy. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
TARGET_COLUMN | VARCHAR2 | 200 | Target column value of the taxonomy. | ||
STATUS | VARCHAR2 | 30 | Indicates the knowledge base status. | ||
BUILD_OPERATION_NAME | VARCHAR2 | 30 | Name of the model build operation. | ||
START_DATE | DATE | Effective start date of the model. | |||
END_DATE | DATE | Effective end date of the model. | |||
DATA_SOURCE_LISTS | VARCHAR2 | 2000 | List of data sources of the model. | ||
ERROR_MESSAGE | VARCHAR2 | 1000 | Indicates the error message of the model. | ||
CURRENT_STEP | VARCHAR2 | 30 | Current step value in the model process. | ||
CURRENT_STEP_PERCENT_COMPLETE | NUMBER | 3 | Completion percentage of the current step in the process. | ||
OPERATION_TYPE | VARCHAR2 | 30 | Indicates the type of the model operation. | ||
TEST_OPERATION_NAME | VARCHAR2 | 30 | Name of the model test operation. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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_LIST | VARCHAR2 | 2000 | Value that determines the attribute should be used as a phrase as opposed to individual keywords for classification. | ||
MODEL_TRAIN_TBL | VARCHAR2 | 120 | Name of the training table used while building knowledge base. | ||
MODEL_DATASET_NAME | VARCHAR2 | 30 | Name of the dataset used for knowledge base dataset edits. | ||
ENTITY_ID | NUMBER | 8 | Yes | Identifies the entity type for the knowledge base. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
POI_H_MODELS_N1 | Non Unique | Default | START_DATE |
POI_H_MODELS_U1 | Unique | Default | MODEL_NAME |