UFN_ADDRESS_NCOAFOOTNOTECODE_GETDESCRIPTION

/*
Generated by Blackbaud AppFx Platform
Date:  12/17/2008 2:20:07 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=1.7.1271.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_ADDRESS_NCOAFOOTNOTECODE_GETDESCRIPTION(@ID tinyint)
RETURNS nvarchar(69) WITH EXECUTE AS CALLER
AS
begin

    return case @ID
        when 0 then ''
        when 1 then 'M - Forwardable move'
        when 2 then 'K - Moved, no forwarding address'
        when 3 then 'G - PO box closed'
        when 4 then 'F - Move to foreign address'
        when 5 then 'S - Forwardable move, but secondary address cannot be verified'
        when 6 then 'P - Change of address form filed, but new address not in USPS records'
        when 7 then 'L - Temporary address has lapsed'    
    end

end