USP_RE7INTEGRATION_UNDO_INTEGRATION

                    CREATE procedure dbo.USP_RE7INTEGRATION_UNDO_INTEGRATION
                    (
                        @CHANGEAGENTID uniqueidentifier = null
                    )
                    as begin
              set nocount on;

              delete from dbo.RE7INTEGRATIONCONFIGURATION;
              delete from dbo.RE7INTEGRATIONCONSTITUENTMAP;
              delete from dbo.RE7INTEGRATIONCREDENTIALS;
              delete from dbo.RE7INTEGRATIONGIVINGSUMMARY;
              delete from dbo.RE7INTEGRATIONPHONEMAP;

              update dbo.CONSTITUENT set CUSTOMIDENTIFIER = '' 
              where len(CUSTOMIDENTIFIER) > 0;

              exec dbo.USP_CONDITIONSETTING_DELETEBYNAME_WITHCHANGEAGENTID N'RE7Integration', @CHANGEAGENTID;
                        return 0;

                    end