UFN_REVENUESPLIT_APPLICATIONCODE_GETID

        /*
Generated by Blackbaud AppFx Platform
Date:  11/1/2010 1:14:49 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.9.126.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_REVENUESPLIT_APPLICATIONCODE_GETID(@Description nvarchar(18))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin

    return case @Description
        when 'Donation' then 0
        when 'Event registration' then 1
        when 'Pledge' then 2
        when 'Recurring gift' then 3
        when 'Other' then 4
        when 'Membership' then 5
        when 'Planned gift' then 6
        when 'Matching gift' then 7
        when 'Grant award' then 8
        when 'Admission' then 9
        when 'Order' then 10
        when 'Miscellaneous' then 11
        when 'Auction purchase' then 12
        when 'Donor challenge' then 13
        when 'Event sponsorship' then 15
        when 'Merchandise' then 16
        when 'Pending gift' then 17
        else -1
        end 

end