V_QUERY_HOUSEHOLDGOALS
Query view used for household goals.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| EVENTPRICEID | uniqueidentifier | Event price id | |
| MINFUNDRAISING | money | Minimum fundraising goal | |
| ISNOTLOWERFUNDRAISING | bit | Cannot be lower than minimum fundraising goal | |
| PARTICIPANTMUSTPAYBALANCE | bit | Participant must pay balance | |
| PARTICIPANTPAYSBALANCEMESSAGE | nvarchar(1000) | Participant pays balance message | |
| TARGETFUNDRAISING | money | Target fundraising goal | |
| ISNOTLOWERTARGETFUNDRAISING | bit | Cannot be lower than target fundraising goal | |
| RECRUITEMENT | int | Number of participants to recruit | |
| DONORRETENTION | decimal(9, 4) | Percentage of donors to retain | |
| COMMUNICATIONS | int | Number of communications to send | |
| VOLUNTEERRECRUITEMENT | int | Number of volunteers to recruit | |
| UNIT | int | Number of other goal | |
| TEAMMEMBERS | int | Number of team members | |
| ISNOTLOWERTEAMMEMBERS | bit | Cannot be lower than number of household members | |
| TEAMMEMBERRETENTION | decimal(9, 4) | Percentage of household members to retain | |
| ISNOTLOWERTEAMMEMBERRETENTION | bit | Cannot be lower than percentage of household members to retain | |
| ISNOTLOWERCOMMUNICATION | bit | Cannot be lower than number of communications to send | |
| ISNOTLOWERRECRUITEMENT | bit | Cannot be lower than number of participants to recruit | |
| 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: 8/17/2011 2:51:11 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_HOUSEHOLDGOALS AS
select RTG.ID
,RTG.EVENTPRICEID
,RTG.MINFUNDRAISING --Minimum fundraising goal
,RTG.ISNOTLOWERFUNDRAISING --Cannot be lower than minimum fundraising goal
,RTG.PARTICIPANTMUSTPAYBALANCE --Participant must pay balance
,RTG.PARTICIPANTPAYSBALANCEMESSAGE --Participant pays balance message
,RTG.TARGETFUNDRAISING -- Target fundraising goal
,RTG.ISNOTLOWERTARGETFUNDRAISING --Cannot be lower than Target fundraising goal
,RTG.RECRUITEMENT --Number of participants to recruit
,RTG.DONORRETENTION --Percentage of donors to retain
,RTG.COMMUNICATIONS --Number of communications to send
,RTG.VOLUNTEERRECRUITEMENT --Number of volunteers to recruit
,RTG.UNIT --Number of other goal
,RTG.TEAMMEMBERS -- number of household members
,RTG.ISNOTLOWERTEAMMEMBERS -- cannot be lower than number of household members
,RTG.TEAMMEMBERRETENTION --Percentage of household members to retain
,RTG.ISNOTLOWERTEAMMEMBERRETENTION --Cannot be lower than percentage of household members to retain
,RTG.ISNOTLOWERCOMMUNICATION --Cannot be lower than number of communications to send
,RTG.ISNOTLOWERRECRUITEMENT --Cannot be lower than number of participants to recruit
--System Field
,ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION]
,ADDEDBY.USERNAME as [ADDEDBY_USERNAME]
,CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION]
,CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME]
,RTG.DATEADDED
,RTG.DATECHANGED
,RTG.TSLONG
FROM dbo.FAFREGISTRATIONTYPEGOAL RTG
LEFT JOIN dbo.CHANGEAGENT AS [ADDEDBY] on [ADDEDBY].ID = RTG.ADDEDBYID
LEFT JOIN dbo.CHANGEAGENT AS [CHANGEDBY] on [CHANGEDBY].ID = RTG.CHANGEDBYID
where RTG.REGTYPEGOALCODE=3