Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the package.
 DESCRIPTION nvarchar(255)   Default = '' The description of the package.
 UNITCOST money   Default = 0 The base cost of the package.
 CODE nvarchar(10)   Default = '' A unique code that identifies the package.
 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 0=Mail, 1=Email, 2=Phone, 3=Public media
 NETCOMMUNITYTEMPLATEID int   Default = 0 The ID of the NetCommunity email message associated with this email package
 NETCOMMUNITYDATASOURCEID int   Default = 0 The ID of the NetCommunity data source associated with this email package
 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 Provides a translation for the 'CHANNELCODE' field.
 COSTDISTRIBUTIONMETHODCODE tinyint   Default = 0 The method to be used to apply the package's base cost to a marketing effort.
 DOCUMENTFILENAME nvarchar(255)   Default = '' Filename of the document associated with this package.
 DOCUMENTFILE varbinary The document associated with this package.
 CHANNELSOURCECODE nvarchar(10)   Default = '' Code that defines the source code of the channel.
 ORGANIZATIONUNITCOST money   Default = 0 The amount of the unit cost in organization currency.
 ISSYSTEM bit   Default = 0 Flag used to hide packages meant for system use only.
 COSTDISTRIBUTIONMETHOD nvarchar(37) (Computed) CASE [COSTDISTRIBUTIONMETHODCODE] WHEN 0 THEN N'Per piece' WHEN 1 THEN N'Per response' WHEN 2 THEN N'Per marketing effort' WHEN 4 THEN N'Per thousand' WHEN 3 THEN N'Not included in marketing effort cost' END

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 SITEID uniqueidentifier SITE.ID The site to which this package belongs.
 PACKAGECATEGORYCODEID uniqueidentifier MKTPACKAGECATEGORYCODE.ID FK to MKTPACKAGECATEGORYCODE
 LETTERCODEID uniqueidentifier LETTERCODE.LOCALID The letter associated with this mail package.
 CREATIVEID uniqueidentifier MKTCREATIVE.ID The creative associated with this public media package.
 EXPORTDEFINITIONID uniqueidentifier EXPORTDEFINITION.ID The export definition associated with this package, if one is not already associated with its content.
 PARTDEFINITIONVALUESID uniqueidentifier MKTSOURCECODEPARTDEFINITIONVALUES.ID FK to MKTSOURCECODEPARTDEFINITIONVALUES
 CHANNELPARTDEFINITIONVALUESID uniqueidentifier MKTSOURCECODEPARTDEFINITIONVALUES.ID FK to MKTSOURCECODEPARTDEFINITIONVALUES
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this package.
 CURRENCYEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from amount to organization amount.

Index Name Field(s) Unique Primary Clustered
 IX_MKTPACKAGE_BASECURRENCYID BASECURRENCYID      
 IX_MKTPACKAGE_CHANNELPARTDEFINITIONVALUESID CHANNELPARTDEFINITIONVALUESID      
 IX_MKTPACKAGE_CREATIVEID CREATIVEID      
 IX_MKTPACKAGE_CURRENCYEXCHANGERATEID CURRENCYEXCHANGERATEID      
 IX_MKTPACKAGE_DATEADDED DATEADDED    
 IX_MKTPACKAGE_DATECHANGED DATECHANGED      
 IX_MKTPACKAGE_EXPORTDEFINITIONID EXPORTDEFINITIONID      
 IX_MKTPACKAGE_ID ID      
 IX_MKTPACKAGE_LETTERCODEID LETTERCODEID      
 IX_MKTPACKAGE_NETCOMMUNITYDATASOURCEID NETCOMMUNITYDATASOURCEID      
 IX_MKTPACKAGE_PARTDEFINITIONVALUESID PARTDEFINITIONVALUESID      
 IX_MKTPACKAGE_SITEID SITEID      
 PK_MKTPACKAGE ID  
 UC_MKTPACKAGE_NAME NAME    

Trigger Name Description
 TR_MKTPACKAGE_IU_ORGANIZATIONUNITCOST
 TR_MKTPACKAGE_AUDIT_UPDATE
 TR_MKTPACKAGE_AUDIT_DELETE

Referenced by Field
 APPEALMAILINGSETUP MAILPACKAGEID
 APPEALMAILINGSETUP EMAILPACKAGEID
 APPEALMAILINGSETUPLETTER MAILPACKAGEID
 APPEALMAILINGSETUPLETTER EMAILPACKAGEID
 BATCHDIRECTMARKETINGEFFORTPACKAGE MKTPACKAGEID
 BATCHREVENUECONSTITUENTAPPEAL MKTPACKAGEID
 COMMUNICATIONLETTER MAILPACKAGEID
 COMMUNICATIONLETTER EMAILPACKAGEID
 CONSTITUENTAPPEAL MKTPACKAGEID
 INVITATION MAILPACKAGEID
 INVITATION EMAILPACKAGEID
 INVITATIONHISTORY MAILPACKAGEID
 INVITATIONHISTORY EMAILPACKAGEID
 INVITEEHISTORY MKTPACKAGEID
 MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE PACKAGEID
 MKTFINDERNUMBERCONSTITUENTAPPEAL MKTPACKAGEID
 MKTMARKETINGPLANBRIEF PACKAGEID
 MKTMEMBERSHIPMAILINGTEMPLATERULE PACKAGEID
 MKTPACKAGECREATIVE PACKAGEID
 MKTPACKAGEDOCUMENT PACKAGEID
 MKTPACKAGEEXPENSE PACKAGEID
 MKTPACKAGEMATERIAL PACKAGEID
 MKTSEGMENTATIONLISTACTIVE PACKAGEID
 MKTSEGMENTATIONPACKAGE PACKAGEID
 MKTSEGMENTATIONSEGMENT PACKAGEID
 MKTSEGMENTATIONTESTSEGMENT PACKAGEID
 MKTSPONSORSHIPMAILINGTEMPLATERULE PACKAGEID
 PLEDGEREMINDERSENT PACKAGEID
 REVENUELETTER MKTPACKAGEID
 REVENUELETTERMARKETING MKTPACKAGEID

Entity-Relationship diagram of this table (APPEALMAILINGSETUP-MKTPACKAGECATEGORYCODE)
Entity-Relationship diagram of this table (MKTPACKAGECREATIVE-SITE)