UFN_VSECATEGORY_VSECATEGORYCODE_GETID

/*
Generated by Blackbaud AppFx Platform
Date:  12/17/2008 2:39:56 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=1.7.1271.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_VSECATEGORY_VSECATEGORYCODE_GETID(@Description nvarchar(70))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin

    return case @Description
        when 'Current Operations - Unrestricted' then 0
        when 'Current Operations - Restricted' then 1
        when 'Current Operations - Academic Divisions' then 2
        when 'Current Operations - Faculty and Staff' then 3
        when 'Current Operations - Research' then 4
        when 'Current Operations - Public Service and Extension' then 5
        when 'Current Operations - Library' then 6
        when 'Current Operations - Op and Maint of Plant' then 7
        when 'Current Operations - Student Financial Aid' then 8
        when 'Current Operations - Athletics' then 9
        when 'Current Operations - Other Restricted' then 10
        when 'Capital Purposes - Property, Building, Equipment' then 12
        when 'Capital Purposes - Endowment Unrestricted' then 13
        when 'Capital Purposes - Endowment Restricted' then 14
        when 'Capital Purposes - Loan Funds' then 15
        when 'Capital Purposes - Endowment Restricted - Academic Divisions' then 18
        when 'Capital Purposes - Endowment Restricted - Faculty and Staff' then 19
        when 'Capital Purposes - Endowment Restricted - Research' then 20
        when 'Capital Purposes - Endowment Restricted - Public Service and Extension' then 21
        when 'Capital Purposes - Endowment Restricted - Library' then 22
        when 'Capital Purposes - Endowment Restricted - Op and Maint of Plant' then 23
        when 'Capital Purposes - Endowment Restricted - Student Financial Aid' then 24
        when 'Capital Purposes - Endowment Restricted - Athletics' then 25
        when 'Capital Purposes - Endowment Restricted - Other' then 26
        else -1
        end 

end