UFN_FEPPROCESS_SUBSECTORCODE_GETID

/*
Generated by Blackbaud AppFx Platform
Date:  4/29/2010 7:19:26 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.6.1444.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_FEPPROCESS_SUBSECTORCODE_GETID(@Description nvarchar(53))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin

    return case @Description
        when 'Arts, Culture and Humanities' then 0
        when 'Education' then 1
        when 'Environment' then 2
        when 'Animal-Related' then 3
        when 'Health Care' then 4
        when 'Mental Health and Crisis Intervention' then 5
        when 'Voluntary Health Associations and Medical Disciplines' then 6
        when 'Medical Research' then 7
        when 'Crime and Legal-Related' then 8
        when 'Employment' then 9
        when 'Food, Agriculture and Nutrition' then 10
        when 'Housing and Shelter' then 11
        when 'Public Safety, Disaster Preparedness and Relief' then 12
        when 'Recreation and Sports' then 13
        when 'Youth Development' then 14
        when 'Human Services' then 15
        when 'International, Foreign Affairs and National Security' then 16
        when 'Civil Rights, Social Action and Advocacy' then 17
        when 'Community Improvement and Capacity Building' then 18
        when 'Philanthropy, Voluntarism and Grantmaking Foundations' then 19
        when 'Science and Technology' then 20
        when 'Social Science' then 21
        when 'Public and Societal Benefit' then 22
        when 'Religion-Related' then 23
        when 'Mutual and Membership Benefit' then 24
        when 'Unknown (Other)' then 25
        else -1
        end 

end