CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
Added in Version 7.0
The HIST_LEAD_RESPONSE table stores all the information pertaining to campaign lead response history. This information includes, but is not limited to, campaign response ID, campaign ID, comments, response date, response method, and campaign stage.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
HIST_LEAD_RESPONSEID |
char(12) |
NOT NULL |
HIST_LEAD_RESP_RESPONSEID (IE) |
|
HIST_LEADID(FK) |
char(12) |
NOT NULL |
HIST_LEAD_RESP_LEADID (IE) |
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
CAMPAIGNID(FK) |
char(12) |
NULLS |
HIST_LEAD_RESP_CAMPAIGNID (IE) |
|
COMMENTS |
varchar(255) |
NULLS |
|
|
GROUPNAME |
varchar(32) |
NULLS |
|
|
INITIALTARGET |
char(1) |
NULLS |
|
|
LEADSOURCE |
varchar(32) |
NULLS |
|
|
RESPONDED |
char(1) |
NULLS |
|
|
RESPONSEDATE |
datetime(8) |
NULLS |
|
|
RESPONSEMETHOD |
varchar(32) |
NULLS |
|
|
STAGE |
varchar(64) |
NULLS |
|
|
STATUS |
varchar(32) |
NULLS |
|
|
TARGETTYPE |
varchar(32) |
NULLS |
|