V_QUERY_GOALS
Query view used for goals of the faf event.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| EVENTID | uniqueidentifier | Event id | |
| REVENUETOTAL | money | Total revenue | |
| REVENUEMONTHLY | money | Monthly revenue | |
| REVENUEWEEKLY | money | Weekly revenue | |
| REVENUEDAILY | money | Daily revenue | |
| REVENUERETENTION | decimal(9, 5) | Percentage of total revenue to retain | |
| REVENUESPONSORS | money | Sponsors revenue | |
| REVENUESPONSORRETENTION | decimal(9, 5) | Percentage of sponsor revenue to retain | |
| REVENUECOMPANIES | money | Companies revenue | |
| REVENUECOMPANYRETENTION | decimal(9, 5) | Percentage of company revenue to retain | |
| REVENUETEAMS | money | Teams revenue | |
| REVENUETEAMRETENTION | decimal(9, 5) | Percentage of team revenue to retain | |
| REVENUEINDIVIDUAL | money | Participants revenue | |
| REVENUEINDIVIDUALRETENTION | decimal(9, 5) | Percentage of individual participant revenue to retain | |
| REVENUEHOUSEHOLD | money | Household revenue | |
| REVENUEHOUSEHOLDRETENTION | decimal(9, 5) | Percentage of households revenue to retain | |
| REVENUEREGISTRATION | money | Registration revenue | |
| REVENUEREGISTRATIONRETENTION | decimal(9, 5) | Percentage of registration revenue to retain | |
| RECRUITMENTFUNDRAISINGCOACHES | int | Recruitment fundraising coaches | |
| RECRUITMENTFUNDRAISINGCOACHESRETENTION | decimal(9, 5) | Recruitment percentage of fundraising coaches to retain | |
| RECRUITMENTFITNESSCOACHES | int | Recruitment fitness coaches | |
| RECRUITMENTFITNESSCOACHESRETENTION | decimal(9, 5) | Recruitment percentage of fitness coaches to retain | |
| RECRUITMENTDONORS | int | Recruitment donors | |
| RECRUITMENTDONORSRETENTION | decimal(9, 5) | Recruitment percentage of donors to retain | |
| RECRUITMENTSPONSORS | int | Recruitment sponsors | |
| RECRUITMENTSPONSORSRETENTION | decimal(9, 5) | Recruitment percentage of sponsors to retain | |
| RECRUITMENTCOMPANIES | int | Recruitment companies | |
| RECRUITMENTCOMPANIESRETENTION | decimal(9, 5) | Recruitment percentage of companies to retain | |
| RECRUITMENTTEAMS | int | Recruitment teams | |
| RECRUITMENTTEAMSRETENSION | decimal(9, 5) | Recruitment percentage of teams to retain | |
| RECRUITMENTINDIVIDUAL | int | Recruitment individual participants | |
| RECRUITMENTINDIVIDUALRETENTION | decimal(9, 5) | Recruitment percentage of individual participants to retain | |
| RECRUITMENTHOUSEHOLD | int | Recruitment households | |
| RECRUITMENTHOUSEHOLDRETENTION | decimal(9, 5) | Recruitment percentage of households to retain | |
| COMMUNICATIONTOTAL | int | Communication total | |
| COMMUNICATIONMONTHLY | int | Communication monthly | |
| COMMUNICATIONWEEKLY | int | Communication weekly | |
| COMMUNICATIONDAILY | int | Communication daily | |
| COMMUNICATIONSPONSOR | int | Communication sponsors | |
| COMMUNICATIONCOMPANY | int | Communication companies | |
| COMMUNICATIONTEAM | int | Communication teams | |
| COMMUNICATIONINDIVIDUAL | int | Communication individual participants | |
| COMMUNICATIONHOUSEHOLD | int | Communication households | |
| 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:05:47 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.9.1001.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_GOALS AS
SELECT EG.ID
,EG.EVENTID
/*Revenue*/
,EG.REVENUETOTAL AS REVENUETOTAL
,EG.REVENUEMONTHLY AS REVENUEMONTHLY
,EG.REVENUEWEEKLY AS REVENUEWEEKLY
,EG.REVENUEDAILY AS REVENUEDAILY
,EG.REVENUERETENTION AS REVENUERETENTION --Percentage of total revenue to retain
,EG.REVENUESPONSOR AS REVENUESPONSORS
,EG.REVENUESPONSORRETENTION AS REVENUESPONSORRETENTION --percentage of sponsor revenue to retain
,EG.REVENUECOMPANY AS REVENUECOMPANIES
,EG.REVENUECOMPANYRETENTION AS REVENUECOMPANYRETENTION --Percentage of company revenue to retain
,EG.REVENUETEAM AS REVENUETEAMS
,EG.REVENUETEAMRETENTION AS REVENUETEAMRETENTION --Percentage of team revenue to retain
,EG.REVENUEINDIVIDUAL AS REVENUEINDIVIDUAL
,EG.REVENUEINDIVIDUALRETENTION AS REVENUEINDIVIDUALRETENTION --Percentage of individual participant revenue to retain
,EG.REVENUEHOUSEHOLD --Household revenue
,EG.REVENUEHOUSEHOLDRETENTION --Percentage of household revenue to retain
,EG.REVENUEREGISTRATION -- registration revenue
,EG.REVENUEREGISTRATIONRETENTION --Percentage of registration revenue to retain
/*Recruitment*/
,EG.RECRUITMENTFUNDRAISINGCOACHES AS RECRUITMENTFUNDRAISINGCOACHES
,EG.RECRUITMENTFUNDRAISINGCOACHRETENTION AS RECRUITMENTFUNDRAISINGCOACHESRETENTION
,EG.RECRUITMENTFITNESSCOACHES AS RECRUITMENTFITNESSCOACHES
,EG.RECRUITMENTFITNESSCOACHRETENTION AS RECRUITMENTFITNESSCOACHESRETENTION
,EG.RECRUITMENTDONOR AS RECRUITMENTDONORS
,EG.RECRUITMENTDONORRETENTION AS RECRUITMENTDONORSRETENTION
,EG.RECRUITMENTSPONSOR AS RECRUITMENTSPONSORS
,EG.RECRUITMENTSPONSORRETENTION AS RECRUITMENTSPONSORSRETENTION
,EG.RECRUITMENTCOMPANY AS RECRUITMENTCOMPANIES
,EG.RECRUITMENTCOMPANYRETENTION AS RECRUITMENTCOMPANIESRETENTION
,EG.RECRUITMENTTEAM AS RECRUITMENTTEAMS
,EG.RECRUITMENTTEAMRETENTION AS RECRUITMENTTEAMSRETENSION
,EG.RECRUITMENTINDIVIDUAL AS RECRUITMENTINDIVIDUAL
,EG.RECRUITMENTINDIVIDUALRETENTION AS RECRUITMENTINDIVIDUALRETENTION
,EG.RECRUITMENTHOUSEHOLD
,EG.RECRUITMENTHOUSEHOLDRETENTION
/*Communication*/
,EG.COMMUNICATIONTOTAL
,EG.COMMUNICATIONMONTHLY
,EG.COMMUNICATIONWEEKLY
,EG.COMMUNICATIONDAILY
,EG.COMMUNICATIONSPONSOR
,EG.COMMUNICATIONCOMPANY
,EG.COMMUNICATIONTEAM
,EG.COMMUNICATIONINDIVIDUAL
,EG.COMMUNICATIONHOUSEHOLD
/*System Field*/
,ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION]
,ADDEDBY.USERNAME as [ADDEDBY_USERNAME]
,CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION]
,CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME]
,EG.DATEADDED
,EG.DATECHANGED
,EG.TSLONG
FROM dbo.EVENTGOAL AS EG
LEFT JOIN dbo.CHANGEAGENT AS [ADDEDBY] on [ADDEDBY].ID = EG.ADDEDBYID
LEFT JOIN dbo.CHANGEAGENT AS [CHANGEDBY] on [CHANGEDBY].ID = EG.CHANGEDBYID