UFN_STUDENTCOURSEREQUEST_GETEXCEPTIONTABLE

Returns a table of exceptions for a given student and course.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@STUDENTID	uniqueidentifier	IN
@COURSEID	uniqueidentifier	IN
@SESSIONID	uniqueidentifier	IN
@STARTTERMID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_STUDENTCOURSEREQUEST_GETEXCEPTIONTABLE
(
    @STUDENTID uniqueidentifier,
    @COURSEID uniqueidentifier, 
    @SESSIONID uniqueidentifier,
    @STARTTERMID uniqueidentifier
)
returns @RESULTS TABLE
(
    EXCEPTION nvarchar(20)
)
as
begin

    if dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEGENDER(@STUDENTID, @COURSEID) = 0 
        insert into @RESULTS
            select 'GENDER'

    if dbo.UFN_SCHEDULINGEXCEPTION_VALIDATESCHOOL(@STUDENTID, @COURSEID) = 0 
        insert into @RESULTS
            select 'SCHOOL'

    if dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEGRADELEVEL(@STUDENTID, @COURSEID) = 0
        insert into @RESULTS
            select 'GRADE_LEVEL'

    if dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEALREADYTAKEN(@STUDENTID, @COURSEID) = 0
        insert into @RESULTS
            select 'ALREADY_TAKEN'

    if dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEALREADYREQUESTED(@STUDENTID, @COURSEID, @SESSIONID) = 0
        insert into @RESULTS
            select 'ALREADY_REQUESTED'

    return 
end