UFN_RESERVATIONSTATUSHISTORY_STATUSCODE_GETDESCRIPTION

/*
Generated by Blackbaud AppFx Platform
Date:  1/27/2010 6:48:26 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.5.465.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_RESERVATIONSTATUSHISTORY_STATUSCODE_GETDESCRIPTION(@ID tinyint)
RETURNS nvarchar(31) WITH EXECUTE AS CALLER
AS
begin

    return case @ID
        when 0 then 'Pending'
        when 1 then 'Complete'
        when 2 then 'Tentative'
        when 3 then 'Confirmed'
        when 4 then 'Finalized'
        when 5 then 'Cancelled'
        when 6 then 'Contract Sent'
        when 7 then 'Contract Received'
        when 8 then 'Contract Marked Not Sent'
        when 9 then 'Contract Marked Not Received'
        when 10 then 'Final Count Marked Not Received'
        when 11 then 'Final Count Received'
        when 12 then 'Order balance sent'
        when 13 then 'Order balance marked not sent'    
    end

end