USP_DATALIST_FACULTYCOURSERESOURCE

Returns courses that a faculty member is a resource for.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_FACULTYCOURSERESOURCE(@FACULTYID uniqueidentifier)
as
    set nocount on;

    select dbo.FACULTYCOURSE.ID,
           dbo.FACULTYCOURSE.COURSEID,
           dbo.COURSE.COURSEID USERDEFINEDCOURSEID,       
           dbo.COURSE.NAME COURSENAME,
       dbo.CONSTITUENT.NAME SCHOOLNAME
    from dbo.FACULTYCOURSE
  inner join dbo.COURSE
    on dbo.FACULTYCOURSE.COURSEID = dbo.COURSE.ID
  inner join dbo.SCHOOL
    on dbo.COURSE.SCHOOLID = dbo.SCHOOL.ID
  inner join dbo.CONSTITUENT
    on dbo.SCHOOL.ID = dbo.CONSTITUENT.ID
    where dbo.FACULTYCOURSE.FACULTYID = @FACULTYID
    and ISRESOURCE = 1