mktg_campaign Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The mktg_campaign table in the marketing database contains information about marketing campaigns.
The following table describes the columns in the mktg_campaign table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_camp_id |
int |
no |
The ID of this campaign. This is the primary key. |
dt_camp_start |
datetime |
no |
The date and time that this campaign starts. |
dt_camp_end |
datetime |
no |
The date and time that this campaign ends. |
u_camp_name |
nvarchar(50) |
no |
The name of this campaign. |
i_event_type_id |
int |
no |
The type of event that controls the scheduling of this campaign. This is a foreign key into the mktg_event_type table. |
i_camp_events_sched |
int |
no |
The number of events scheduled for this campaign. |
b_camp_level_goal |
bit |
no |
A Boolean value that indicates the level at which the goals for this campaign are set. |
i_customer_id |
int |
yes |
The ID of the customer of this campaign. This is a foreign key into the mktg_customer table. |
dt_camp_created |
datetime |
no |
The date and time at which this campaign record was created. |
dt_camp_archived |
datetime |
yes |
The date and time at which this campaign record was archived/deleted. |
dt_camp_exported |
datetime |
yes |
The date and time at which this campaign record was last exported to the Data Warehouse Analytics System. |
dt_camp_modified |
datetime |
yes |
The date and time at which this campaign record was last modified. |
u_camp_modified_by |
nvarchar(50) |
yes |
The name of the user who created or last modified this campaign record. |
b_camp_active |
bit |
yes |
A Boolean value that indicates whether this campaign is active (approved) or not. |
u_camp_comments |
nvarchar(1024) |
yes |
Any arbitrary comments about this campaign. |
b_camp_deleted |
bit |
yes |
A Boolean value that indicates whether this campaign has been archived/deleted. |