USP_ADDRESS_NCOAFOOTNOTECODE_GETLIST
Definition
Copy
/*
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 PROCEDURE dbo.USP_ADDRESS_NCOAFOOTNOTECODE_GETLIST
AS
select 0 'ID', '' 'DESCRIPTION'
union
select 1 'ID', 'M - Forwardable move' 'DESCRIPTION'
union
select 2 'ID', 'K - Moved, no forwarding address' 'DESCRIPTION'
union
select 3 'ID', 'G - PO box closed' 'DESCRIPTION'
union
select 4 'ID', 'F - Move to foreign address' 'DESCRIPTION'
union
select 5 'ID', 'S - Forwardable move, but secondary address cannot be verified' 'DESCRIPTION'
union
select 6 'ID', 'P - Change of address form filed, but new address not in USPS records' 'DESCRIPTION'
union
select 7 'ID', 'L - Temporary address has lapsed' 'DESCRIPTION'