USP_REPORT_VSECOLLEGE_SECTION4A_PART3

            CREATE procedure dbo.USP_REPORT_VSECOLLEGE_SECTION4A_PART3
            (
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @INCLUDEINACTIVE smallint = 0,
                @INCLUDEDECEASED smallint = 0,
                @USEGIFTDATE smallint = 0
            )
            with execute as owner
            as
                set nocount on;

                select 
                    case VSECATEGORY.VSECATEGORYCODE
                        when 18 then 2
                        when 19 then 3
                        when 20 then 4
                        when 21 then 5
                        when 22 then 6
                        when 23 then 7
                        when 24 then 8
                        when 25 then 9
                        when 26 then 10
                    end as VSECATEGORYCODE,
                    case VSECATEGORY.VSECATEGORYCODE
                        when 18 then '1. Academic Division'
                        when 19 then '2. Faculty and Staff Compensation'
                        when 20 then '3. Research'
                        when 21 then '4. Public Service and Extension'
                        when 22 then '5. Library'
                        when 23 then '6. Operation and Maintenance of Plant'
                        when 24 then '7. Student Financial Aid'
                        when 25 then '8. Athletics'
                        when 26 then '9. Other'
                    end as LABEL,
                    coalesce(REPORT_VSECOLLEGE.AMOUNT, 0) as AMOUNT
                from
                    dbo.VSECATEGORY
                left outer join 
                (
                    select 
                        sum(REPORT_VSECOLLEGE.REVENUESPLITAMOUNT) AMOUNT,
                        REPORT_VSECOLLEGE.VSECATEGORYCODE
                    from 
                        (
                        select
                            REPORT_VSECOLLEGE.REVENUESPLITAMOUNT,
                            REPORT_VSECOLLEGE.VSECATEGORYCODE
                        from
                            dbo.UFN_REPORT_VSECOLLEGE(@STARTDATE, @ENDDATE, @INCLUDEINACTIVE, @INCLUDEDECEASED, @USEGIFTDATE) as REPORT_VSECOLLEGE
                        where
                            REPORT_VSECOLLEGE.VSECATEGORYCODE in (18, 19, 20, 21, 22, 23, 24, 25, 26)

                        union all

                        select
                            case when REPORT_VSECOLLEGE.FACEVALUE = 0 then 0 else (REPORT_VSECOLLEGE.PRESENTVALUE * (REPORT_VSECOLLEGE.PLANNEDGIFTDESIGNATIONAMOUNT / REPORT_VSECOLLEGE.FACEVALUE)) end as REVENUESPLITAMOUNT,
                            REPORT_VSECOLLEGE.VSECATEGORYCODE
                        from
                            dbo.UFN_REPORT_VSECOLLEGE_PLANNEDGIFT(@STARTDATE, @ENDDATE, @INCLUDEINACTIVE, @INCLUDEDECEASED, @USEGIFTDATE) as REPORT_VSECOLLEGE
                        where
                            REPORT_VSECOLLEGE.VSECATEGORYCODE in (18, 19, 20, 21, 22, 23, 24, 25, 26)
                        ) as REPORT_VSECOLLEGE
                    group by VSECATEGORYCODE
                ) REPORT_VSECOLLEGE on REPORT_VSECOLLEGE.VSECATEGORYCODE = VSECATEGORY.VSECATEGORYCODE
                where
                    VSECATEGORY.VSECATEGORYCODE in (18, 19, 20, 21, 22, 23, 24, 25, 26);