TR_ADJUSTMENTHISTORYDETAIL_AUDIT_DELETE

Trigger Definition

/* 
Generated by Blackbaud AppFx Platform
Date:  9/5/2012 3:31:19 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.95.390.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE TRIGGER dbo.TR_ADJUSTMENTHISTORYDETAIL_AUDIT_DELETE ON dbo.ADJUSTMENTHISTORYDETAIL 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('ADJUSTMENTHISTORYDETAIL') = 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.ADJUSTMENTHISTORYDETAILAUDIT(
			AUDITRECORDID, 
			AUDITKEY,
			AUDITCHANGEAGENTID,
			AUDITDATE, 
			AUDITTYPECODE,
			[ADJUSTMENTHISTORYID],
			[ADJUSTEDFIELD],
			[ADJUSTEDFIELDPREVIOUSVALUE],
			[ADJUSTEDFIELDADJUSTEDVALUE],
			[ADDEDBYID],
			[CHANGEDBYID],
			[DATEADDED],
			[DATECHANGED],
			[ISMONEY],
			[ADJUSTEDFIELDPREVIOUSMONEYVALUE],
			[ADJUSTEDFIELDADJUSTEDMONEYVALUE],
			[TRANSACTIONADJUSTEDFIELDPREVIOUSVALUE],
			[TRANSACTIONADJUSTEDFIELDADJUSTEDVALUE],
			[TRANSACTIONADJUSTEDFIELDPREVIOUSMONEYVALUE],
			[TRANSACTIONADJUSTEDFIELDADJUSTEDMONEYVALUE],
			[ORGANIZATIONADJUSTEDFIELDPREVIOUSVALUE],
			[ORGANIZATIONADJUSTEDFIELDADJUSTEDVALUE],
			[ORGANIZATIONADJUSTEDFIELDPREVIOUSMONEYVALUE],
			[ORGANIZATIONADJUSTEDFIELDADJUSTEDMONEYVALUE],
			[BASECURRENCYID],
			[TRANSACTIONCURRENCYID]
		) 
		SELECT 
			ID,
			@AuditKey,
			@ChangeAgentID,
			@AuditDate,
			2, --Before DELETE
			[ADJUSTMENTHISTORYID],
			[ADJUSTEDFIELD],
			[ADJUSTEDFIELDPREVIOUSVALUE],
			[ADJUSTEDFIELDADJUSTEDVALUE],
			[ADDEDBYID],
			[CHANGEDBYID],
			[DATEADDED],
			[DATECHANGED],
			[ISMONEY],
			[ADJUSTEDFIELDPREVIOUSMONEYVALUE],
			[ADJUSTEDFIELDADJUSTEDMONEYVALUE],
			[TRANSACTIONADJUSTEDFIELDPREVIOUSVALUE],
			[TRANSACTIONADJUSTEDFIELDADJUSTEDVALUE],
			[TRANSACTIONADJUSTEDFIELDPREVIOUSMONEYVALUE],
			[TRANSACTIONADJUSTEDFIELDADJUSTEDMONEYVALUE],
			[ORGANIZATIONADJUSTEDFIELDPREVIOUSVALUE],
			[ORGANIZATIONADJUSTEDFIELDADJUSTEDVALUE],
			[ORGANIZATIONADJUSTEDFIELDPREVIOUSMONEYVALUE],
			[ORGANIZATIONADJUSTEDFIELDADJUSTEDMONEYVALUE],
			[BASECURRENCYID],
			[TRANSACTIONCURRENCYID]

		FROM DELETED

		
	end