UFN_BBNC_EDUCATIONALINVOLVEMENTNAME_GETID

Returns the EDUCATIONAL INVOLVEMENT NAME ID for the specified name and educationalinvolvementtypecode id for Blackbaud Internet Solutions.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@EDUCATIONALINVOLVEMENTTYPECODEID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_EDUCATIONALINVOLVEMENTNAME_GETID(@EDUCATIONALINVOLVEMENTTYPECODEID uniqueidentifier, @NAME nvarchar(100)) 
            returns uniqueidentifier
            as begin
                return (
                    select ID
                    from dbo.EDUCATIONALINVOLVEMENTNAME
                    where NAME = @NAME
            and EDUCATIONALINVOLVEMENTTYPECODEID = @EDUCATIONALINVOLVEMENTTYPECODEID
                    )
            end