V_SEARCH_SITE

Search screen for finding a site.

Fields

Field	Field Type	Null
ID	uniqueidentifier
SITEID	nvarchar(100)
NAME	nvarchar(250)
SHORTNAME	nvarchar(100)
ACRONYM	nvarchar(100)
SITETYPECODE	nvarchar(100)	yes
SITEPATH	nvarchar(1000)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:22:57 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_SITE AS



            select SITE.ID,
                   SITE.SITEID,
                   SITE.NAME,
                   SITE.SHORTNAME,
                   SITE.ACRONYM,
                   dbo.UFN_SITETYPECODE_GETDESCRIPTION(SITETYPECODEID) [SITETYPECODE],
                   SITE.[SITEPATH]
            from
                (
                    select
                        SITE.ID,
                        SITE.DESCRIPTION,
                        SITE.SHORTNAME,
                        SITE.SITEID,
                        SITE.ACRONYM,
                        SITE.NAME,
                        SITE.SITETYPECODEID,
                        UFN_SITE_GETPATH_BULK.SITEPATH
                    from dbo.SITE
                    cross apply dbo.UFN_SITE_GETPATH_BULK(SITE.ID)
                    where UFN_SITE_GETPATH_BULK.ID = SITE.ID
                ) as SITE