| FUNDRAISERTEAMSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[ID] |
| FUNDRAISERTEAMDIMID |
int |
yes |
|
Reference key to the fundraiserteam dimension, derived from dbo.[FAFGROUPSUMMARYINFORMATION].[ID] |
| EVENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[EVENTID] |
| EVENTDIMID |
int |
yes |
|
Reference key to the event dimension, derived from dbo.[FAFGROUPSUMMARYINFORMATION].[EVENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION].[GROUPCONSTITUENTID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[FAFGROUPSUMMARYINFORMATION].[GROUPCONSTITUENTID] |
| COUNTGROUPS |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION].[TOTALGROUPS] |
| COUNTPARTICIPANTS |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION].[TOTALPARTICIPANTS] |
| COUNTDONORS |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION].[TOTALDONORCOUNT] |
| COUNTGIFTSRECEIVED |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION].[TOTALGIFTCOUNT] |
| COUNTGIFTSFROMEMAIL |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_FROMEMAIL] |
| COUNTGIFTSFROMSOCIALMEDIA |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_FROMSOCIALMEDIA] |
| COUNTONLINEGIFTS |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_ONLINE] |
| COUNTOFFLINEGIFTS |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_OFFLINE] |
| COUNTCOMMUNICATIONSSENT |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION].[TOTALCOMMUNICATIONSENT] |
| COUNTSOCIALMEDIAPOSTS |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[COUNT_SOCIALMEDIAPOSTS] |
| COUNTREGISTEREDFOREVENTTYPE |
int |
yes |
|
Aggregate of BBDW.[FACT_FUNDRAISERTEAMTOTAL].[TOTALPARTICIPANTS] for all events of group BBDW.[DIM_EVENT].[EVENTTYPE] |
| PCTGROUPSRETAINED |
decimal(9, 2) |
yes |
|
Percentage of BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTGROUPS] relative to previous event |
| PCTPARTICIPANTSRETAINED |
decimal(9, 2) |
yes |
|
Percentage of BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTPARTICIPANTS] relative to previous event |
| PCTDONORSRETAINED |
decimal(9, 2) |
yes |
|
Percentage of BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTDONORS] relative to previous event |
| PCTZERORAISEDPARTICIPANTS |
decimal(9, 2) |
yes |
|
Percentage of count BBDW.[FACT_EVENTREGISTRANTTOTAL] with [AMOUNTRAISED] = 0 relative to count all BBDW.[FACT_EVENTREGISTRANTTOTAL] by team |
| AMOUNTRAISED |
money |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION].[TOTALFUNDRAISE] |
| AMOUNTFROMEMAIL |
money |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_FROMEMAIL] |
| AMOUNTFROMSOCIALMEDIA |
money |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_FROMSOCIALMEDIA] |
| AMOUNTONLINE |
money |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_ONLINE] |
| AMOUNTOFFLINE |
money |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_OFFLINE] |
| AMOUNTRAISEDFOREVENTTYPE |
money |
yes |
|
Aggregate amount of BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTRAISED] for all events of group BBDW.[DIM_EVENT].[EVENTTYPE] |
| AMOUNTRAISEDBYPREVIOUSEVENT |
money |
yes |
|
Copied from BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTRAISED] for BBDW.[DIM_EVENT].[PRIORYEAREVENTDIMID] |
| AMOUNTSELFDONATION |
money |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_SELF] |
| AMOUNTALLREGISTRATIONFEES |
money |
yes |
|
Aggregate amount of dbo.[EVENTPRICE].[AMOUNT] per event |
| AMOUNTRECEIVEDREGISTRATIONFEES |
money |
yes |
|
Aggregate amount of dbo.[FAFRAISEDTOTAL].[REGAMOUNT] |
| AMOUNTPENDING |
money |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_PENDING] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| COUNTGIFTSBYPARTICIPANTS |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_PARTICIPANTS] |
| AMOUNTBYPARTICIPANTS |
money |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_PARTICIPANTS] |
| COUNTGIFTSSELFDONATION |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_SELF] |