V_QUERY_DESIGNATIONLEVEL
Query view used for fundraising purpose information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(100) | Name | |
| DESCRIPTION | nvarchar(255) | Description | |
| CATEGORYCODEID_TRANSLATION | nvarchar(100) | yes | Category |
| DESIGNATIONLEVELTYPE | nvarchar(100) | yes | Type |
| ADMINISTRATORID_TRANSLATION | nvarchar(154) | yes | Administrator name |
| ADMINISTRATORID | uniqueidentifier | yes | Administrator system ID |
| USERID | nvarchar(100) | Lookup ID | |
| REPORTCODE1NAME | nvarchar(100) | yes | Report code 1 |
| REPORTCODE2NAME | nvarchar(100) | yes | Report code 2 |
| ISACCEPTINGFUNDS | bit | Is accepting funds | |
| ISDISBURSINGMONEY | bit | Is disbursing money | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| SITENAME | nvarchar(250) | yes | Site |
| VANITYNAME | nvarchar(512) | Public name | |
| STATEMENTWORDING | nvarchar(max) | Statement wording | |
| TIMEPERIOD | nvarchar(14) | yes | Frequency |
| ISENDOWED | bit | Is endowed | |
| ISFULLYFUNDED | bit | Is fully funded | |
| ISINCOMETOPRINCIPAL | bit | Is income to principal | |
| INCOMETOPRINCIPALPERCENT | decimal(5, 2) | Income to principal % | |
| ENDOWMENTMINAMOUNT | money | Minimum amount for endowment | |
| ENDOWMENTTARGETDATE | date | yes | Target date for endowment |
| ENDOWMENTMINAMOUNTDATEMET | date | yes | Date minimum amount met |
| ORGANIZATIONENDOWMENTMINAMOUNT | money | Minimum amount for endowment (organization currency) | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | Currency exchange rate |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| SITEID | uniqueidentifier | yes | Site ID |
| STEWARDSHIPPACKAGE | nvarchar(100) | yes | Stewardship Package |
| DESIGNATIONLEVELCATEGORYCODEID | uniqueidentifier | yes | |
| DESIGNATIONREPORT1CODEID | uniqueidentifier | yes | |
| DESIGNATIONREPORT2CODEID | uniqueidentifier | yes | |
| DESIGNATIONLEVELTYPEID | uniqueidentifier | ||
| STEWARDSHIPPACKAGEPROCESSID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:48 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_DESIGNATIONLEVEL AS
select
DESIGNATIONLEVEL.ID,
DESIGNATIONLEVEL.NAME,
DESIGNATIONLEVEL.DESCRIPTION,
(select DESIGNATIONLEVELCATEGORYCODE.DESCRIPTION from dbo.DESIGNATIONLEVELCATEGORYCODE where DESIGNATIONLEVELCATEGORYCODE.ID = DESIGNATIONLEVEL.DESIGNATIONLEVELCATEGORYCODEID) as CATEGORYCODEID_TRANSLATION,
FPT.DESCRIPTION as DESIGNATIONLEVELTYPE,
dbo.UFN_CONSTITUENT_BUILDNAME(DESIGNATIONLEVEL.ADMINISTRATORID) as ADMINISTRATORID_TRANSLATION,
DESIGNATIONLEVEL.ADMINISTRATORID,
DESIGNATIONLEVEL.USERID,
DESIGNATIONREPORT1CODE.DESCRIPTION as [REPORTCODE1NAME],
DESIGNATIONREPORT2CODE.DESCRIPTION as [REPORTCODE2NAME],
DESIGNATIONLEVEL.ISACCEPTINGFUNDS,
DESIGNATIONLEVEL.ISDISBURSINGMONEY,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
DESIGNATIONLEVEL.DATEADDED,
DESIGNATIONLEVEL.DATECHANGED,
DESIGNATIONLEVEL.TSLONG,
COALESCE((SELECT NAME FROM dbo.SITE WHERE ID=DESIGNATIONLEVEL.SITEID),'') AS SITENAME,
DESIGNATIONLEVEL.VANITYNAME,
DESIGNATIONLEVEL.STATEMENTWORDING,
DESIGNATIONLEVEL.TIMEPERIOD,
DESIGNATIONLEVEL.ISENDOWED,
DESIGNATIONLEVEL.ISFULLYFUNDED,
DESIGNATIONLEVEL.ISINCOMETOPRINCIPAL,
DESIGNATIONLEVEL.INCOMETOPRINCIPALPERCENT,
DESIGNATIONLEVEL.ENDOWMENTMINAMOUNT,
DESIGNATIONLEVEL.ENDOWMENTTARGETDATE,
DESIGNATIONLEVEL.ENDOWMENTMINAMOUNTDATEMET,
DESIGNATIONLEVEL.ORGANIZATIONENDOWMENTMINAMOUNT,
DESIGNATIONLEVEL.ORGANIZATIONEXCHANGERATEID,
DESIGNATIONLEVEL.BASECURRENCYID,
DESIGNATIONLEVEL.SITEID,
COALESCE((SELECT NAME FROM dbo.STEWARDSHIPPACKAGEPROCESS WHERE ID=DESIGNATIONLEVEL.STEWARDSHIPPACKAGEPROCESSID),'') AS STEWARDSHIPPACKAGE,
[DESIGNATIONLEVEL].[DESIGNATIONLEVELCATEGORYCODEID],
[DESIGNATIONLEVEL].[DESIGNATIONREPORT1CODEID],
[DESIGNATIONLEVEL].[DESIGNATIONREPORT2CODEID],
[DESIGNATIONLEVEL].[DESIGNATIONLEVELTYPEID],
[DESIGNATIONLEVEL].[STEWARDSHIPPACKAGEPROCESSID]
/*#EXTENSION*/
from
dbo.DESIGNATIONLEVEL
left join dbo.DESIGNATIONLEVELTYPE FPT on DESIGNATIONLEVEL.DESIGNATIONLEVELTYPEID = FPT.ID
left join dbo.DESIGNATIONREPORT1CODE on DESIGNATIONLEVEL.DESIGNATIONREPORT1CODEID = DESIGNATIONREPORT1CODE.ID
left join dbo.DESIGNATIONREPORT2CODE on DESIGNATIONLEVEL.DESIGNATIONREPORT2CODEID = DESIGNATIONREPORT2CODE.ID
left join dbo.CHANGEAGENT as ADDEDBY ON ADDEDBY.ID = DESIGNATIONLEVEL.ADDEDBYID
left join dbo.CHANGEAGENT as CHANGEDBY ON CHANGEDBY.ID = DESIGNATIONLEVEL.CHANGEDBYID