UFN_BBNC_GETCONSTITIDFROMMAPID

Returns the CONSTITUENT ID for the specified integer mapping ID for Blackbaud Internet Solutions.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_GETCONSTITIDFROMMAPID(@ID int) 
            returns uniqueidentifier
            as begin
                return (
                    select top 1 ID
                    from dbo.CONSTITUENT
                    where SEQUENCEID = @ID
                    )
            end