This table describes the scheduling of campaign activities and content onto e-Marketing Spots.
Column Descriptions
| Column Name
| Column Type
| Description |
| INTVSCHED_ID
| INTEGER NOT NULL
| Primary key.
|
| INITIATIVE_ID
| INTEGER NOT NULL
| The ID of the object assigned to be scheduled to E-Marketing Spot. At present a campaign activity or store content can be scheduled to E-Marketing Spot.
|
| EMSPOT_ID
| INTEGER NOT NULL
| The ID of the e-Marketing Spot.
|
| STARTDATE
| TIMESTAMP NOT NULL
| The date before which the campaign activity should not be shown.
|
| ENDDATE
| TIMESTAMP NOT NULL
| The date beyond which the campaign activity should no longer be shown.
|
| PRIORITY
| INTEGER
| The priority of this schedule. This value resolves conflicts when multiple campaign activities are scheduled to display in the same e-Marketing Spot. The initiative schedule with the highest priority is displayed. By default, the highest priority is 1.
|
| STOREENT_ID
| INTEGER
| The ID of the store to which the campaign activity schedule belongs.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|