Added in Version 7.0
The MKTGSVC_CAMPAIGN table stores all the campaign information for the marketing service. This table contains information including, but not limited to the lead's response ID, the campaign ID, the date a link was clicked, the name of the link, and the link URL.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
MKTGSVC_CAMPAIGNID (PK) |
char(12) |
NOT NULL |
MKTGSVC_CAMPAIGN_ID_PK (CA) |
(One) to (Many) |
|
|
CAMPAIGNID (FK) |
char(12) |
NOT NULL |
MKTGSVC_CAMPAIGN_CAMPAIGNID (IE) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MKTGSVC_CAMPAIGNNAME |
varchar(50) |
NOT NULL |
MKTGSVC_CAMPAIGN_NAME(AK) |
|
|
|
MKTGSVC_LISTID (FK) |
char(12) |
NOT NULL |
MKTGSVC_LISTID(AK) |
|
|
|
MKTGSVC_LISTNAME |
varchar(50) |
NOT NULL |
MKTGSVC_CAMPAIGN_LNAME(AK) |
|
|
|
NOTIFICATION_EMAIL |
varchar(128) |
NULLS |
|
|
|
|
PROCESS_RESPONSES |
char(1) |
NULLS |
|
|
|
|
UPLOADDATE |
datetime(8) |
NULLS |
|
|
|
|
LASTRETRIEVALDATE |
datetime(8) |
NULLS |
|
|
|
|
ENABLED |
char(1) |
NULLS |
|
|
|
|
USERID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
STAGEID (FK) |
char(12) |
NULLS |
MKTGSVC_CAMPAIGN_STAGEID(IE) |
(Many) to (One) |