TR_REVENUELIFECYCLE_DELETE (Trigger)

                
                    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