V_SEARCH_NAMINGOPPORTUNITYFACILITY
Search screen for naming opportunity facility records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(100) | ||
| AREA | nvarchar(100) | yes | |
| UNIT | nvarchar(100) | yes | |
| ADDRESS | nvarchar(150) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/1/2024 11:53:58 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_NAMINGOPPORTUNITYFACILITY AS
select
NAMINGOPPORTUNITYFACILITY.ID,
NAMINGOPPORTUNITYFACILITY.NAME,
dbo.UFN_NAMINGOPPORTUNITYAREACODE_GETDESCRIPTION(NAMINGOPPORTUNITYFACILITY.AREACODEID) as AREA,
dbo.UFN_NAMINGOPPORTUNITYUNITCODE_GETDESCRIPTION(NAMINGOPPORTUNITYFACILITY.UNITCODEID) as UNIT,
NAMINGOPPORTUNITYFACILITY.ADDRESSBLOCK as ADDRESS
from
dbo.NAMINGOPPORTUNITYFACILITY;