USP_CONSTITUENTDATAREVIEW_EMAILADDRESS_CHECKGUIDS

Checks the values of foreign key fields during rollback in constituent data review.

Parameters

Parameter	Parameter Type	Mode
@INVALIDFIELDS	nvarchar(256)	INOUT
@EMAILADDRESSTYPECODEID	uniqueidentifier	INOUT
@INFOSOURCECODEID	uniqueidentifier	INOUT

Definition

Copy



create procedure dbo.USP_CONSTITUENTDATAREVIEW_EMAILADDRESS_CHECKGUIDS (
    @INVALIDFIELDS nvarchar(256) output,
    @EMAILADDRESSTYPECODEID uniqueidentifier = null output,
    @INFOSOURCECODEID uniqueidentifier = null output
)
as
begin
    declare @C tinyint;

    set @INVALIDFIELDS = '';

    if @EMAILADDRESSTYPECODEID is not null
    begin
        select @C = count(*)
        from dbo.EMAILADDRESSTYPECODE
        where ID = @EMAILADDRESSTYPECODEID;

        if @C = 0
        begin
            set @INVALIDFIELDS = @INVALIDFIELDS + ',Type';
            set @EMAILADDRESSTYPECODEID = null;
        end
    end

    if @INFOSOURCECODEID is not null
    begin
        select @C = count(*)
        from dbo.INFOSOURCECODE
        where ID = @INFOSOURCECODEID;

        if @C = 0
        begin
            set @INVALIDFIELDS = @INVALIDFIELDS + ',Information source';
            set @INFOSOURCECODEID = null;
        end
    end

    if @INVALIDFIELDS <> ''
        set @INVALIDFIELDS = substring(@INVALIDFIELDS,2,len(@INVALIDFIELDS)-1);
end