USP_RECORDOPERATION_MODELSCORESGLOBALDELETE

create procedure dbo.USP_RECORDOPERATION_MODELSCORESGLOBALDELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

  --Modeling and Propensity is set back to default value. Guids need to be updated here, in the prompt, and in the ModelScoresPropensityAndRatings.SimpleList.vb.

    if(@ID = '10000000-0000-0000-0000-000000000000')
        update dbo.MODELINGANDPROPENSITY set ANNUALGIFTLIKELIHOOD = -1;
    else if(@ID = '20000000-0000-0000-0000-000000000000')
        update dbo.MODELINGANDPROPENSITY set ANNUITYLIKELIHOOD = -1;
    else if(@ID = '30000000-0000-0000-0000-000000000000')
        update dbo.MODELINGANDPROPENSITY set BEQUESTLIKELIHOOD = -1;
    else if(@ID = '40000000-0000-0000-0000-000000000000')
        update dbo.MODELINGANDPROPENSITY set CRTLIKELIHOOD = -1;
    else if(@ID = '50000000-0000-0000-0000-000000000000')
        update dbo.MODELINGANDPROPENSITY set MAJORGIVINGLIKELIHOOD = -1;
    else if(@ID = '60000000-0000-0000-0000-000000000000')
        update dbo.MODELINGANDPROPENSITY set MEMBERSHIPLIKELIHOOD = -1;
    else if(@ID = '70000000-0000-0000-0000-000000000000')
    update dbo.MODELINGANDPROPENSITY set ONLINEGIVINGLIKELIHOOD = -1;
  else if(@ID = '80000000-0000-0000-0000-000000000000')
    update dbo.MODELINGANDPROPENSITY set PATIENTRESPONSELIKELIHOOD = -1;
  else if(@ID = '90000000-0000-0000-0000-000000000000')
    update dbo.MODELINGANDPROPENSITY set PLANNEDGIFTLIKELIHOOD = -1;
  else if(@ID = 'A0000000-0000-0000-0000-000000000000')
    update dbo.MODELINGANDPROPENSITY set SUGGESTEDMEMBERSHIPLEVELID = null;
  else if(@ID = 'B0000000-0000-0000-0000-000000000000')
    update dbo.MODELINGANDPROPENSITY set NCOAMOVEDINDICATOR = 0;
  else if(@ID = 'C0000000-0000-0000-0000-000000000000')
    update dbo.MODELINGANDPROPENSITY set WEALTHESTIMATORRATINGID = null;
  else if(@ID = 'D0000000-0000-0000-0000-000000000000')
        update dbo.MODELINGANDPROPENSITY set TARGETGIFTRANGEID = null;
  --Attributes require a dynamic delete using the guid to find their specific table.

    else
    begin
    declare @ATTRIBUTEID nvarchar(32) = REPLACE(CAST(@ID as nvarchar(36)), '-', '');
    declare @ATTRIBUTECLEARSQL nvarchar(200) = REPLACE('delete from dbo.ATTRIBUTE{0}', '{0}', @ATTRIBUTEID);
    execute sp_executesql @ATTRIBUTECLEARSQL;
  end
    return 0;

end