POI_TS_BATCHES
This table contains information about data sets that are used for creating a sample training set. A sample training set is generated from a data set based on the volume specified by the user. Sampling algorithms intelligently pick out the most unique transactions from the data set in order to have the best examples available in a training set.
Details
-
Schema: FUSION
-
Object owner: POI
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
POI_TS_BATCHES_PK |
BATCH_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Unique identifier for the batch. | |
| START_DATE | DATE | Effective start date of the training set. | |||
| END_DATE | DATE | Effective end date of the training set. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| STATUS | VARCHAR2 | 30 | Indicates the status of the training set. | ||
| BATCH_DESC | VARCHAR2 | 255 | Description of the training set batch. | ||
| ALGO_NAME | VARCHAR2 | 30 | Yes | Algorithm name used for the training set classification. | |
| DISTANCE_METHOD | VARCHAR2 | 30 | Yes | Distance method used in the training set. | |
| NO_OF_CLUS | NUMBER | 18 | Number of clusters being used in the training set process. | ||
| ERROR_CODE | VARCHAR2 | 240 | Error code, if any, in the training set batch process. | ||
| DATA_SOURCE_LISTS | VARCHAR2 | 2000 | Lists of data sources used in the training set. | ||
| TS_NAME | VARCHAR2 | 100 | Indicates the name of the training set. | ||
| UNIQUE_NAME | VARCHAR2 | 30 | Unique name of the model in the batch. | ||
| JOB_ID | VARCHAR2 | 30 | Identifies the job running the batch. | ||
| MESSAGE | VARCHAR2 | 1000 | Status message of batch process. | ||
| FEATURE_VECTOR | NUMBER | 18 | Feature vector value used in the training set. | ||
| CLEAN_META | VARCHAR2 | 30 | Indicator to clean up or destroy the model. | ||
| VOLUME | NUMBER | 30 | Volume indicator of the transactional data. | ||
| SAMPLE_PREF | VARCHAR2 | 30 | Sample preference of training data set. | ||
| SAMPLE_GEN | VARCHAR2 | 30 | Sample generation option of training data set. | ||
| BU_ID | NUMBER | 18 | Operating unit against the spend transaction. | ||
| TXN_START_DATE | DATE | Minimum transaction date in the transactions within a batch. | |||
| TXN_END_DATE | DATE | Maximum transaction date in the transactions within a batch. | |||
| 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. | |
| PROCESS_TYPE | VARCHAR2 | 30 | Processing type for training set. | ||
| TAXONOMY_ID | NUMBER | 18 | Unique identifier for the taxonomy. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| POI_TS_BATCHES_U1 | Unique | Default | BATCH_ID |
| POI_TS_BATCHES_U2 | Unique | Default | TS_NAME |
| POI_TS_BATCHES_U3 | Unique | Default | UNIQUE_NAME |