USP_DATALIST_FACULTYACADEMICCATALOGDEPARTMENTBYDEPARTMENT

Returns list of faculty in a given department.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_FACULTYACADEMICCATALOGDEPARTMENTBYDEPARTMENT(@ACADEMICCATALOGDEPARTMENTID uniqueidentifier)
as
    set nocount on;

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