This table contains the data describing a campaign Web activity.
Column Descriptions
| Column Name
| Column Type
| Description
|
| INITIATIVE_ID
| INTEGER NOT NULL
| Primary key.
|
| NAME
| VARCHAR(64) NOT NULL
| This field contains the name of the campaign Web activity.
|
| DESCRIPTION
| VARCHAR(254)
| This field contains the description of the campaign Web activity.
|
| CAMPAIGN_ID
| INTEGER
| The ID of the campaign to which this Web activity belongs.
|
| TYPE
| INTEGER
| Reserved for IBM internal use.
|
| STATUS
| CHAR(1)
| Campaign Web activity status. Valid values include:
null - enabled or resumed
D - disabled or suspended
|
| FIELD1
| VARCHAR(254)
| Customizable.
|
| LASTUPDATE
| TIMESTAMP NOT NULL
| This field contains a timestamp of the last update date for the campaign Web activity.
|
| LASTUPDATEDBY
| VARCHAR(254) NOT NULL
| This field contains the logon ID of the individual who last updated the campaign Web activity.
|
| STOREENT_ID
| INTEGER NOT NULL
| The ID of the store to which the campaign Web activity belongs.
|
| RULE
| CLOB
| An XML document describing the rule for the campaign Web activity.
|
| RESULTTYPE
| CHAR(1)
| The type of output produced by the campaign Web activity:
A = Awareness ad
P = Product
C = Category
S = Cross-sell or Up-sell on product
|
| SELLTYPE
| INTEGER
| Campaign Web activity classification:
1 = General
2 = Up sell
3 = Cross sell
4 = Discount
5 = Coupon
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|