UFN_BBNC_GETCONSTITUENTBBNCUSERID

Returns the Blackbaud Internet Solutions user ID for the specified CONSTITUENT ID.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
@MAPID	int	IN

Definition

Copy


            CREATE function dbo.UFN_BBNC_GETCONSTITUENTBBNCUSERID(@CONSTITUENTID uniqueidentifier, @MAPID int) 
            returns int
            with execute as caller
            as begin
                if @CONSTITUENTID is null and coalesce(@MAPID,0) > 0
                        select 
                            @CONSTITUENTID = ID 
                        from
                            dbo.CONSTITUENT
                        where
                            CONSTITUENT.SEQUENCEID = @MAPID;

                return (
                    select top 1 [BBNCUSERID] from [dbo].[NETCOMMUNITYCLIENTUSER] where [CONSTITUENTID] = @CONSTITUENTID
                    )
            end