USP_SIMPLEDATALIST_APPUSERSESSION_GRADELEVEL

Simple list of grade levels filtered by the academic scheduling session.

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_APPUSERSESSION_GRADELEVEL
            (
                @CURRENTAPPUSERID uniqueidentifier
            )
            as
                select 
                    dbo.GRADELEVEL.[ID] as VALUE, 
                    dbo.GRADELEVEL.[ABBREVIATION] as LABEL
                from dbo.SCHOOLGRADELEVEL
                    inner join dbo.GRADELEVEL on SCHOOLGRADELEVEL.[GRADELEVELID] = GRADELEVEL.[ID]
                    inner join dbo.ACADEMICYEAR on SCHOOLGRADELEVEL.SCHOOLID = ACADEMICYEAR.SCHOOLID
                    inner join dbo.SESSION on ACADEMICYEAR.ID = SESSION.ACADEMICYEARID
                    inner join dbo.APPUSERSESSION on SESSION.ID = APPUSERSESSION.SESSIONID
                where APPUSERSESSION.ID = @CURRENTAPPUSERID
                order by dbo.GRADELEVEL.[SEQUENCE]