USP_DATALIST_TERM

All of the terms in a given session.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_TERM
                    (
                        @SESSIONID uniqueidentifier
                    )
                as
                    set nocount on

                    select TERM.ID,
                           TERMNAMECODE.DESCRIPTION AS NAME,
                           TERM.STARTDATE,
                           TERM.WITHDRAWALDATE,
                           TERM.ENDDATE,
                           CYCLEDAY.DESCRIPTION AS CYCLEDAY
                    from dbo.TERM 
                        inner join dbo.TERMNAMECODE on TERM.TERMNAMECODEID = TERMNAMECODE.ID
                        inner join TIMETABLEDAY on TIMETABLEDAY.ID = TERM.TIMETABLEDAYID 
                        inner join CYCLEDAY on CYCLEDAY.ID = TIMETABLEDAY.CYCLEDAYID 
                    where (SESSIONID = @SESSIONID)
                    order by STARTDATE