USP_BBAMODELINGANDPROPENSITYFILEIMPORT_DELETE

This procedure is used by the Target Analytics Modeling and Propensity File Import Record Operation for saving the cleaning up failed rows from a Target Analytics Modeling and Propensity Import File.

Parameters

Parameter	Parameter Type	Mode
@IMPORTID	nvarchar(100)	IN
@RESEARCHGROUPNAME	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_BBAMODELINGANDPROPENSITYFILEIMPORT_DELETE(
                @IMPORTID  nvarchar(100) = '',
                @RESEARCHGROUPNAME nvarchar(100) = '',
                @CHANGEAGENTID uniqueidentifier
            ) as
                set nocount on;

                declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                begin try
                    declare @CONSTITUENTID uniqueidentifier;                    
                    select
                        @CONSTITUENTID = C.ID
                    from
                        dbo.CONSTITUENT C
                    left join
                        dbo.TAIMPORTIDMAP
                    on
                        TAIMPORTIDMAP.ID = C.ID
                    where
                        TAIMPORTIDMAP.LOOKUPID = @IMPORTID;

                    if @CONSTITUENTID is not null begin
                        exec dbo.USP_MODELINGANDPROPENSITY_DELETEBYID_WITHCHANGEAGENTID @CONSTITUENTID, @CHANGEAGENTID;

                        declare @RESEARCHGROUPMEMBERID uniqueidentifier;
                        set @RESEARCHGROUPMEMBERID = null;

                        declare @RESEARCHGROUPID uniqueidentifier;
                        set @RESEARCHGROUPID = null;

                        select
                            @RESEARCHGROUPMEMBERID = RGM.ID,
                            @RESEARCHGROUPID = RG.ID
                        from
                            dbo.RESEARCHGROUPMEMBER RGM
                        left join
                            dbo.RESEARCHGROUP RG on RG.ID = RGM.RESEARCHGROUPID
                        where
                            RGM.CONSTITUENTID = @CONSTITUENTID and
                            RG.NAME = @RESEARCHGROUPNAME;

                        if @RESEARCHGROUPMEMBERID is not null begin
                            exec dbo.USP_RESEARCHGROUPMEMBER_DELETEBYID_WITHCHANGEAGENTID @RESEARCHGROUPMEMBERID, @CHANGEAGENTID;
                            exec dbo.USP_RESEARCHGROUP_INCREMENTNUMMEMBERS @RESEARCHGROUPID, -1, @CHANGEAGENTID;
                        end
                    end
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;