This table holds the results of the application of the mining model. The mining model is applied to information pertaining to campaign activities.
Column Description(s):
Column Name | Column Type | Description |
SEGMENTATION_ID |
INTEGER NOT NULL |
The segmentation ID of the segment associated with the application of the mining model. |
INITIATIVE_ID |
INTEGER NOT NULL |
The campaign activity ID associated with the application of the mining model. |
SEGMENT_INDEX |
INTEGER NOT NULL |
The segment ID within the specified model. Each model can contain several segments. |
SCORE |
DOUBLE |
A value between 0.0 and 1.0 representing how well the member meets the model and segment requirements, as defined in WebSphere Commerce Analyzer. 1.0 is a perfect match. |
CONFIDENCE |
DOUBLE |
The confidence rating of how well records with the characteristics of this segment actually form a segment. |
SCORE2 |
DOUBLE |
Reserved for IBM internal use. |
SEGMENT_INDEX2 |
INTEGER |
Reserved for IBM internal use. |
LAST_UPDATED |
TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP |
The time stamp of the last update to the record. |
LAST_UPDATED_ID |
INTEGER NOT NULL DEFAULT 0 |
The ID of the application that last updated the record. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031156790 |
SEGMENTATION_ID+INITIATIVE_ID |
Primary Key |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.