UFN_REVENUESPLIT_APPLICATIONCODE_GETDESCRIPTION

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

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

end