USP_DATALIST_CLASS_WITHBLOCK

Returns all Class records (Includes block information).

Parameters

Parameter	Parameter Type	Mode	Description
@COURSEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@ACADEMICYEARNAMECODEID	uniqueidentifier	IN	Academic Year
@SESSIONNAMECODEID	uniqueidentifier	IN	Session
@TERMNAMECODEID	uniqueidentifier	IN	Term
@SCHOOLID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_DATALIST_CLASS_WITHBLOCK
(
    @COURSEID uniqueidentifier,
    @ACADEMICYEARNAMECODEID uniqueidentifier = null,
    @SESSIONNAMECODEID uniqueidentifier = null,
    @TERMNAMECODEID uniqueidentifier = null,
    @SCHOOLID uniqueidentifier = null
)
as
    set nocount on;

    select
        ID,
        CLASSID,
        NAME,
        CLASSNAME,
        TERM,
        FACULTY,
        NUMBERENROLLED,
        BLOCK,
        MEETINGS
    from dbo.UFN_COURSE_GETCLASSMEETINGGROUPS(
        @COURSEID,
        @ACADEMICYEARNAMECODEID,
        @SESSIONNAMECODEID,
        @TERMNAMECODEID,
        @SCHOOLID)