UFN_SCHEDULEDATE_GETTERM

                create function dbo.UFN_SCHEDULEDATE_GETTERM
                (
                    @DATE date,
                    @SCHOOLID uniqueidentifier
                )
                returns uniqueidentifier
                as
                begin
                    declare @TERMID uniqueidentifier

                    select @TERMID = TERM.ID
                    from TERM
                    inner join SESSION
                        on SESSION.ID = TERM.SESSIONID
                    inner join ACADEMICYEAR
                        on ACADEMICYEAR.ID = SESSION.ACADEMICYEARID
                    where ACADEMICYEAR.SCHOOLID = @SCHOOLID AND 
                        @DATE >= TERM.STARTDATE AND @DATE <= TERM.ENDDATE

                    return @TERMID
                end