| EVENTREGISTRANTSYSTEMID |
uniqueidentifier |
yes |
|
BBDW.[FACT_EVENTREGISTRANT].[EVENTREGISTRANTSYSTEMID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
BBDW.[FACT_EVENTREGISTRANT].[CONSTITUENTSYSTEMID] |
| CONSTITUENTDIMID |
int |
yes |
|
BBDW.[FACT_EVENTREGISTRANT].[CONSTITUENTDIMID] |
| EVENTSYSTEMID |
uniqueidentifier |
yes |
|
BBDW.[FACT_EVENTREGISTRANT].[EVENTSYSTEMID] |
| EVENTDIMID |
int |
yes |
|
BBDW.[DIM_EVENT].[EVENTDIMID] |
| COMMUNICATIONSSENT |
int |
yes |
|
Count of rows from dbo.[FAFCOMMUNICATIONSLOG] |
| GIFTSRECEIVED |
int |
yes |
|
dbo.[FAFRAISEDTOTAL_CATEGORIZED].[GIFTCOUNT_ALL] |
| GIFTSFROMEMAIL |
int |
yes |
|
dbo.[FAFRAISEDTOTAL_CATEGORIZED].[GIFTCOUNT_FROMEMAIL] |
| GIFTSFROMSOCIALMEDIA |
int |
yes |
|
dbo.[FAFRAISEDTOTAL_CATEGORIZED].[GIFTCOUNT_FROMSOCIALMEDIA] |
| GROUPMEMBERS |
int |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION].[TOTALGROUPS] |
| OFFLINEGIFTS |
int |
yes |
|
dbo.[FAFRAISEDTOTAL_CATEGORIZED].[GIFTCOUNT_OFFLINE] |
| ONLINEGIFTS |
int |
yes |
|
dbo.[FAFRAISEDTOTAL_CATEGORIZED].[GIFTCOUNT_ONLINE] |
| PARTICIPANTSRECRUITED |
int |
yes |
|
aggregate from dbo.[FAFCOMMUNICATIONSLOG] and dbo.[FAFEVENTCOMMUNICATIONCHANNEL] |
| PERSONALPAGEVIEWS |
int |
yes |
|
aggregate from dbo.[FAFCOMMUNICATIONSLOG].[PAGEVISITS] |
| SOCIALMEDIAPOSTS |
int |
yes |
|
aggregate count from dbo.[FAFEVENTSOCIALNETWORKPOST] and dbo.[REGISTRANT] |
| AMOUNTFROMEMAIL |
money |
yes |
|
dbo.[FAFRAISEDTOTAL_CATEGORIZED].[AMOUNT_FROMEMAIL] |
| AMOUNTFROMSOCIALMEDIA |
money |
yes |
|
dbo.[FAFRAISEDTOTAL_CATEGORIZED].[AMOUNT_FROMSOCIALMEDIA] |
| AMOUNTOFFLINE |
money |
yes |
|
dbo.[FAFRAISEDTOTAL_CATEGORIZED].[AMOUNT_OFFLINE] |
| AMOUNTONLINE |
money |
yes |
|
dbo.[FAFRAISEDTOTAL_CATEGORIZED].[AMOUNT_ONLINE] |
| AMOUNTRAISED |
money |
yes |
|
dbo.[FAFRAISEDTOTAL].[RECEIVEDAMOUNT] |
| AMOUNTRAISEDBYGROUP |
money |
yes |
|
dbo.[FAFGROUPSUMMARYINFORMATION].[TOTALFUNDRAISE] |
| AMOUNTRAISEDBYPREVIOUSEVENT |
money |
yes |
|
Calculated from BBDW.[DIM_EVENT].[AMOUNTRAISEDBYPREVIOUSEVENT] |
| AMOUNTSELFDONATION |
money |
yes |
|
dbo.[FAFRAISEDTOTAL_CATEGORIZED].[AMOUNT_SELF] |
| REGISTEREDFOREVENTTYPE |
int |
yes |
|
Check previous registrations BBDW.[FACT_EVENTREGISTRANT] using BBDW.[DIM_EVENT].[EVENTTYPE] |
| FUNDRAISERTEAMSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[TEAMFUNDRAISINGTEAM].[ID] |
| FUNDRAISERTEAMDIMID |
int |
yes |
|
Reference key to the fundraiser team dimension, derived from dbo.[TEAMFUNDRAISINGTEAM].[ID] |
| LASTLOGINDATE |
datetime |
yes |
|
dbo.[CLIENTUSERS].[DATELASTLOGIN] |
| REGISTRATIONOPTION |
nvarchar(100) |
yes |
|
dbo.[EVENTPRICE].[NAME] |
| REGISTRATIONREVENUEFACTID |
int |
yes |
|
BBDW.[FACT_REVENEUE].[REVENUEFACTID] |
| 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. |
| RAISEDFOREVENTTYPE |
money |
yes |
|
Aggregate of BBDW.[FACT_EVENTREGISTRANTTOTAL].[AMOUNTRAISED] per event type |
| PENDINGGIFTAMOUNT |
money |
yes |
|
[dbo].[FAFREGISTRANTPENDINGSUMMARY].[TRANSACTIONAMOUNT] - [dbo].[FAFREGISTRANTPENDINGSUMMARY].[TOTALAMOUNTRECEIVED] |
| DONORRETENTION |
decimal(20, 4) |
yes |
|
[dbo].[FAFREGISTRANTPREVIOUSSUMMARY].[DONORRETENTION] |
| FINANCIALTRANSACTIONFACTID |
int |
yes |
|
Reference key to financial transaction fact table, derived from [dbo].[FINANCIALTRANSACTION].[ID] |
| FINANCIALTRANSACTIONLINEITEMFACTID |
int |
yes |
|
Reference key to financial transaction line item fact table, derived from [dbo].[FINANCIALTRANSACTIONLINEITEM].[ID] |