USP_BBACONSTITUENTFILEIMPORT_UPDATECUSTOMIDENTIFIERFROMBBAID

This procedure is used by the Target Analytics Constituent File Import Record Operation to update the CUSTOMIDENTIFIER field in the CONSTITUENT table to be the BBAID.

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@BBAID	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_BBACONSTITUENTFILEIMPORT_UPDATECUSTOMIDENTIFIERFROMBBAID(
                @CONSTITUENTID uniqueidentifier,
                @BBAID 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
                    --remove any entries that are already using the given IDMAP entry

                    delete
                        dbo.BBAIDMAP
                    where
                        CUSTOMIDENTIFIER = @BBAID and
                        ID <> @CONSTITUENTID;

                    if exists (select ID from dbo.BBAIDMAP where ID = @CONSTITUENTID) begin
                        update
                            dbo.TAIMPORTIDMAP
                        set
                            CUSTOMIDENTIFIER = @BBAID,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where
                            ID = @CONSTITUENTID;
                    end
                    else begin
                        insert into dbo.TAIMPORTIDMAP (
                            ID,
                            CUSTOMIDENTIFIER,
                            ADDEDBYID,
                            CHANGEDBYID,
                            DATEADDED,
                            DATECHANGED
                        )
                        values (
                            @CONSTITUENTID,
                            @BBAID,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );
                    end
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;