WebSphere Commerce database table: APPLY_INIT

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 NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
SQL050212031156790 SEGMENTATION_ID+INITIATIVE_ID Primary Key

Feedback