USP_DATALIST_GRADINGSCALEFACULTY

List of grading scales for faculty view.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@ACADEMICYEARNAMECODEID	uniqueidentifier	IN	Academic year
@SESSIONNAMECODEID	uniqueidentifier	IN	Session
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



CREATE procedure dbo.USP_DATALIST_GRADINGSCALEFACULTY
(
    @CURRENTAPPUSERID uniqueidentifier,
    @ACADEMICYEARNAMECODEID uniqueidentifier = null,
    @SESSIONNAMECODEID uniqueidentifier = null,
    @INCLUDEINACTIVE bit = 0
)
as
    set nocount on;

    declare @FACULTYID uniqueidentifier
    set @FACULTYID = (select APPUSER.CONSTITUENTID
                      from dbo.APPUSER
                      where APPUSER.ID = @CURRENTAPPUSERID)

    select distinct
        GRADINGSCALE.ID,
        GRADINGSCALE.NAME,
        GRADINGSCALE.ISACTIVE,
        GRADINGSCALE.DESCRIPTION,
        GRADINGSCALE.ISREGISTRARCREATED
    from dbo.GRADINGSCALE
        left join dbo.CLASSCATEGORY
            on CLASSCATEGORY.GRADINGSCALEID = GRADINGSCALE.ID
        left join dbo.CLASS
            on CLASS.ID = CLASSCATEGORY.CLASSID
        left join dbo.CLASSMEETINGGROUP
            on CLASSMEETINGGROUP.CLASSID = CLASSCATEGORY.CLASSID and CLASSMEETINGGROUP.STARTDATE = CLASS.STARTDATE
        left join dbo.COURSE
            on CLASS.COURSEID = COURSE.ID
        left join dbo.ACADEMICYEAR
            on COURSE.SCHOOLID = ACADEMICYEAR.SCHOOLID
        left join dbo.SESSION
            on ACADEMICYEAR.ID = SESSION.ACADEMICYEARID
        left join dbo.TERM
            on SESSION.ID = TERM.SESSIONID and TERM.STARTDATE = CLASSMEETINGGROUP.STARTDATE    and TERM.ENDDATE = CLASSMEETINGGROUP.ENDDATE
    where (GRADINGSCALE.ISREGISTRARCREATED = 1 or GRADINGSCALE.FACULTYID = @FACULTYID)
        and (@INCLUDEINACTIVE = 1 or GRADINGSCALE.ISACTIVE = 1)
        and (@ACADEMICYEARNAMECODEID is null or (TERM.ID is not null and @ACADEMICYEARNAMECODEID = ACADEMICYEAR.ACADEMICYEARNAMECODEID))
        and (@SESSIONNAMECODEID is null or (TERM.ID is not null and @SESSIONNAMECODEID = SESSION.SESSIONNAMECODEID))
    order by GRADINGSCALE.ISREGISTRARCREATED desc, GRADINGSCALE.NAME asc