USP_DATALIST_FACULTYACADEMICCATALOGDEPARTMENTBYFACULTY

Returns a list of departments associated with a faculty member.

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_FACULTYACADEMICCATALOGDEPARTMENTBYFACULTY(@FACULTYID uniqueidentifier)
as
    set nocount on;

    select ACADEMICCATALOGDEPARTMENT.ID,
           FACULTYACADEMICCATALOGDEPARTMENT.ID as FACULTYACADEMICCATALOGDEPARTMENTID,
           ACADEMICCATALOGDEPARTMENT.USERID,
           CONSTITUENT.NAME as SCHOOL,
           FACULTYACADEMICCATALOGDEPARTMENT.ISDEPARTMENTHEAD,
           FACULTYACADEMICCATALOGDEPARTMENT.ISTEACHERINDEPARTMENT,
           FACULTYACADEMICCATALOGDEPARTMENT.ISPRIMARY
    from 
        dbo.FACULTYACADEMICCATALOGDEPARTMENT
    join dbo.ACADEMICCATALOGDEPARTMENT on ACADEMICCATALOGDEPARTMENT.ID = FACULTYACADEMICCATALOGDEPARTMENT.ACADEMICCATALOGDEPARTMENTID
    join dbo.CONSTITUENT on CONSTITUENT.ID = ACADEMICCATALOGDEPARTMENT.SCHOOLID
    where 
        FACULTYID = @FACULTYID
    order by
        ACADEMICCATALOGDEPARTMENT.USERID,
        CONSTITUENT.NAME