TR_RECURRINGGIFTINSTALLMENTWRITEOFF_DELETE_STATUSCODEUPDATE

                    CREATE trigger [dbo].[TR_RECURRINGGIFTINSTALLMENTWRITEOFF_DELETE_STATUSCODEUPDATE] on [dbo].[RECURRINGGIFTINSTALLMENTWRITEOFF] 
                    after delete 
                    not for replication
                    as
                    begin
                        set nocount on;

                        -- update the rg installment.statuscode to reflect writeoff/skip.  

                        -- if we are deleting a write-off or skip, the status would be past due or expected.

                        update rgi
                        set rgi.STATUSCODE = case when rgi.PASTDUEDATE is not null then 1 else 0 end,
                            rgi.CHANGEDBYID = del.CHANGEDBYID,
                            rgi.DATECHANGED = del.DATECHANGED
                        from dbo.RECURRINGGIFTINSTALLMENT rgi
                        inner join deleted del on del.RECURRINGGIFTINSTALLMENTID = rgi.ID
                    end