V_QUERY_FUNDRAISINGGROUPS
Query view used for the fundraising group configuration of FAF events.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| EVENTID | uniqueidentifier | Event id | |
| INDIVIDUALSFUNDRAISE | bit | Individual participants can fundraise | |
| HOUSEHOLDSFUNDRAISE | bit | Households can fundraise | |
| HOUSEHOLDAPPROVEBYEVENTADMIN | bit | Event administrator must approve new households | |
| HOUSEHOLDMEMBERSLIMIT | int | Household members limit | |
| HOUSEHOLDSJOINTEAMS | bit | Households can join teams | |
| TEAMSFUNDRAISE | bit | Teams can fundraise | |
| PARTICIPANTSCANREACTIVATEHOUSEHOLDS | bit | Participants can reactivate households | |
| FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLD | nvarchar(73) | yes | Who can reactivate households |
| TEAMSREQUESTFUNDRAISE | bit | Event administrator must approve new teams | |
| TEAMLEADERAPPOINTTEAMCOLEADERS | tinyint | Number of team co-leaders team leader can appoint | |
| TEAMNAMECHANGEAFTERREG | bit | Team name can change after registration | |
| TEAMMEMBERSLIMIT | int | Team members limit | |
| PARTICIPANTSCANREACTIVATETEAMS | bit | Participants can reactivate teams | |
| FORMERTEAMCANREACTIVATETEAMS | nvarchar(58) | yes | Who can reactivate teams |
| COMPANIESFUNDRAISE | bit | Companies can fundraise | |
| COMPANYTEAMSAPPROVEBYEVENTADMIN | bit | Event administrator must approve new companies | |
| COMPANYLEADERAPPOINTCOMPANYCOLEADERS | tinyint | Number of company co-leaders company leader can appoint | |
| COMPANYNAMECHANGEAFTERREG | bit | Company name can change after registration | |
| COMPANYTEAMSLIMIT | int | Company teams limit | |
| COMPANYTEAMMEMBERSLIMIT | int | Company team members limit | |
| PARTICIPANTSCANREACTIVATECOMPANYTEAMS | bit | Participants can reactivate company teams | |
| FORMERCOMPANYCANREACTIVATETEAMS | nvarchar(77) | yes | Who can reactivate company teams |
| 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: 11/30/2010 11:36:34 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_FUNDRAISINGGROUPS AS
SELECT EC.ID
,EC.EVENTID
,EC.INDIVIDUALSFUNDRAISE --Individual participants can fundraise
,EC.HOUSEHOLDSFUNDRAISE --Households can fundraise
,EC.HOUSEHOLDAPPROVEBYEVENTADMIN --Event administrator must approve new households
,EC.HOUSEHOLDMEMBERSLIMIT --Household members limit
,EC.HOUSEHOLDSJOINTEAMS --Households can join teams
,EC.TEAMSFUNDRAISE --Teams can fundraise
,EC.PARTICIPANTSCANREACTIVATEHOUSEHOLDS --Participants can reactivate households
,EC.FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLD--Only former household leaders can reactivate households
--Former household leaders and household members can reactivate households
,EC.TEAMSREQUESTFUNDRAISE --Event administrator must approve new teams
,EC.TEAMLEADERAPPOINTTEAMCOLEADERS --Number of team co-leaders team leader can appoint
,EC.TEAMNAMECHANGEAFTERREG --Team name can change after registration
,EC.TEAMMEMBERSLIMIT --Team members limit
,EC.PARTICIPANTSCANREACTIVATETEAMS --Participants can reactivate teams
,EC.FORMERTEAMCANREACTIVATETEAMS--Only former team leaders can reactivate teams
--Former team leaders and team members can reactivate teams
,EC.COMPANIESFUNDRAISE --Companies can fundraise
,EC.COMPANYTEAMSAPPROVEBYEVENTADMIN --Event administrator must approve new companies
,EC.COMPANYLEADERAPPOINTCOMPANYCOLEADERS --Number of company co-leaders company leader can appoint
,EC.COMPANYNAMECHANGEAFTERREG --Company name can change after registration
,EC.COMPANYTEAMSLIMIT--Company teams limit
,EC.COMPANYTEAMMEMBERSLIMIT --Company team members limit
,EC.PARTICIPANTSCANREACTIVATECOMPANYTEAMS --Participants can reactivate company teams
,EC.FORMERCOMPANYCANREACTIVATETEAMS--Only former company leaders can reactivate company teams
--Former company leaders and company team leaders can reactivate company teams
--Any former company team member can reactivate a company team
--Coach assigned groups
--Number of group assignments per fundraising coach
--Automatically assign groups to fundraising coaches
--Manually assign groups to fundraising coaches
/*System Field*/
,ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION]
,ADDEDBY.USERNAME as [ADDEDBY_USERNAME]
,CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION]
,CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME]
,EC.DATEADDED
,EC.DATECHANGED
,EC.TSLONG
from dbo.EVENTTEAMFAFCONFIG EC
LEFT JOIN dbo.CHANGEAGENT AS [ADDEDBY] on [ADDEDBY].ID = EC.ADDEDBYID
LEFT JOIN dbo.CHANGEAGENT AS [CHANGEDBY] on [CHANGEDBY].ID = EC.CHANGEDBYID