USP_DATALIST_STUDENTSCHEDULE_WITHBLOCK

Returns all Class records associated with the specified student during the specified time period. (Includes block information)

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTID	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
@STATUSCODE	tinyint	IN	Status

Definition

Copy



CREATE procedure dbo.USP_DATALIST_STUDENTSCHEDULE_WITHBLOCK
(
    @STUDENTID uniqueidentifier,
    @ACADEMICYEARNAMECODEID uniqueidentifier = null,
    @SESSIONNAMECODEID uniqueidentifier = null,
    @TERMNAMECODEID uniqueidentifier = null,
    @SCHOOLID uniqueidentifier = null,
  @STATUSCODE tinyint = null
)
as
    set nocount on;

    select
        ID,
        CLASSID,
        NAME,
        CLASSNAME,
        TERM,
        FACULTY,
        BLOCK,
        MEETINGS,
    STATUS,
    STATUSDATE
    from dbo.UFN_STUDENT_GETCLASSMEETINGGROUPS(
        @STUDENTID,
        @ACADEMICYEARNAMECODEID,
        @SESSIONNAMECODEID,
        @TERMNAMECODEID,
        @SCHOOLID,
    @STATUSCODE)