TR_MKTSPONSORSHIPMAILINGTEMPLATERULE_AUDIT_DELETE

Trigger Definition

/* 
Generated by Blackbaud AppFx Platform
Date:  4/18/2014 1:06:13 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.516.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE TRIGGER dbo.TR_MKTSPONSORSHIPMAILINGTEMPLATERULE_AUDIT_DELETE ON dbo.MKTSPONSORSHIPMAILINGTEMPLATERULE 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('MKTSPONSORSHIPMAILINGTEMPLATERULE') = 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.MKTSPONSORSHIPMAILINGTEMPLATERULEAUDIT(
			AUDITRECORDID, 
			AUDITKEY,
			AUDITCHANGEAGENTID,
			AUDITDATE, 
			AUDITTYPECODE,
			[SPONSORSHIPMAILINGTEMPLATEID],
			[SEGMENTID],
			[CODE],
			[TESTSEGMENTCODE],
			[PACKAGEID],
			[RESPONSERATE],
			[GIFTAMOUNT],
			[SEQUENCE],
			[ASKLADDERID],
			[ADDEDBYID],
			[CHANGEDBYID],
			[DATEADDED],
			[DATECHANGED],
			[PARTDEFINITIONVALUESID],
			[TESTPARTDEFINITIONVALUESID],
			[OVERRIDEADDRESSPROCESSING],
			[USEADDRESSPROCESSING],
			[ADDRESSPROCESSINGOPTIONID],
			[ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE],
			[ADDRESSPROCESSINGOPTIONSEASONALASOFDATE],
			[NAMEFORMATPARAMETERID],
			[BASECURRENCYID],
			[ORGANIZATIONGIFTAMOUNT],
			[CURRENCYEXCHANGERATEID],
			[EXCLUDE]
		) 
		SELECT 
			ID,
			@AuditKey,
			@ChangeAgentID,
			@AuditDate,
			2, --Before DELETE
			[SPONSORSHIPMAILINGTEMPLATEID],
			[SEGMENTID],
			[CODE],
			[TESTSEGMENTCODE],
			[PACKAGEID],
			[RESPONSERATE],
			[GIFTAMOUNT],
			[SEQUENCE],
			[ASKLADDERID],
			[ADDEDBYID],
			[CHANGEDBYID],
			[DATEADDED],
			[DATECHANGED],
			[PARTDEFINITIONVALUESID],
			[TESTPARTDEFINITIONVALUESID],
			[OVERRIDEADDRESSPROCESSING],
			[USEADDRESSPROCESSING],
			[ADDRESSPROCESSINGOPTIONID],
			[ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE],
			[ADDRESSPROCESSINGOPTIONSEASONALASOFDATE],
			[NAMEFORMATPARAMETERID],
			[BASECURRENCYID],
			[ORGANIZATIONGIFTAMOUNT],
			[CURRENCYEXCHANGERATEID],
			[EXCLUDE]

		FROM DELETED

		
	end