V_SEARCH_DESIGNATIONLEVEL
Search screen for finding Fundraising Purpose records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(100) | ||
| TYPE | nvarchar(100) | yes | |
| CATEGORY | nvarchar(100) | yes | |
| USERID | nvarchar(100) | ||
| DESIGNATIONREPORT1CODEID | uniqueidentifier | yes | |
| DESIGNATIONREPORT2CODEID | uniqueidentifier | yes | |
| SITE | nvarchar(250) | yes | |
| VANITYNAME | nvarchar(512) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/1/2024 11:54:13 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_DESIGNATIONLEVEL AS
select DESIGNATIONLEVEL.ID,
DESIGNATIONLEVEL.NAME,
DESIGNATIONLEVELTYPE.DESCRIPTION [TYPE],
DESIGNATIONLEVELCATEGORYCODE.DESCRIPTION [CATEGORY],
DESIGNATIONLEVEL.USERID,
DESIGNATIONLEVEL.DESIGNATIONREPORT1CODEID,
DESIGNATIONLEVEL.DESIGNATIONREPORT2CODEID,
SITE.NAME [SITE],
DESIGNATIONLEVEL.VANITYNAME
from dbo.DESIGNATIONLEVEL
left join dbo.DESIGNATIONLEVELCATEGORYCODE on DESIGNATIONLEVEL.DESIGNATIONLEVELCATEGORYCODEID = DESIGNATIONLEVELCATEGORYCODE.ID
left join dbo.SITE on DESIGNATIONLEVEL.SITEID = SITE.ID
left join dbo.DESIGNATIONLEVELTYPE on DESIGNATIONLEVEL.DESIGNATIONLEVELTYPEID = DESIGNATIONLEVELTYPE.ID
;