UFN_CONSTITUENT_GETALUMNUSSTATUSTEXT

This function returns the alumnus status text for a constituent.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CONSTITUENT_GETALUMNUSSTATUSTEXT(@CONSTITUENTID uniqueidentifier)
            returns nvarchar(100)
            with execute as caller
            as begin
                return case 
            when (dbo.UFN_CONSTITUENT_ISALUMNUS(@CONSTITUENTID) = 1) then dbo.UFN_CONSTITUENCY_GETDESCRIPTION('46EC3424-BA54-4431-A7DC-C6CEBB3B4592') --Alumnus

                        when (dbo.UFN_CONSTITUENT_ISSTUDENT(@CONSTITUENTID) = 1) then dbo.UFN_CONSTITUENCY_GETDESCRIPTION('4DB8F4FC-BC43-421D-B592-69BEF109B5FC') --Student

                        else null end;
            end