USP_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENT

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

Parameters

Parameter	Parameter Type	Mode	Description
@ACADEMICCATALOGCOLLEGEID	uniqueidentifier	IN	College
@ACADEMICCATALOGDIVISIONID	uniqueidentifier	IN	Division

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENT
(
    @ACADEMICCATALOGCOLLEGEID uniqueidentifier = null,
    @ACADEMICCATALOGDIVISIONID uniqueidentifier = null
)
as
    set nocount on;

    declare @CURRENTID uniqueidentifier;

    if not @ACADEMICCATALOGDIVISIONID is null and not @ACADEMICCATALOGDIVISIONID = '00000000-0000-0000-0000-000000000000'
        begin
            select
                @CURRENTID = CURRENTID
            from
                dbo.ACADEMICCATALOGDIVISION
            where
                ID = @ACADEMICCATALOGDIVISIONID;

            select
                ID as VALUE,
                NAME as LABEL
            from
                dbo.ACADEMICCATALOGDEPARTMENT
            where
                ACADEMICCATALOGDIVISIONID = @ACADEMICCATALOGDIVISIONID
                or ACADEMICCATALOGDIVISIONID = @CURRENTID;
        end
    else if not @ACADEMICCATALOGCOLLEGEID is null and not @ACADEMICCATALOGCOLLEGEID = '00000000-0000-0000-0000-000000000000'
        begin
            select
                @CURRENTID = CURRENTID
            from
                dbo.ACADEMICCATALOGCOLLEGE
            where
                ID = @ACADEMICCATALOGCOLLEGEID;

            select
                ID as VALUE,
                NAME as LABEL
            from
                dbo.ACADEMICCATALOGDEPARTMENT
            where
                ACADEMICCATALOGCOLLEGEID = @ACADEMICCATALOGCOLLEGEID
                or ACADEMICCATALOGCOLLEGEID = @CURRENTID;
        end
    else   
        begin
          select
                ID as VALUE,
                NAME as LABEL
            from
                dbo.ACADEMICCATALOGDEPARTMENT;
       end