![]() |
---|
/* Generated by Blackbaud AppFx Platform Date: 3/18/2013 6:21:43 PM Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null Copyright Blackbaud */ CREATE TRIGGER dbo.TR_MKTSEGMENTATIONSEGMENT_AUDIT_DELETE ON dbo.MKTSEGMENTATIONSEGMENT AFTER DELETE NOT FOR REPLICATION AS declare @ChangeAgentID uniqueidentifier declare @AuditKey uniqueidentifier declare @AuditDate datetime set nocount on --peform the audit if dbo.UFN_AUDITENABLED('MKTSEGMENTATIONSEGMENT') = 1 begin -- the audit key is used to associate the rows in the audit table with a single atomic deletion/modification -- for a delete, set @AuditKey = NewID() set @AuditDate = GetDate() --Get the change agent from the CONTEXT_INFO. If an application wishes to mark a row as deleted by a non-default changeagent then it will have to update the auditrow after the delete using the ID field (where AUDITTYPECODE=2) exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENTFROMCONTEXT @ChangeAgentID output INSERT INTO dbo.MKTSEGMENTATIONSEGMENTAUDIT( AUDITRECORDID, AUDITKEY, AUDITCHANGEAGENTID, AUDITDATE, AUDITTYPECODE, [SEGMENTATIONID], [MARKETINGPLANBRIEFID], [SEGMENTID], [CODE], [PACKAGEID], [RESPONSERATE], [GIFTAMOUNT], [SAMPLESIZE], [SAMPLESIZETYPECODE], [SAMPLESIZEMETHODCODE], [SEQUENCE], [NEXTBRIEFSEQUENCE], [COLLAPSED], [ADDEDBYID], [CHANGEDBYID], [DATEADDED], [DATECHANGED], [ASKLADDERID], [SAMPLESIZEEXCLUDEREMAINDER], [USAGECODE], [TESTSEGMENTCODE], [OVERRIDEADDRESSPROCESSING], [USEADDRESSPROCESSING], [ADDRESSPROCESSINGOPTIONID], [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE], [ADDRESSPROCESSINGOPTIONSEASONALASOFDATE], [NAMEFORMATPARAMETERID], [PARTDEFINITIONVALUESID], [TESTPARTDEFINITIONVALUESID], [EXPOSURESTARTDATE], [EXPOSUREENDDATE], [EXCLUDESPOUSE], [OVERRIDEBUSINESSUNITS], [BASECURRENCYID], [ORGANIZATIONGIFTAMOUNT], [CURRENCYEXCHANGERATEID], [EXCLUDE], [HISTORICALQUANTITY] ) SELECT ID, @AuditKey, @ChangeAgentID, @AuditDate, 2, --Before DELETE [SEGMENTATIONID], [MARKETINGPLANBRIEFID], [SEGMENTID], [CODE], [PACKAGEID], [RESPONSERATE], [GIFTAMOUNT], [SAMPLESIZE], [SAMPLESIZETYPECODE], [SAMPLESIZEMETHODCODE], [SEQUENCE], [NEXTBRIEFSEQUENCE], [COLLAPSED], [ADDEDBYID], [CHANGEDBYID], [DATEADDED], [DATECHANGED], [ASKLADDERID], [SAMPLESIZEEXCLUDEREMAINDER], [USAGECODE], [TESTSEGMENTCODE], [OVERRIDEADDRESSPROCESSING], [USEADDRESSPROCESSING], [ADDRESSPROCESSINGOPTIONID], [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE], [ADDRESSPROCESSINGOPTIONSEASONALASOFDATE], [NAMEFORMATPARAMETERID], [PARTDEFINITIONVALUESID], [TESTPARTDEFINITIONVALUESID], [EXPOSURESTARTDATE], [EXPOSUREENDDATE], [EXCLUDESPOUSE], [OVERRIDEBUSINESSUNITS], [BASECURRENCYID], [ORGANIZATIONGIFTAMOUNT], [CURRENCYEXCHANGERATEID], [EXCLUDE], [HISTORICALQUANTITY] FROM DELETED end |