MKTSEGMENTWHITEMAIL

Stores information pertaining to a white mail segment.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
STATUSCODE tinyint Default = 0 Describes this white mail segment's active / inactive status
STATUS nvarchar(22) (Computed) yes CASE [STATUSCODE] WHEN 0 THEN N'Active indefinitely' WHEN 1 THEN N'Active over date range' WHEN 2 THEN N'Inactive' END Provides a translation for the 'STATUSCODE' field.
ACTIVEFROM datetime yes For white mail segments active over a date range, the date on which their active status begins.
ACTIVETO datetime yes For white mail segments active over a date range, the date on which their active status ends.
DATEADDED datetime Default = getdate() Indicates the date this record was added.
DATECHANGED datetime Default = getdate() Indicates the date this record was last changed.
TS timestamp Timestamp.
TSLONG bigint (Computed) yes CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Keys

Foreign Key Field Type Null Notes Description
ID uniqueidentifier MKTSEGMENT.ID Primary Key.
SEGMENTATIONID uniqueidentifier yes MKTSEGMENTATION.ID The marketing effort with which this white mail segment is associated.
SOURCECODEID uniqueidentifier MKTSOURCECODE.ID The source code layout used for this white mail segment.
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_MKTSEGMENTWHITEMAIL_DATEADDED DATEADDED yes
IX_MKTSEGMENTWHITEMAIL_DATECHANGED DATECHANGED
IX_MKTSEGMENTWHITEMAIL_SEGMENTATIONID SEGMENTATIONID
IX_MKTSEGMENTWHITEMAIL_SOURCECODEID SOURCECODEID
PK_MKTSEGMENTWHITEMAIL ID yes yes

Triggers

Trigger Name Description
TR_MKTSEGMENTWHITEMAIL_AUDIT_UPDATE
TR_MKTSEGMENTWHITEMAIL_AUDIT_DELETE

Referenced by

Referenced by Field
MKTSEGMENTWHITEMAILCACHE ID
MKTSEGMENTWHITEMAILREFRESHPROCESS SEGMENTID
MKTSOURCECODEMAP WHITEMAILSEGMENTID
MKTSOURCECODEPART WHITEMAILSEGMENTID