UFN_TERM_INUSE

Returns true if the provided term is being used on other records.
Return

Return Type
bit
Parameters

Parameter	Parameter Type	Mode	Description
@TERMID	uniqueidentifier	IN
Definition

Copy



            CREATE function dbo.UFN_TERM_INUSE
            (
                @TERMID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                declare @RETVAL bit = 0;
                    -- add any tables that use term dates


                    -- Course Grading

                    if exists 
                        (select * 
                            from dbo.V_COURSEGRADING as COURSEGRADING
                                join dbo.COURSE on COURSEGRADING.COURSEID = COURSE.ID
                            where dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, COURSEGRADING.STARTDATE, COURSEGRADING.ENDDATE) = (SELECT SESSIONID FROM TERM WHERE ID = @TERMID))
                        set @RETVAL = 1;

                    -- Course Restrictions

                    if @RETVAL = 0 and exists 
                        (select * 
                            from dbo.V_COURSERESTRICTION as COURSERESTRICTION 
                                join dbo.COURSE on COURSERESTRICTION.COURSEID = COURSE.ID
                            where dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, COURSERESTRICTION.STARTDATE, COURSERESTRICTION.ENDDATE) = (SELECT SESSIONID FROM TERM WHERE ID = @TERMID))
                        set @RETVAL = 1;           

                return @RETVAL;
            end