UFN_JOURNALENTRY_EXT_TABLENAMECODE_GETID

/*
Generated by Blackbaud AppFx Platform
Date:  10/27/2011 12:07:06 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.92.537.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_JOURNALENTRY_EXT_TABLENAMECODE_GETID(@Description nvarchar(42))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin

    return case @Description
        when 'GLTRANSACTION' then 0
        when 'REVENUEGLDISTRIBUTION' then 1
        when 'AUCTIONPURCHASEGLDISTRIBUTION' then 2
        when 'BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION' then 3
        when 'BANKACCOUNTTRANSACTIONGLDISTRIBUTION' then 4
        when 'BENEFITGLDISTRIBUTION' then 5
        when 'CREDITGLDISTRIBUTION' then 6
        when 'GIFTAIDGLDISTRIBUTION' then 7
        when 'GIFTFEEGLDISTRIBUTION' then 8
        when 'PLANNEDGIFTPAYOUTGLDISTRIBUTION' then 9
        when 'PROPERTYDETAILGLDISTRIBUTION' then 10
        when 'STOCKSALEGLDISTRIBUTION' then 11
        when 'WRITEOFFGLDISTRIBUTION' then 12
        when 'GIFTINKINDSALEGLDISTRIBUTION' then 13
        when 'UNREALIZEDGAINLOSSGLDISTRIBUTION' then 14
        else -1
        end 

end