USP_SIMPLEDATALIST_ACADEMICCATALOGSUBDEPARTMENT

Returns a list of academic catalog sub departments for a given college.

Parameters

Parameter	Parameter Type	Mode	Description
@ACADEMICCATALOGDEPARTMENTID	uniqueidentifier	IN	Department

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGSUBDEPARTMENT
(
    @ACADEMICCATALOGDEPARTMENTID uniqueidentifier = null
)
as
    set nocount on;

    declare @CURRENTID uniqueidentifier;
    select
        @CURRENTID = CURRENTID
    from
        dbo.ACADEMICCATALOGDEPARTMENT
    where
        ID = @ACADEMICCATALOGDEPARTMENTID;

    select
        ID as VALUE,
        NAME as LABEL
    from
        dbo.ACADEMICCATALOGSUBDEPARTMENT
    where
        ACADEMICCATALOGDEPARTMENTID = isnull(@ACADEMICCATALOGDEPARTMENTID,ACADEMICCATALOGDEPARTMENTID)
        or ACADEMICCATALOGDEPARTMENTID = @CURRENTID;