UFN_STUDENTCOURSEREQUEST_GETEXCEPTIONLIST

Returns a comma delimited list 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_GETEXCEPTIONLIST
(
    @STUDENTID uniqueidentifier,
    @COURSEID uniqueidentifier, 
    @SESSIONID uniqueidentifier,
    @STARTTERMID uniqueidentifier
)
returns @RESULTS TABLE
(
    EXCEPTIONLIST nvarchar(100)
)
as
begin
    declare @EXCEPTIONLIST nvarchar(100)
    set @EXCEPTIONLIST = ''

    if dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEGENDER(@STUDENTID, @COURSEID) = 0 
        set @EXCEPTIONLIST = 'GENDER'

    if dbo.UFN_SCHEDULINGEXCEPTION_VALIDATESCHOOL(@STUDENTID, @COURSEID) = 0 
        set @EXCEPTIONLIST = case when @EXCEPTIONLIST = '' then 'SCHOOL' else @EXCEPTIONLIST + ';' + 'SCHOOL' end

    if dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEGRADELEVEL(@STUDENTID, @COURSEID) = 0
        set @EXCEPTIONLIST = case when @EXCEPTIONLIST = '' then 'GRADE_LEVEL' else @EXCEPTIONLIST + ';' + 'GRADE_LEVEL' end

    if dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEALREADYTAKEN(@STUDENTID, @COURSEID) = 0
        set @EXCEPTIONLIST = case when @EXCEPTIONLIST = '' then 'ALREADY_TAKEN' else @EXCEPTIONLIST + ';' + 'ALREADY_TAKEN' end

    if dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEALREADYREQUESTED(@STUDENTID, @COURSEID, @SESSIONID) = 0
        set @EXCEPTIONLIST = case when @EXCEPTIONLIST = '' then 'ALREADY_REQUESTED' else @EXCEPTIONLIST + ';' + 'ALREADY_REQUESTED' end

    if @EXCEPTIONLIST <> ''
    begin
        insert into @RESULTS
        select
            @EXCEPTIONLIST
    end

    return 
end