UFN_BBNC_GETDESIGNATIONMAPID

Returns the integer fund mapping ID for the specified DESIGNATION ID for Blackbaud Internet Solutions.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_GETDESIGNATIONMAPID
            (
                @DESIGNATIONID uniqueidentifier
            )
            returns int
            as
            begin
                return 
                (
                    select top 1 ID
                    from dbo.BBNCDESIGNATIONIDMAP
                    where DESIGNATIONID = @DESIGNATIONID
                );
            end