USP_DATALIST_ACADEMICYEAR_2

List academic years for given timetable.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_ACADEMICYEAR_2
                    (
                        @TIMETABLEID uniqueidentifier 
                    )
                as
                    set nocount on;

                    select ACADEMICYEAR.ID,
                           ACADEMICYEARNAMECODE.DESCRIPTION AS NAME,
                           CONSTITUENT.NAME SCHOOLNAME,
                           (select dbo.UDA_BUILDLIST(SESSIONNAMECODE.DESCRIPTION)
                               from dbo.SESSION
                               inner join SESSIONNAMECODE on SESSION.SESSIONNAMECODEID = SESSIONNAMECODE.ID
                               where SESSION.ACADEMICYEARID = ACADEMICYEAR.ID AND SESSION.TIMETABLEID = @TIMETABLEID
                               ) AS SESSIONS
                    from dbo.ACADEMICYEAR
                    inner join CONSTITUENT
                            on ACADEMICYEAR.SCHOOLID = CONSTITUENT.ID
                    inner join dbo.ACADEMICYEARNAMECODE 
                            on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID
                    where exists (select SESSION.TIMETABLEID from SESSION where SESSION.TIMETABLEID = @TIMETABLEID and SESSION.ACADEMICYEARID = ACADEMICYEAR.ID)