UFN_ADDRESS_NCOADPVFOOTNOTECODE_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_NCOADPVFOOTNOTECODE_GETDESCRIPTION(@ID tinyint)
RETURNS nvarchar(145) WITH EXECUTE AS CALLER
AS
begin

    return case @ID
        when 0 then ''
        when 1 then 'AA - Input address matched to the ZIP + 4 file'
        when 2 then 'A1 - Input address not matched to the ZIP + 4 file'
        when 3 then 'BB - Input address matched to DPV (all components)'
        when 4 then 'CC - Input address primary number matched to DPV but secondary number present but not valid'
        when 5 then 'F1 - Military'
        when 6 then 'G1 - General Delivery'
        when 7 then 'N1 - Input address primary number matched to DPV but high-rise address missing secondary number'
        when 8 then 'M1 - Input address primary number missing'
        when 9 then 'M3 - Input address primary number invalid'
        when 10 then 'NL - NCOALink move address cannot be DPV confirmed (occurs because the NCOAlink directories are updated more frequently than the DPV directories)'
        when 11 then 'P1 - Input address missing PO, RR or HC box number'
        when 12 then 'P3 - Input address is invalid PO, RR, or HC number'
        when 13 then 'RR - Input address matched to CMRA'
        when 14 then 'R1 - Input address matched to CMRA but secondary number not present'
        when 15 then 'U1 - Unique'    
    end

end