UFN_BBNC_GETCODETABLEIDFROMMAPID

Returns a code table ID for the specified code table and integer mapping ID for Blackbaud Internet Solutions.

Return

Return Type
uniqueidentifier

Parameters

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

Definition

Copy



            CREATE function dbo.UFN_BBNC_GETCODETABLEIDFROMMAPID
            (
                @CODETABLECATALOGID uniqueidentifier,
                @MAPID int
            )
            returns uniqueidentifier
            as
            begin
                return 
                (
                    select top 1 TABLEENTRYID
                    from dbo.BBNCCODETABLEIDMAP
                    where CODETABLECATALOGID = @CODETABLECATALOGID
                    and ID = @MAPID
                );
            end