UFN_STUDENTCURRENTSTATUS_GETNAME

Returns the current enrollment status names for a given student

Return

Return Type
nvarchar(200)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_STUDENTCURRENTSTATUS_GETNAME(@ID uniqueidentifier) returns nvarchar(200) 
        with execute as caller
        as begin
            declare @statusnames nvarchar(200);

            set @statusnames = ''
            select @statusnames = CASE @statusnames WHEN '' THEN dbo.EDUCATIONALHISTORYSTATUS.[DESCRIPTION] ELSE @statusnames + '; ' + dbo.EDUCATIONALHISTORYSTATUS.[DESCRIPTION] END
            from dbo.UFN_STUDENTENROLLMENT_CURRENTINFORMATION(@ID) as CURRENTINFO
            inner join dbo.EDUCATIONALHISTORYSTATUS on CURRENTINFO.[EDUCATIONALHISTORYSTATUSID] = dbo.EDUCATIONALHISTORYSTATUS.[ID]
            group by dbo.EDUCATIONALHISTORYSTATUS.[DESCRIPTION]

            return @statusnames
        end