USP_DATALIST_FACULTYCLASS

Returns a list of the classes taught for the specified faculty member.

Parameters

Parameter	Parameter Type	Mode	Description
@FACULTYID	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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_FACULTYCLASS
(
    @FACULTYID uniqueidentifier,
    @ACADEMICYEARNAMECODEID uniqueidentifier = null,
    @SESSIONNAMECODEID uniqueidentifier = null,
    @TERMNAMECODEID uniqueidentifier = null
)
as
    set nocount on;

    select
        ID,
        CLASSID,
        NAME,
        CLASSNAME,
        TERM,
        NUMBERENROLLED,
        MEETINGS
    from dbo.UFN_FACULTY_GETCLASSMEETINGGROUPS(
        @FACULTYID,
        @ACADEMICYEARNAMECODEID,
        @SESSIONNAMECODEID,
        @TERMNAMECODEID)