CREATE trigger dbo.TR_REVENUERECOGNITION_MARKASCONSTITUENT
on dbo.REVENUERECOGNITION
after insert, update
not for replication
as begin
if update(CONSTITUENTID)
begin
update dbo.CONSTITUENT
set ISCONSTITUENT = 1,
CHANGEDBYID = inserted.CHANGEDBYID,
DATECHANGED = GetDate()
from inserted
inner join dbo.REVENUESPLIT
on inserted.REVENUESPLITID = REVENUESPLIT.ID
inner join dbo.REVENUE
on REVENUESPLIT.REVENUEID = REVENUE.ID
where (CONSTITUENT.ID = inserted.CONSTITUENTID) and
(CONSTITUENT.ISCONSTITUENT = 0) and
((REVENUE.TRANSACTIONTYPECODE = 1) or
-- include gifts to event registrations
(REVENUE.TRANSACTIONTYPECODE = 0 and (REVENUESPLIT.APPLICATIONCODE in (0,3) or (REVENUESPLIT.APPLICATIONCODE = 1 and REVENUESPLIT.TYPECODE = 0))) or
(REVENUE.TRANSACTIONTYPECODE = 5 and REVENUESPLIT.TYPECODE = 0) or
(REVENUE.TRANSACTIONTYPECODE = 7));
end
end
|
Trigger Definition
