MKTSOURCECODEPART

Stores a value for a source code item associated with a specific marketing effort.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
LISTID	uniqueidentifier	yes		ID from the MKTLIST table. Used for storing the List Code
SOURCECODEITEMID	uniqueidentifier	yes		The original Source Code Item ID
CODE	nvarchar(10)		Default = ''	The code to use for this position.
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.
CHANNELCODE	tinyint		Default = 0	For channel source code parts, the channel for which this code is defined.
SEGMENTATIONSEGMENTOWNERID	uniqueidentifier (Computed)	yes	isnull([SEGMENTATIONSEGMENTID], [SEGMENTATIONTESTSEGMENTID])	The segmentationsegment or testsegmentationsegment of the entity employing this source code part, for use in the unique index.
OWNERID	uniqueidentifier (Computed)	yes	isnull(isnull(isnull(isnull(isnull([SEGMENTATIONID], [MARKETINGPLANITEMID]), [ACKNOWLEDGEMENTMAILINGTEMPLATEID]), [MEMBERSHIPMAILINGTEMPLATEID]), [SPONSORSHIPMAILINGTEMPLATEID]), [WHITEMAILSEGMENTID])	The ID of the entity employing this source code part, for use in the unique index.
CHANNEL	nvarchar(12) (Computed)	yes	CASE [CHANNELCODE] WHEN 0 THEN N'Mail' WHEN 1 THEN N'Email' WHEN 2 THEN N'Phone' WHEN 3 THEN N'Public media' END

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
SEGMENTATIONID	uniqueidentifier	yes	MKTSEGMENTATION.ID	FK to MKTSEGMENTATION
MARKETINGPLANITEMID	uniqueidentifier	yes	MKTMARKETINGPLANITEM.ID	FK to MKTMARKETINGPLANITEM
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
ACKNOWLEDGEMENTMAILINGTEMPLATEID	uniqueidentifier	yes	MKTACKNOWLEDGEMENTMAILINGTEMPLATE.ID	FK to MKTACKNOWLEDGEMENTMAILINGTEMPLATE
MEMBERSHIPMAILINGTEMPLATEID	uniqueidentifier	yes	MKTMEMBERSHIPMAILINGTEMPLATE.ID	FK to MKTMEMBERSHIPMAILINGTEMPLATE
SEGMENTATIONSEGMENTID	uniqueidentifier	yes	MKTSEGMENTATIONSEGMENT.ID	FK to MKTSEGMENTATIONSEGMENT
PARTDEFINITIONVALUESID	uniqueidentifier	yes	MKTSOURCECODEPARTDEFINITIONVALUES.ID	FK to MKTSOURCECODEPARTDEFINITIONVALUES
SPONSORSHIPMAILINGTEMPLATEID	uniqueidentifier	yes	MKTSPONSORSHIPMAILINGTEMPLATE.ID	FK to MKTSPONSORSHIPMAILINGTEMPLATE
SEGMENTATIONTESTSEGMENTID	uniqueidentifier	yes	MKTSEGMENTATIONTESTSEGMENT.ID	FK to MKTSEGMENTATIONTESTSEGMENT
WHITEMAILSEGMENTID	uniqueidentifier	yes	MKTSEGMENTWHITEMAIL.ID	FK to MKTSEGMENTWHITEMAIL

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MKTSOURCECODEPART_ACKNOWLEDGEMENTMAILINGTEMPLATEID	ACKNOWLEDGEMENTMAILINGTEMPLATEID
IX_MKTSOURCECODEPART_CODE	CODE
IX_MKTSOURCECODEPART_DATEADDED	DATEADDED			yes
IX_MKTSOURCECODEPART_DATECHANGED	DATECHANGED
IX_MKTSOURCECODEPART_MARKETINGPLANITEMID	MARKETINGPLANITEMID
IX_MKTSOURCECODEPART_MEMBERSHIPMAILINGTEMPLATEID	MEMBERSHIPMAILINGTEMPLATEID
IX_MKTSOURCECODEPART_PARTDEFINITIONVALUESID	PARTDEFINITIONVALUESID
IX_MKTSOURCECODEPART_SEGMENTATIONID_SOURCECODEITEMID_SEGMENTATIONSEGMENTID	SEGMENTATIONID, SOURCECODEITEMID, SEGMENTATIONSEGMENTID
IX_MKTSOURCECODEPART_SEGMENTATIONSEGMENTID_PARTDEFINITIONVALUESID	SEGMENTATIONSEGMENTID, PARTDEFINITIONVALUESID
IX_MKTSOURCECODEPART_SEGMENTATIONTESTSEGMENTID_SEGMENTATIONID_SOURCECODEITEMID	SEGMENTATIONTESTSEGMENTID, SEGMENTATIONID, SOURCECODEITEMID
IX_MKTSOURCECODEPART_SPONSORSHIPMAILINGTEMPLATEID	SPONSORSHIPMAILINGTEMPLATEID
IX_MKTSOURCECODEPART_WHITEMAILSEGMENTID	WHITEMAILSEGMENTID
PK_MKTSOURCECODEPART	ID	yes	yes
UIX_MKTSOURCECODEPART_SOURCECODEITEMID_OWNERID_LISTID_CHANNELCODE_PARTDEFINITIONVALUESID_SEGMENTATIONSEGMENTOWNERID	SOURCECODEITEMID, OWNERID, LISTID, CHANNELCODE, PARTDEFINITIONVALUESID, SEGMENTATIONSEGMENTOWNERID	yes

Triggers

Trigger Name	Description
TR_MKTSOURCECODEPART_AUDIT_UPDATE
TR_MKTSOURCECODEPART_AUDIT_DELETE