Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEQUENCE int   Default = 0 The sequence of rows in the corresponding batch.
 SOURCECODE nvarchar(50)   Default = '' The full source code for the segment.
 SEGMENTEXPECTEDGIFTAMOUNT money   Default = 0 The average expected gift amount per donor for the segment.
 SEGMENTEXPECTEDRESPONSERATE decimal(5, 2)   Default = 0 The expected response rate for the segment.
 SEGMENTRENTALQUANTITY int   Default = 0 The number of rented records in the list segment.
 SEGMENTEXCHANGEQUANTITY int   Default = 0 The number of records received via exchange in the list segment.
 SEGMENTRENTALCOST money   Default = 0 The cost of the rented records in the segment.
 SEGMENTRENTALCOSTBASISCODE tinyint   Default = 1 The basis on which the cost of the rented records in the segment should be calculated.
 SEGMENTRENTALCOSTBASIS nvarchar(12) (Computed) CASE [SEGMENTRENTALCOSTBASISCODE] WHEN 1 THEN N'Per thousand' WHEN 2 THEN N'Flat' END Provides a translation for the 'SEGMENTRENTALCOSTBASISCODE' field.
 SEGMENTEXCHANGECOST money   Default = 0 The cost of the records received via exchange in the segment.
 SEGMENTEXCHANGECOSTBASISCODE tinyint   Default = 1 The basis on which the cost of the exchanged records in the segment should be calculated.
 SEGMENTEXCHANGECOSTBASIS nvarchar(12) (Computed) CASE [SEGMENTEXCHANGECOSTBASISCODE] WHEN 1 THEN N'Per thousand' WHEN 2 THEN N'Flat' END Provides a translation for the 'SEGMENTEXCHANGECOSTBASISCODE' field.
 SEGMENTUSAGECODE tinyint   Default = 1 Indicates whether the list segment is being used for testing, retesting, or is a continuation or reuse.
 SEGMENTUSAGE nvarchar(12) (Computed) CASE [SEGMENTUSAGECODE] WHEN 1 THEN N'Test' WHEN 2 THEN N'Retest' WHEN 3 THEN N'Continuation' WHEN 4 THEN N'Reuse' END Provides a translation for the 'SEGMENTUSAGECODE' field.
 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.
 SEGMENTATIONCODE nvarchar(10)   Default = '' A unique code that identifies the direct marketing effort.
 SEGMENTTESTCODE nvarchar(10)   Default = '' A unique test code that identifies the segment.

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier   BATCH.ID The batch this direct marketing effort row belongs to.
 SEGMENTATIONID uniqueidentifier MKTSEGMENTATION.ID The direct marketing effort for the row.
 BATCHDIRECTMARKETINGEFFORTSEGMENTID uniqueidentifier BATCHDIRECTMARKETINGEFFORTSEGMENT.ID The segment record in the corresponding batch.
 BATCHDIRECTMARKETINGEFFORTPACKAGEID uniqueidentifier BATCHDIRECTMARKETINGEFFORTPACKAGE.ID The package record in the corresponding batch.
 BATCHDIRECTMARKETINGEFFORTLISTID uniqueidentifier BATCHDIRECTMARKETINGEFFORTLIST.ID The list record in the corresponding batch.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 SEGMENTATIONCODEPARTDEFINITIONVALUESID uniqueidentifier MKTSOURCECODEPARTDEFINITIONVALUES.ID The source code part definition format value.
 BATCHDIRECTMARKETINGEFFORTTESTSEGMENTID uniqueidentifier BATCHDIRECTMARKETINGEFFORTTESTSEGMENT.ID The test segment record in the corresponding batch.
 SEGMENTTESTCODEPARTDEFINITIONVALUESID uniqueidentifier MKTSOURCECODEPARTDEFINITIONVALUES.ID The test source code part definition format value.
 RECORDSOURCEID uniqueidentifier MKTRECORDSOURCE.ID The record source for the list and segment records.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with the direct marketing effort.

Index Name Field(s) Unique Primary Clustered
 IX_BATCHDIRECTMARKETINGEFFORT_BASECURRENCYID BASECURRENCYID      
 IX_BATCHDIRECTMARKETINGEFFORT_BATCHDIRECTMARKETINGEFFORTLISTID BATCHDIRECTMARKETINGEFFORTLISTID      
 IX_BATCHDIRECTMARKETINGEFFORT_BATCHDIRECTMARKETINGEFFORTPACKAGEID BATCHDIRECTMARKETINGEFFORTPACKAGEID      
 IX_BATCHDIRECTMARKETINGEFFORT_BATCHDIRECTMARKETINGEFFORTSEGMENTID BATCHDIRECTMARKETINGEFFORTSEGMENTID      
 IX_BATCHDIRECTMARKETINGEFFORT_BATCHDIRECTMARKETINGEFFORTTESTSEGMENTID BATCHDIRECTMARKETINGEFFORTTESTSEGMENTID      
 IX_BATCHDIRECTMARKETINGEFFORT_BATCHID BATCHID      
 IX_BATCHDIRECTMARKETINGEFFORT_DATEADDED DATEADDED    
 IX_BATCHDIRECTMARKETINGEFFORT_DATECHANGED DATECHANGED      
 IX_BATCHDIRECTMARKETINGEFFORT_RECORDSOURCEID RECORDSOURCEID      
 IX_BATCHDIRECTMARKETINGEFFORT_SEGMENTATIONCODEPARTDEFINITIONVALUESID SEGMENTATIONCODEPARTDEFINITIONVALUESID      
 IX_BATCHDIRECTMARKETINGEFFORT_SEGMENTATIONID SEGMENTATIONID      
 IX_BATCHDIRECTMARKETINGEFFORT_SEGMENTTESTCODEPARTDEFINITIONVALUESID SEGMENTTESTCODEPARTDEFINITIONVALUESID      
 PK_BATCHDIRECTMARKETINGEFFORT ID  

Trigger Name Description
 TR_BATCHDIRECTMARKETINGEFFORT_INSERTUPDATE_CURRENCY
 TR_BATCHDIRECTMARKETINGEFFORT_AUDIT_UPDATE
 TR_BATCHDIRECTMARKETINGEFFORT_AUDIT_DELETE

Referenced by Field
 BATCHDIRECTMARKETINGEFFORTBATCHSYSTEMMESSAGES BATCHDIRECTMARKETINGEFFORTID
 BATCHDIRECTMARKETINGEFFORTBATCHUSERMESSAGE ID

Entity-Relationship diagram of this table