Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 LISTID uniqueidentifier ID from the MKTLIST table. Used for storing the List Code
 SOURCECODEITEMID uniqueidentifier 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) 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) isnull([SEGMENTATIONSEGMENTID], [SEGMENTATIONTESTSEGMENTID]) The segmentationsegment or testsegmentationsegment of the entity employing this source code part, for use in the unique index.
 OWNERID uniqueidentifier (Computed) 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) 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 Key Field Type Null Notes Description
 SEGMENTATIONID uniqueidentifier MKTSEGMENTATION.ID FK to MKTSEGMENTATION
 MARKETINGPLANITEMID uniqueidentifier MKTMARKETINGPLANITEM.ID FK to MKTMARKETINGPLANITEM
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 ACKNOWLEDGEMENTMAILINGTEMPLATEID uniqueidentifier MKTACKNOWLEDGEMENTMAILINGTEMPLATE.ID FK to MKTACKNOWLEDGEMENTMAILINGTEMPLATE
 MEMBERSHIPMAILINGTEMPLATEID uniqueidentifier MKTMEMBERSHIPMAILINGTEMPLATE.ID FK to MKTMEMBERSHIPMAILINGTEMPLATE
 SEGMENTATIONSEGMENTID uniqueidentifier MKTSEGMENTATIONSEGMENT.ID FK to MKTSEGMENTATIONSEGMENT
 PARTDEFINITIONVALUESID uniqueidentifier MKTSOURCECODEPARTDEFINITIONVALUES.ID FK to MKTSOURCECODEPARTDEFINITIONVALUES
 SPONSORSHIPMAILINGTEMPLATEID uniqueidentifier MKTSPONSORSHIPMAILINGTEMPLATE.ID FK to MKTSPONSORSHIPMAILINGTEMPLATE
 SEGMENTATIONTESTSEGMENTID uniqueidentifier MKTSEGMENTATIONTESTSEGMENT.ID FK to MKTSEGMENTATIONTESTSEGMENT
 WHITEMAILSEGMENTID uniqueidentifier MKTSEGMENTWHITEMAIL.ID FK to MKTSEGMENTWHITEMAIL

Index Name Field(s) Unique Primary Clustered
 IX_MKTSOURCECODEPART_ACKNOWLEDGEMENTMAILINGTEMPLATEID ACKNOWLEDGEMENTMAILINGTEMPLATEID      
 IX_MKTSOURCECODEPART_DATEADDED DATEADDED    
 IX_MKTSOURCECODEPART_DATECHANGED DATECHANGED      
 IX_MKTSOURCECODEPART_MARKETINGPLANITEMID MARKETINGPLANITEMID      
 IX_MKTSOURCECODEPART_MEMBERSHIPMAILINGTEMPLATEID MEMBERSHIPMAILINGTEMPLATEID      
 IX_MKTSOURCECODEPART_PARTDEFINITIONVALUESID PARTDEFINITIONVALUESID      
 IX_MKTSOURCECODEPART_SEGMENTATIONID SEGMENTATIONID      
 IX_MKTSOURCECODEPART_SEGMENTATIONSEGMENTID SEGMENTATIONSEGMENTID      
 IX_MKTSOURCECODEPART_SEGMENTATIONSEGMENTID_PARTDEFINITIONVALUESID SEGMENTATIONSEGMENTID, PARTDEFINITIONVALUESID      
 IX_MKTSOURCECODEPART_SEGMENTATIONTESTSEGMENTID SEGMENTATIONTESTSEGMENTID      
 IX_MKTSOURCECODEPART_SPONSORSHIPMAILINGTEMPLATEID SPONSORSHIPMAILINGTEMPLATEID      
 IX_MKTSOURCECODEPART_WHITEMAILSEGMENTID WHITEMAILSEGMENTID      
 PK_MKTSOURCECODEPART ID  
 UIX_MKTSOURCECODEPART_SOURCECODEITEMID_OWNERID_LISTID_CHANNELCODE_PARTDEFINITIONVALUESID_SEGMENTATIONSEGMENTOWNERID SOURCECODEITEMID, OWNERID, LISTID, CHANNELCODE, PARTDEFINITIONVALUESID, SEGMENTATIONSEGMENTOWNERID    

Trigger Name Description
 TR_MKTSOURCECODEPART_AUDIT_UPDATE
 TR_MKTSOURCECODEPART_AUDIT_DELETE

Entity-Relationship diagram of this table