UFN_EDUCATIONALINSTITUTION_GETNAMEFROMCONSTITUENT

Gets the name of the educational institution from the associated organization.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@EDUCATIONALINSTITUTIONID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_EDUCATIONALINSTITUTION_GETNAMEFROMCONSTITUENT
      (
        @EDUCATIONALINSTITUTIONID uniqueidentifier
      )
      returns nvarchar(100)
      with execute as caller
      as begin
          declare @RETVAL nvarchar(100);

        select @RETVAL = CONSTITUENT.NAME
        from dbo.CONSTITUENT
        where CONSTITUENT.ID = @EDUCATIONALINSTITUTIONID;

          return @RETVAL;
      end