USP_PLANNEDGIFTVEHICLEOPTIONS_VEHICLECODE_GETLIST

Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  11/30/2010 11:16:30 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_PLANNEDGIFTVEHICLEOPTIONS_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'