This table contains the data describing an initiative.
Column Name | Column Type | Column Description |
---|---|---|
CAMPAIGN_ID | INTEGER NULL |
The ID of the campaign to which this initiative belongs. |
DESCRIPTION | VARCHAR (254) NULL |
This field contains the description of the initiative. |
FIELD1 | VARCHAR (254) NULL |
Customizable. |
INITIATIVE_ID | INTEGER NOT NULL |
Primary key. |
LASTUPDATE | TIMESTAMP NOT NULL |
This field contains a timestamp of the last update date for the initiative. |
LASTUPDATEDBY | VARCHAR (254) NOT NULL |
This field contains the logon ID of the individual who last updated the initiative. |
NAME | VARCHAR (64) NOT NULL |
This field contains the name of the initiative. |
RESULTTYPE | CHARACTER (1) NULL |
The type of output produced by the initiative: A = Awareness ad, P = Product, C = Category, or S = Cross-sell/Up-sell on product. |
RULE | LONG VARCHAR NULL |
An XML document describing the rule for the initiative. |
SELLTYPE | INTEGER NULL |
Initiative classification: 1 = General, 2 = Up sell, 3 = Cross sell, 4 = Discount, or 5 = Coupon. |
STATUS | CHARACTER (1) NULL |
Initiative status. Valid values include: null - enabled/resumed D - disabled/suspended |
STOREENT_ID | INTEGER NOT NULL |
The ID of the store to which the initiative belongs. |
TYPE | INTEGER NULL |
Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000134 | NAME, STOREENT_ID | Unique Index |
SQL030416034945540 | INITIATIVE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_384 | CAMPAIGN_ID | CAMPAIGN | CAMPAIGN_ID | Cascade |
F_385 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_266 | INITIATIVE_ID | CPPMN | INITIATIVE_ID | Cascade |
F_386 | INITIATIVE_ID | INTVSCHED | INITIATIVE_ID | Cascade |