V_SIMPLEDATALIST_EDUCATIONALINSTITUTION

Returns a list of educational institutions.

Fields

Field	Field Type	Null	Description
LABEL	nvarchar(102)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:35:08 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_EDUCATIONALINSTITUTION AS



                select 
                    case when ISAFFILIATED = 1 then NAME + ' *' else NAME end as LABEL
                    --NAME as LABEL 

                from
                    dbo.EDUCATIONALINSTITUTION