UFN_EDUCATIONALHISTORY_GETGRADELEVELENROLLED

Returns the grade level enrolled for an education record based on student progressions

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@EDUCATIONALHISTORYID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_EDUCATIONALHISTORY_GETGRADELEVELENROLLED(
            @EDUCATIONALHISTORYID uniqueidentifier
        )
        returns uniqueidentifier
        with execute as caller
        as begin
            declare @GRADELEVELENROLLEDID uniqueidentifier

            set @GRADELEVELENROLLEDID = (SELECT TOP 1 (dbo.SCHOOLGRADELEVEL.[GRADELEVELID])
            FROM dbo.EDUCATIONALHISTORY
            INNER JOIN dbo.STUDENTPROGRESSION on dbo.EDUCATIONALHISTORY.[ID] = dbo.STUDENTPROGRESSION.[ENROLLMENTID]
            INNER JOIN dbo.SCHOOLGRADELEVEL on dbo.STUDENTPROGRESSION.[SCHOOLGRADELEVELID] =  dbo.SCHOOLGRADELEVEL.[ID]
            WHERE dbo.EDUCATIONALHISTORY.[ID] = @EDUCATIONALHISTORYID
            ORDER BY STUDENTPROGRESSION.[STARTDATE])

            if  @GRADELEVELENROLLEDID is null 
            begin 
                SELECT @GRADELEVELENROLLEDID = dbo.EDUCATIONALHISTORY.[GRADELEVELENROLLEDID] 
                FROM dbo.EDUCATIONALHISTORY 
                WHERE dbo.EDUCATIONALHISTORY.[ID] = @EDUCATIONALHISTORYID
            end

            return @GRADELEVELENROLLEDID
        end