TR_REVENUERECOGNITION_MARKASCONSTITUENT

                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