UFN_BBNC_GETDESIGNATIONIDFROMMAPID

Returns the DESIGNATION ID for the specified integer fund 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_GETDESIGNATIONIDFROMMAPID
            (
                @ID int
            )
            returns uniqueidentifier
            as
            begin
                return 
                (
                    select top 1 DESIGNATIONID
                    from dbo.BBNCDESIGNATIONIDMAP
                    where ID = @ID
                );
            end