USP_DATALIST_ACADEMICCATALOG

                    CREATE procedure dbo.USP_DATALIST_ACADEMICCATALOG
                    (
                        @LEVELCODE tinyint,
                        @ID uniqueidentifier
                    )
                    as
                        set nocount on;

                        if @LEVELCODE = 0
                            select
                                INSTITUTION.ID,
                                null,
                                null,
                                INSTITUTION.NAME,
                                null,
                                (select count(ID) from dbo.ACADEMICCATALOGPROGRAM where EDUCATIONALINSTITUTIONID = INSTITUTION.ID),
                                0
                            from
                                dbo.EDUCATIONALINSTITUTION as INSTITUTION
                            where
                                INSTITUTION.ISAFFILIATED = 1;

                        if @LEVELCODE = 1
                            select
                                PROGRAM.ID,
                                PROGRAM.PROGRAMCODE,
                                null,
                                PROGRAM.PROGRAM,
                                null,
                                (select count(ID) from dbo.ACADEMICCATALOGDEGREE where ACADEMICCATALOGPROGRAMID = PROGRAM.ID),
                                0
                            from
                                dbo.ACADEMICCATALOGPROGRAM as PROGRAM
                            where
                                PROGRAM.EDUCATIONALINSTITUTIONID = @ID;

                        if @LEVELCODE = 2
                            select
                                DEGREE.ID,
                                null,
                                DEGREE.USERID,
                                DEGREE.NAME,
                                DEGREE.ISHISTORICAL,
                                (select count(ID) from dbo.ACADEMICCATALOGCOLLEGE where ACADEMICCATALOGDEGREEID = DEGREE.ID),
                                case when exists (select ID from dbo.ACADEMICCATALOGDEGREE where CURRENTID = DEGREE.ID) then 1 else 0 end
                            from
                                dbo.ACADEMICCATALOGDEGREE as DEGREE
                            where
                                DEGREE.ACADEMICCATALOGPROGRAMID = @ID;

                        if @LEVELCODE = 3
                            select
                                COLLEGE.ID,
                                null,
                                COLLEGE.USERID,
                                COLLEGE.NAME,
                                COLLEGE.ISHISTORICAL,
                                (select count(ID) from dbo.ACADEMICCATALOGDEPARTMENT where ACADEMICCATALOGCOLLEGEID = COLLEGE.ID),
                                case when exists (select ID from dbo.ACADEMICCATALOGCOLLEGE where CURRENTID = COLLEGE.ID) then 1 else 0 end
                            from
                                dbo.ACADEMICCATALOGCOLLEGE as COLLEGE
                            where
                                COLLEGE.ACADEMICCATALOGDEGREEID = @ID;

                        if @LEVELCODE = 4
                            select
                                DEPARTMENT.ID,
                                null,
                                DEPARTMENT.USERID,
                                DEPARTMENT.NAME,
                                DEPARTMENT.ISHISTORICAL,
                                (select count(ID) from dbo.ACADEMICCATALOGDEGREETYPE where ACADEMICCATALOGDEPARTMENTID = DEPARTMENT.ID),
                                case when exists (select ID from dbo.ACADEMICCATALOGDEPARTMENT where CURRENTID = DEPARTMENT.ID) then 1 else 0 end
                            from
                                dbo.ACADEMICCATALOGDEPARTMENT as DEPARTMENT
                            where
                                DEPARTMENT.ACADEMICCATALOGCOLLEGEID = @ID;

                        if @LEVELCODE = 5
                            select
                                DEGREETYPE.ID,
                                null,
                                DEGREETYPE.USERID,
                                dbo.UFN_ACADEMICCATALOGDEGREETYPECODE_GETDESCRIPTION(ACADEMICCATALOGDEGREETYPECODEID),
                                0,
                                0,
                                0
                            from
                                dbo.ACADEMICCATALOGDEGREETYPE as DEGREETYPE
                            where
                                DEGREETYPE.ACADEMICCATALOGDEPARTMENTID = @ID;