USP_SIMPLEDATALIST_CHARGEGRADELEVELS

            CREATE procedure dbo.USP_SIMPLEDATALIST_CHARGEGRADELEVELS
            (
                @STUDENTID uniqueidentifier,
                @CHARGEDATE date = null,
                @SCHOOLID uniqueidentifier
            )
            as
                select 
                    dbo.GRADELEVEL.ID as VALUE, 
                    dbo.GRADELEVEL.DESCRIPTION as LABEL
                from 
                    dbo.ACADEMICYEAR as AY
                inner join 
                    dbo.STUDENTPROGRESSION as SP on AY.STARTDATE = SP.STARTDATE and AY.ENDDATE = SP.ENDDATE
                inner join
                    dbo.EDUCATIONALHISTORY as ENROLLMENT on SP.ENROLLMENTID = ENROLLMENT.ID
                inner join 
                    dbo.SCHOOLGRADELEVEL as SG on SP.SCHOOLGRADELEVELID = SG.ID and SG.SCHOOLID = @SCHOOLID
                inner join 
                    dbo.GRADELEVEL on SG.GRADELEVELID = GRADELEVEL.ID
                where (@CHARGEDATE IS NOT NULL) 
                    and (AY.BILLINGSTARTDATE<=@CHARGEDATE) 
                    and (AY.BILLINGENDDATE>=@CHARGEDATE) 
                    and (ENROLLMENT.CONSTITUENTID = @STUDENTID) 
                group by dbo.GRADELEVEL.ID, dbo.GRADELEVEL.DESCRIPTION