TR_REVENUELIFECYCLE_DELETE

                    CREATE trigger [dbo].[TR_REVENUELIFECYCLE_DELETE] on [dbo].[REVENUELIFECYCLE] after delete not for replication as
                    begin
                        set nocount on

                        insert into dbo.REVENUELIFECYCLEHISTORY 
                            (CONSTITUENTID, LIFECYCLETYPEID, DONORSTATECODE, STARTDATE, ENDDATE, ADDEDBYID, CHANGEDBYID)
                            (select 
                                DELETED.CONSTITUENTID, 
                                DELETED.LIFECYCLETYPEID, 
                                DELETED.DONORSTATECODE, 
                                DELETED.STARTDATE, 
                                getdate(),
                                DELETED.CHANGEDBYID,
                                DELETED.CHANGEDBYID
                            from 
                                DELETED
                                inner join dbo.CONSTITUENT on CONSTITUENT.ID = DELETED.CONSTITUENTID
                            )                                                            
                    end