UFN_BBNCUSERMAP_GETBBNCUSERNAME

Returns the Blackbaud Internet Solutions user name mapped to the application user id.

Return

Return Type
nvarchar(50)

Parameters

Parameter Parameter Type Mode Description
@APPUSERID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_BBNCUSERMAP_GETBBNCUSERNAME(@APPUSERID uniqueidentifier)
returns nvarchar(50)

as 
/*
Returns the NetCommunity user name mapped to the application user id.
Returns null if there is no mapping for teh application user id.

Used by the BBNC shell integration.
*/

begin

    declare @U nvarchar(50);

    select @U = BBNCUSERNAME from dbo.BBNCUSERMAP where ID=@APPUSERID;

    return @U;

end