USP_RECURRINGGIFTAMENDMENT_PREVIOUSSTATUSCODE_GETLIST

Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:27:25 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_RECURRINGGIFTAMENDMENT_PREVIOUSSTATUSCODE_GETLIST
AS
    select 0 'ID', 'Active' 'DESCRIPTION'
    union
    select 1 'ID', 'Held' 'DESCRIPTION'
    union
    select 2 'ID', 'Terminated' 'DESCRIPTION'
    union
    select 3 'ID', 'Canceled' 'DESCRIPTION'
    union
    select 5 'ID', 'Lapsed' 'DESCRIPTION'
    union
    select 99 'ID', 'Not applicable' 'DESCRIPTION'