UFN_SCHEDULINGEXCEPTION_VALIDATESCHOOL

Validates that the student school matches that of the requested course in a multiple school system.

Return

Return Type
bit

Parameters

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

Definition

Copy



CREATE function dbo.UFN_SCHEDULINGEXCEPTION_VALIDATESCHOOL
(
    @STUDENTID uniqueidentifier,
    @COURSEID uniqueidentifier
)
returns bit
as 
begin
    declare @SCHOOLVALID bit = 1    

    if (select DIFFERENTSCHOOL from dbo.SCHEDULINGEXCEPTION) = 1
    begin
        --only check for non single school systems

        if dbo.UFN_SCHOOL_ISSINGLESCHOOL() <> 1 and 
           ((select SCHOOLID 
                from dbo.UFN_STUDENTPROGRESSION_CURRENTINFORMATION(@STUDENTID)) <> 
            (select SCHOOLID 
                from dbo.COURSE where ID = @COURSEID))
            set @SCHOOLVALID = 0
    end
    return @SCHOOLVALID
end