USP_ADDRESSVALIDATIONUPDATE_NCOADPVFOOTNOTECODE_GETLIST

/*
Generated by Blackbaud AppFx Platform
Date:  12/17/2008 2:22:25 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=1.7.1271.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_ADDRESSVALIDATIONUPDATE_NCOADPVFOOTNOTECODE_GETLIST
AS
    select 0 'ID', '' 'DESCRIPTION'
    union
    select 1 'ID', 'AA - Input address matched to the ZIP + 4 file' 'DESCRIPTION'
    union
    select 2 'ID', 'A1 - Input address not matched to the ZIP + 4 file' 'DESCRIPTION'
    union
    select 3 'ID', 'BB - Input address matched to DPV (all components)' 'DESCRIPTION'
    union
    select 4 'ID', 'CC - Input address primary number matched to DPV but secondary number present but not valid' 'DESCRIPTION'
    union
    select 5 'ID', 'F1 - Military' 'DESCRIPTION'
    union
    select 6 'ID', 'G1 - General Delivery' 'DESCRIPTION'
    union
    select 7 'ID', 'N1 - Input address primary number matched to DPV but high-rise address missing secondary number' 'DESCRIPTION'
    union
    select 8 'ID', 'M1 - Input address primary number missing' 'DESCRIPTION'
    union
    select 9 'ID', 'M3 - Input address primary number invalid' 'DESCRIPTION'
    union
    select 10 'ID', 'NL - NCOALink move address cannot be DPV confirmed (occurs because the NCOAlink directories are updated more frequently than the DPV directories)' 'DESCRIPTION'
    union
    select 11 'ID', 'P1 - Input address missing PO, RR or HC box number' 'DESCRIPTION'
    union
    select 12 'ID', 'P3 - Input address is invalid PO, RR, or HC number' 'DESCRIPTION'
    union
    select 13 'ID', 'RR - Input address matched to CMRA' 'DESCRIPTION'
    union
    select 14 'ID', 'R1 - Input address matched to CMRA but secondary number not present' 'DESCRIPTION'
    union
    select 15 'ID', 'U1 - Unique' 'DESCRIPTION'