USP_PLANNEDGIFTRECEIPTVEHICLE_VEHICLECODE_GETLIST
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:19:39 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_PLANNEDGIFTRECEIPTVEHICLE_VEHICLECODE_GETLIST
AS
select 0 'ID', 'Charitable gift annuity' 'DESCRIPTION'
union
select 1 'ID', 'Charitable remainder unitrust' 'DESCRIPTION'
union
select 2 'ID', 'Charitable remainder annuity trust' 'DESCRIPTION'
union
select 3 'ID', 'Charitable lead unitrust' 'DESCRIPTION'
union
select 4 'ID', 'Charitable lead annuity trust' 'DESCRIPTION'
union
select 5 'ID', 'Pooled income fund' 'DESCRIPTION'
union
select 6 'ID', 'Life insurance' 'DESCRIPTION'
union
select 7 'ID', 'Retained life estate' 'DESCRIPTION'
union
select 8 'ID', 'Bargain sale' 'DESCRIPTION'
union
select 9 'ID', 'Outright gift' 'DESCRIPTION'
union
select 10 'ID', 'Bequest' 'DESCRIPTION'
union
select 11 'ID', 'Retirement plan assets' 'DESCRIPTION'
union
select 12 'ID', 'Testamentary charitable trust' 'DESCRIPTION'
union
select 14 'ID', 'Living trust' 'DESCRIPTION'
union
select 13 'ID', 'Other' 'DESCRIPTION'