USP_DATALIST_GETCURRENTYEARBYSCHOOL

Gives the user the current academic year by school.

Parameters

Parameter	Parameter Type	Mode	Description
@SCHOOLID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_GETCURRENTYEARBYSCHOOL
                    (
                    @SCHOOLID uniqueidentifier = null                    
                    )
                    as                    
                    set nocount on

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getDate()

                    select SCHOOLID,
                        ACADEMICYEARNAMECODE.DESCRIPTION AS NAME,
                        ACADEMICYEAR.ID,
                        BILLINGSTARTDATE,
                        BILLINGENDDATE
                    from dbo.ACADEMICYEAR    
                    inner join dbo.ACADEMICYEARNAMECODE 
                            on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID                    
                    where STARTDATE<=@CURRENTDATE AND ENDDATE>=@CURRENTDATE AND SCHOOLID=@SCHOOLID