V_QUERY_COMPANYGOALS
Query view used for company goals.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| EVENTPRICEID | uniqueidentifier | Event price id | |
| MINFUNDRAISING | money | Fundraising total amount | |
| TEAMS | int | Number of teams | |
| TEAMRETENTION | decimal(9, 4) | Percentage of teams to retain | |
| TEAMMEMBERS | int | Number of team members | |
| TEAMMEMBERRETENTION | decimal(9, 4) | Percentage of team members to retain | |
| RECRUITEMENT | int | Number of participants to recruit | |
| COMMUNICATIONS | int | Number of communications to send | |
| VOLUNTEERRECRUITEMENT | int | Number of volunteers to recruit | |
| UNIT | int | Number of other goal | |
| ISNOTLOWERFUNDRAISING | bit | Cannot be lower than fundraising total amount | |
| ISNOTLOWERTEAMS | bit | Cannot be lower than number of teams | |
| ISNOTLOWERTEAMRETENTION | bit | Cannot be lower than percentage of teams to retain | |
| ISNOTLOWERTEAMMEMBERS | bit | Cannot be lower than number of team members | |
| ISNOTLOWERTEAMMEMBERRETENTION | bit | Cannot be lower than percentage of team members to retain | |
| ISNOTLOWERRECRUITEMENT | bit | Cannot be lower than number of participants to recruit | |
| ISNOTLOWERCOMMUNICATION | bit | Cannot be lower than number of communications to send | |
| 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:19:42 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_COMPANYGOALS AS
select RTG.ID
,RTG.EVENTPRICEID
,RTG.MINFUNDRAISING --Fundraising total amount
,RTG.TEAMS --Number of teams
,RTG.TEAMRETENTION --Percentage of teams to retain
,RTG.TEAMMEMBERS --Number of team members
,RTG.TEAMMEMBERRETENTION --Percentage of team members to retain
,RTG.RECRUITEMENT --Number of participants to recruit
,RTG.COMMUNICATIONS --Number of communications to send
,RTG.VOLUNTEERRECRUITEMENT --Number of volunteers to recruit
,RTG.UNIT --Number of other goal
,RTG.ISNOTLOWERFUNDRAISING --Cannot be lower than fundraising total amount
,RTG.ISNOTLOWERTEAMS --Cannot be lower than number of teams
,RTG.ISNOTLOWERTEAMRETENTION --Cannot be lower than percentage of teams to retain
,RTG.ISNOTLOWERTEAMMEMBERS --Cannot be lower than number of team members
,RTG.ISNOTLOWERTEAMMEMBERRETENTION --Cannot be lower than percentage of team members to retain
,RTG.ISNOTLOWERRECRUITEMENT --Cannot be lower than number of participants to recruit
,RTG.ISNOTLOWERCOMMUNICATION --Cannot be lower than number of communications to send
--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=2