V_QUERY_REVENUEOPTIONS
Query view used for the revenue options of the faf event.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| EVENTID | uniqueidentifier | Event id | |
| ISUNPAIDPLEDGES | bit | Include unpaid pledges in raised to date | |
| ISSPONSORSHIPREVENUE | bit | Include sponsorship revenue in raised to date | |
| ISREGISTRATIONREVENUE | bit | Include registration revenue in raised to date | |
| UNCONFIRMEDPARTICIPANTGIFTENTRY | bit | Include unconfirmed participant gift entry in raised to date | |
| ISUNPAIDRECURRINGGIFTS | bit | Include unpaid recurring gifts in raised to date | |
| ISPENDINGMATCHINGGIFTS | bit | Include matching gift claims in raised to date | |
| ISENABLEDONATIONS | bit | Allow one-time donation gift type | |
| ISENABLERECURRINGGIFTS | bit | Allow recurring gift type | |
| ISENABLEPLEDGES | bit | Allow pledge gift type | |
| ISALLOWTEAMDONATIONS | bit | Allow gifts to team | |
| ISALLOWCOMPANYDONATIONS | bit | Allow gifts to company | |
| ISALLOWEVENTDONATIONS | bit | Allow gifts to event | |
| ISALLOWDONATIONSFROMORGS | bit | Allow gifts from organizations | |
| ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR | bit | Allow participants to enter gifts | |
| MINIMUMDONATIONAMOUNT | money | Gift minimum amount | |
| MAXIMUMTRANSACTIONAMOUNT | money | Gift maximum amount | |
| 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 |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/1/2011 9:11:22 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.9.1001.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REVENUEOPTIONS AS
select FEDOC.ID
,FEDOC.EVENTID
,FEDOC.ISUNPAIDPLEDGES--Include unpaid pledges in raised to date
,FEDOC.ISSPONSORSHIPREVENUE --Include sponsorship revenue in raised to date
,FEDOC.ISREGISTRATIONREVENUE --Include registration revenue in raised to date
,FEDOC.UNCONFIRMEDPARTICIPANTGIFTENTRY--Include unconfirmed participant gift entry in raised to date
,FEDOC.ISUNPAIDRECURRINGGIFTS --Include unpaid recurring gifts in raised to date
--,FEDOC.ISUNPAIDSPONSORSHIPREVENUE --Include unpaid sponsorship revenue in raised to date
,FEDOC.ISPENDINGMATCHINGGIFTS--Include matching gift claims in raised to date
,FEDOC.ISENABLEDONATIONS--Allow one-time donation gift type
,FEDOC.ISENABLERECURRINGGIFTS--Allow recurring gift type
,FEDOC.ISENABLEPLEDGES --Allow pledge gift type
,FEDOC.ISALLOWTEAMDONATIONS--Allow gifts to team
,FEDOC.ISALLOWCOMPANYDONATIONS --Allow gifts to company
,FEDOC.ISALLOWEVENTDONATIONS --Allow gifts to event
,FEDOC.ISALLOWDONATIONSFROMORGS--Allow gifts from organizations
,FEDOC.ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR--Allow participants to enter gifts
,FEDOC.MINIMUMDONATIONAMOUNT --Gift minimum amount
,FEDOC.MAXIMUMTRANSACTIONAMOUNT --Gift maximum amount
--system fields
,ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
FEDOC.DATEADDED,
FEDOC.DATECHANGED,
FEDOC.TSLONG
from dbo.FAFEVENTDONATIONOPTIONSCONFIG FEDOC
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = FEDOC.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = FEDOC.CHANGEDBYID