TR_RECURRINGGIFTINSTALLMENTPAYMENT_INSERT_STATUSCODEUPDATE

                    CREATE trigger [dbo].[TR_RECURRINGGIFTINSTALLMENTPAYMENT_INSERT_STATUSCODEUPDATE] on [dbo].[RECURRINGGIFTINSTALLMENTPAYMENT] 
                    after insert
                    not for replication
                    as
                    begin
                        set nocount on;

                        -- update the rg installment.statuscode to reflect payment

                        update rgi
                        set rgi.STATUSCODE = case when ins.AMOUNT = rgi.AMOUNT then 2 else dbo.UFN_RECURRINGGIFTINSTALLMENT_DETERMINESTATUSAFTERCHANGE(rgi.ID,rgi.STATUSCODE,1) end,
                            rgi.CHANGEDBYID = ins.CHANGEDBYID,
                            rgi.DATECHANGED = ins.DATECHANGED
                        from dbo.RECURRINGGIFTINSTALLMENT rgi
                        inner join inserted ins on ins.RECURRINGGIFTINSTALLMENTID = rgi.ID
                    end