V_SEARCH_FUNDINGPLAN
Search screen for funding plan records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(150) | ||
| FUNDINGNEED | money | ||
| SITE | nvarchar(250) | yes | |
| DEPARTMENT | nvarchar(100) | yes | |
| PROGRAM | nvarchar(100) | yes | |
| STATUS | varchar(1) | ||
| FUNDINGPLANMANAGER | nvarchar(154) | yes | |
| DATENEEDED | datetime | yes | |
| DESCRIPTION | nvarchar(500) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 3:25:10 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_FUNDINGPLAN AS
select
FUNDINGPLAN.ID,
FUNDINGPLAN.NAME,
FUNDINGPLAN.FUNDINGNEED,
SITE.NAME as SITE,
dbo.UFN_FUNDINGPLANDEPARTMENTCODE_GETDESCRIPTION(FUNDINGPLAN.FUNDINGPLANDEPARTMENTCODEID) as DEPARTMENT,
dbo.UFN_FUNDINGPLANPROGRAMCODE_GETDESCRIPTION(FUNDINGPLAN.FUNDINGPLANPROGRAMCODEID) as PROGRAM,
'' as STATUS,
dbo.UFN_CONSTITUENT_BUILDNAME(FUNDINGPLAN.FUNDINGPLANMANAGERID) as FUNDINGPLANMANAGER,
FUNDINGPLAN.DATENEEDED,
FUNDINGPLAN.DESCRIPTION
from
dbo.FUNDINGPLAN
left join dbo.SITE on FUNDINGPLAN.SITEID = SITE.ID