BATCHDIRECTMARKETINGEFFORT

Stores Direct Marketing Effort batch information.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

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)	yes	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)	yes	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)	yes	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)	yes	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 Keys

Foreign Key	Field Type	Null	Notes	Description
BATCHID	uniqueidentifier		BATCH.ID	The batch this direct marketing effort row belongs to.
SEGMENTATIONID	uniqueidentifier	yes	MKTSEGMENTATION.ID	The direct marketing effort for the row.
BATCHDIRECTMARKETINGEFFORTSEGMENTID	uniqueidentifier	yes	BATCHDIRECTMARKETINGEFFORTSEGMENT.ID	The segment record in the corresponding batch.
BATCHDIRECTMARKETINGEFFORTPACKAGEID	uniqueidentifier	yes	BATCHDIRECTMARKETINGEFFORTPACKAGE.ID	The package record in the corresponding batch.
BATCHDIRECTMARKETINGEFFORTLISTID	uniqueidentifier	yes	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	yes	MKTSOURCECODEPARTDEFINITIONVALUES.ID	The source code part definition format value.
BATCHDIRECTMARKETINGEFFORTTESTSEGMENTID	uniqueidentifier	yes	BATCHDIRECTMARKETINGEFFORTTESTSEGMENT.ID	The test segment record in the corresponding batch.
SEGMENTTESTCODEPARTDEFINITIONVALUESID	uniqueidentifier	yes	MKTSOURCECODEPARTDEFINITIONVALUES.ID	The test source code part definition format value.
RECORDSOURCEID	uniqueidentifier	yes	MKTRECORDSOURCE.ID	The record source for the list and segment records.
BASECURRENCYID	uniqueidentifier	yes	CURRENCY.ID	The base currency associated with the direct marketing effort.

Indexes

Index Name	Fields	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			yes
IX_BATCHDIRECTMARKETINGEFFORT_DATECHANGED	DATECHANGED
IX_BATCHDIRECTMARKETINGEFFORT_RECORDSOURCEID	RECORDSOURCEID
IX_BATCHDIRECTMARKETINGEFFORT_SEGMENTATIONCODEPARTDEFINITIONVALUESID	SEGMENTATIONCODEPARTDEFINITIONVALUESID
IX_BATCHDIRECTMARKETINGEFFORT_SEGMENTATIONID	SEGMENTATIONID
IX_BATCHDIRECTMARKETINGEFFORT_SEGMENTTESTCODEPARTDEFINITIONVALUESID	SEGMENTTESTCODEPARTDEFINITIONVALUESID
PK_BATCHDIRECTMARKETINGEFFORT	ID	yes	yes

Triggers

Trigger Name	Description
TR_BATCHDIRECTMARKETINGEFFORT_INSERTUPDATE_CURRENCY
TR_BATCHDIRECTMARKETINGEFFORT_AUDIT_UPDATE
TR_BATCHDIRECTMARKETINGEFFORT_AUDIT_DELETE

Referenced by

Referenced by	Field
BATCHDIRECTMARKETINGEFFORTBATCHSYSTEMMESSAGES	BATCHDIRECTMARKETINGEFFORTID
BATCHDIRECTMARKETINGEFFORTBATCHUSERMESSAGE	ID