V_SIMPLEDATALIST_CORRESPONDENCECODE

Returns a list of correspondence codes.

Fields

Field	Field Type	Null	Description
VALUE	uniqueidentifier
LABEL	nvarchar(100)

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  4/27/2009 11:03:03 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.0.62.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_CORRESPONDENCECODE AS



            select 
                    ID as VALUE,
                    NAME as LABEL
                from
                    dbo.CORRESPONDENCECODE
                where ISACTIVE = 1;