Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SOURCECODE nvarchar(50)   Default = '' The source code that identifies the segment or test segment.
 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.

Foreign Key Field Type Null Notes Description
 SEGMENTATIONID uniqueidentifier MKTSEGMENTATION.ID The marketing effort to which this source code belongs.
 SEGMENTATIONSEGMENTID uniqueidentifier MKTSEGMENTATIONSEGMENT.ID The marketing effort segment associated with this source code.
 SEGMENTATIONTESTSEGMENTID uniqueidentifier MKTSEGMENTATIONTESTSEGMENT.ID The marketing effort test segment associated with this source code.
 DONORQUERYVIEWCATALOGID uniqueidentifier   QUERYVIEWCATALOG.ID The record source query view for this segment.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 LISTID uniqueidentifier MKTLIST.ID The list associated with this source code.
 SOURCECODEID uniqueidentifier   MKTSOURCECODE.ID The source code layout associated with this source code.
 WHITEMAILSEGMENTID uniqueidentifier MKTSEGMENTWHITEMAIL.ID The white mail segment associated with this source code.

Index Name Field(s) Unique Primary Clustered
 IX_MKTSOURCECODEMAP_DATEADDED DATEADDED    
 IX_MKTSOURCECODEMAP_DATECHANGED DATECHANGED      
 IX_MKTSOURCECODEMAP_DONORQUERYVIEWCATALOGID_SEGMENTATIONID DONORQUERYVIEWCATALOGID, SEGMENTATIONID      
 IX_MKTSOURCECODEMAP_LISTID LISTID      
 IX_MKTSOURCECODEMAP_SEGMENTATIONID SEGMENTATIONID      
 IX_MKTSOURCECODEMAP_SEGMENTATIONTESTSEGMENTID SEGMENTATIONTESTSEGMENTID      
 IX_MKTSOURCECODEMAP_SOURCECODE SOURCECODE      
 IX_MKTSOURCECODEMAP_SOURCECODEID SOURCECODEID      
 IX_MKTSOURCECODEMAP_WHITEMAILSEGMENTID WHITEMAILSEGMENTID      
 PK_MKTSOURCECODEMAP ID  
 UIX_MKTSOURCECODEMAP_ID ID    
 UIX_MKTSOURCECODEMAP_SEGMENTATIONSEGMENTID_SEGMENTATIONTESTSEGMENTID_LISTID_WHITEMAILSEGMENTID SEGMENTATIONSEGMENTID, SEGMENTATIONTESTSEGMENTID, LISTID, WHITEMAILSEGMENTID    

Trigger Name Description
 TR_MKTSOURCECODEMAP_AUDIT_UPDATE
 TR_MKTSOURCECODEMAP_AUDIT_DELETE
 TR_MKTSOURCECODEMAP_AUDIT_ETLDELETEDID

Referenced by Field
 CONSTITUENTSEGMENT SOURCECODEMAPID
 MKTSOURCECODEMAPPART MKTSOURCECODEMAPID
 REVENUESEGMENT SOURCECODEMAPID

Entity-Relationship diagram of this table