V_SEARCH_GRANT
Search screen for grant program records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| GRANTOR | nvarchar(154) | yes | |
| TITLE | nvarchar(150) | ||
| MINAWARD | money | ||
| MAXAWARD | money | ||
| DESCRIPTION | nvarchar(500) | ||
| TRANSACTIONCURRENCYID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/30/2010 11:38:07 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_GRANT AS
select
GRANTS.ID,
dbo.UFN_CONSTITUENT_BUILDNAME(GRANTS.GRANTORID) as GRANTOR,
GRANTS.TITLE,
GRANTS.TRANSACTIONMINAWARD as MINAWARD,
GRANTS.TRANSACTIONMAXAWARD as MAXAWARD,
GRANTS.DESCRIPTION,
GRANTS.TRANSACTIONCURRENCYID
from
dbo.GRANTS