UFN_PROSPECTRESEARCHTEMPLATESECTION_SECTIONCODE_GETID

/*
Generated by Blackbaud AppFx Platform
Date:  10/23/2017 7:38:51 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.173.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_PROSPECTRESEARCHTEMPLATESECTION_SECTIONCODE_GETID(@Description nvarchar(31))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin

    return case @Description
        when 'Prospect overview' then 1
        when 'Research summary' then 2
        when 'Additional prospect details' then 3
        when 'Spouse details' then 4
        when 'Giving summary' then 5
        when 'Model scores and ratings' then 6
        when 'Wealth point summary' then 7
        when 'Philanthropic sapacity' then 8
        when 'Constituencies' then 9
        when 'Interests' then 10
        when 'Constituent attributes' then 11
        when 'Educational history' then 12
        when 'Philanthropic gifts (collapsed)' then 13
        when 'Whos Who biographical summary' then 14
        when 'Whos Who biographical details' then 15
        when 'Real estate' then 16
        when 'Business ownership' then 17
        when 'Securities' then 18
        when 'Income' then 19
        when 'Affluence indicators' then 20
        when 'Nonprofit affiliations' then 21
        when 'Private foundations' then 22
        when 'Political donations' then 23
        when 'Other assets' then 24
        when 'Relationships' then 25
        when 'Extended network' then 26
        when 'Notes' then 27
        when 'Contact Information' then 28
        when 'Giving Summary Chart' then 29
        when 'Asset Distribution Chart' then 30
        when 'Philanthropic gifts (expanded)' then 31
        else -1
        end 

end