UFN_FEPPROCESS_SUBSECTORCODE_GETDESCRIPTION

/*
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_GETDESCRIPTION(@ID tinyint)
RETURNS nvarchar(53) WITH EXECUTE AS CALLER
AS
begin

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

end