USP_SIMPLEDATALIST_GRADINGSCALEFACULTY

Returns a list of grading scales available for this faculty member to use.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_GRADINGSCALEFACULTY
(
    @CURRENTAPPUSERID uniqueidentifier
)
as
    set nocount on;

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

    select
        ID AS VALUE,
        NAME AS LABEL
    from dbo.GRADINGSCALE
    where (ISREGISTRARCREATED = 1
        or FACULTYID = @FACULTYID)
        and ISACTIVE = 1
    order by ISREGISTRARCREATED desc, NAME ASC