UFN_SCHEDULINGEXCEPTION_VALIDATEGRADELEVEL

Validates that the student grade level matches one of those selected on the requested course.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTID	uniqueidentifier	IN
@COURSEID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEGRADELEVEL
(
    @STUDENTID uniqueidentifier,
    @COURSEID uniqueidentifier
)
returns bit
as 
begin
    declare @GRADELEVELVALID bit = 1    

    if (select DIFFERENTGRADELEVEL from dbo.SCHEDULINGEXCEPTION) = 1
    begin
        declare @GRADELEVELID uniqueidentifier
        select @GRADELEVELID = GRADELEVEL.ID
                from dbo.EDUCATIONALHISTORY
                    inner join dbo.STUDENTPROGRESSION on EDUCATIONALHISTORY.ID = STUDENTPROGRESSION.ENROLLMENTID
                    inner join dbo.SCHOOLGRADELEVEL on STUDENTPROGRESSION.SCHOOLGRADELEVELID = SCHOOLGRADELEVEL.ID
                    inner join dbo.GRADELEVEL on SCHOOLGRADELEVEL.GRADELEVELID = GRADELEVEL.ID
                where EDUCATIONALHISTORY.CONSTITUENTID = @STUDENTID

        if (@GRADELEVELID) not in (select SCHOOLGRADELEVEL.GRADELEVELID 
                                    from dbo.COURSEGRADELEVEL 
                                    inner join dbo.SCHOOLGRADELEVEL 
                                        on COURSEGRADELEVEL.SCHOOLGRADELEVELID = SCHOOLGRADELEVEL.ID 
                                    where COURSEID = @COURSEID)
            set @GRADELEVELVALID = 0
    end
    return @GRADELEVELVALID
end