V_QUERY_RECOGNITIONLEVEL

Provides the ability to query recognition levels.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
NAME	nvarchar(100)		Name
RECOGNITIONPROGRAMID	uniqueidentifier		Recognition program ID
DESCRIPTION	nvarchar(255)		Description
TIER	nvarchar(100)	yes	Tier
AMOUNT	money	yes	Minimum recognition amount
PLANNEDGIFTAMOUNT	money	yes	Planned giving amount
ISACTIVE	bit		Active
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
BASECURRENCYID	uniqueidentifier	yes	Base currency ID
ORGANIZATIONAMOUNT	money	yes	Minimum amount (organization currency)
ORGANIZATIONPLANNEDGIFTAMOUNT	money	yes	Planned giving amount (organization currency)
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes	Currency exchange rate

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  2/1/2011 9:13:28 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.9.1001.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RECOGNITIONLEVEL AS



            select
                    RL.ID,
                    RL.NAME,
                    RL.RECOGNITIONPROGRAMID,
                    RL.DESCRIPTION,
                    TIERCODE.DESCRIPTION as TIER,
                    dbo.UFN_RECOGNITIONLEVEL_GETAMOUNTBYDATE(RL.ID,getdate()) AS AMOUNT,
                    dbo.UFN_RECOGNITIONLEVEL_GETPLANNEDGIFTAMOUNTBYDATE(RL.ID,getdate()) AS PLANNEDGIFTAMOUNT,
                    RL.ISACTIVE,
                    ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
                    ADDEDBY.USERNAME as ADDEDBY_USERNAME,
                    CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
                    CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
                    RL.DATEADDED,
                    RL.DATECHANGED,
                    RL.TSLONG,
                    RL.BASECURRENCYID,
                    RL.ORGANIZATIONAMOUNT,
                    RL.ORGANIZATIONPLANNEDGIFTAMOUNT,
                    RL.ORGANIZATIONEXCHANGERATEID

                    /*#EXTENSION*/
                from
                    dbo.RECOGNITIONLEVEL as RL
                inner join
                    dbo.RECOGNITIONPROGRAM as RP
                on
                    RP.ID = RL.RECOGNITIONPROGRAMID
                left join 
                    dbo.TIERCODE 
                on 
                    TIERCODE.ID = RL.TIERCODEID
                left join
                    dbo.CHANGEAGENT as ADDEDBY
                on 
                    ADDEDBY.ID = RL.ADDEDBYID
                left join
                    dbo.CHANGEAGENT as CHANGEDBY
                on
                    CHANGEDBY.ID = RL.CHANGEDBYID