v_FACT_EVENTREGISTRANTTOTAL
Contains aggregate information about event registrations.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTREGISTRANTFACTID | int | BBDW.[FACT_EVENTREGISTRANTTOTAL].[EVENTREGISTRANTFACTID] | |
| EVENTREGISTRANTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[EVENTREGISTRANTSYSTEMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[CONSTITUENTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[CONSTITUENTDIMID] |
| EVENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[EVENTSYSTEMID] |
| EVENTDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[EVENTDIMID] |
| COMMUNICATIONSSENT | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL][COMMUNICATIONSSENT] |
| GIFTSRECEIVED | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[GIFTSRECEIVED] |
| GIFTSFROMEMAIL | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[GIFTSFROMEMAIL] |
| GIFTSFROMSOCIALMEDIA | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[GIFTSFROMSOCIALMEDIA] |
| GROUPMEMBERS | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[GROUPMEMBERS] |
| OFFLINEGIFTS | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[OFFLINEGIFTS] |
| ONLINEGIFTS | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[ONLINEGIFTS] |
| PARTICIPANTSRECRUITED | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[PARTICIPANTSRECRUITED] |
| PERSONALPAGEVIEWS | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[PERSONALPAGEVIEWS] |
| SOCIALMEDIAPOSTS | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[SOCIALMEDIAPOSTS] |
| AMOUNTFROMEMAIL | money | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[AMOUNTFROMEMAIL] |
| AMOUNTFROMSOCIALMEDIA | money | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[AMOUNTFROMSOCIALMEDIA] |
| AMOUNTOFFLINE | money | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[AMOUNTOFFLINE] |
| AMOUNTONLINE | money | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[AMOUNTONLINE] |
| AMOUNTRAISED | money | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[AMOUNTRAISED] |
| AMOUNTRAISEDBYGROUP | money | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[AMOUNTRAISEDBYGROUP] |
| AMOUNTRAISEDBYPREVIOUSEVENT | money | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[AMOUNTRAISEDBYPREVIOUSEVENT] |
| AMOUNTSELFDONATION | money | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[AMOUNTSELFDONATION] |
| REGISTEREDFOREVENTTYPE | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[REGISTEREDFOREVENTTYPE] |
| RAISEDFOREVENTTYPE | money | yes | BBDW.[v_FACT_EVENTREGISTRANTTOTAL].[RAISEDFOREVENTTYPE] |
| FUNDRAISERTEAMSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[FUNDRAISERTEAMSYSTEMID] |
| FUNDRAISERTEAMDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[FUNDRAISERTEAMDIMID] |
| LASTLOGINDATE | datetime | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[LASTLOGINDATE] |
| REGISTRATIONOPTION | nvarchar(100) | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[REGISTRATIONOPTION] |
| REGISTRATIONREVENUEFACTID | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[REGISTRATIONREVENUEFACTID] |
| PENDINGGIFTAMOUNT | money | yes | BBDW.[v_FACT_EVENTREGISTRANTTOTAL].[PENDINGGIFTAMOUNT] |
| DONORRETENTION | decimal(20, 4) | yes | BBDW.[v_FACT_EVENTREGISTRANTTOTAL].[DONORRETENTION] |
| FINANCIALTRANSACTIONFACTID | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[FINANCIALTRANSACTIONFACTID] |
| FINANCIALTRANSACTIONLINEITEMFACTID | int | yes | BBDW.[FACT_EVENTREGISTRANTTOTAL].[FINANCIALTRANSACTIONLINEITEMFACTID] |
Definition
Copy
CREATE view [BBDW].[v_FACT_EVENTREGISTRANTTOTAL] as
select
[EVENTREGISTRANTFACTID],
[EVENTREGISTRANTSYSTEMID],
[CONSTITUENTSYSTEMID],
[CONSTITUENTDIMID],
[EVENTSYSTEMID],
[EVENTDIMID],
[COMMUNICATIONSSENT],
[GIFTSRECEIVED],
[GIFTSFROMEMAIL],
[GIFTSFROMSOCIALMEDIA],
[GROUPMEMBERS],
[OFFLINEGIFTS],
[ONLINEGIFTS],
[PARTICIPANTSRECRUITED],
[PERSONALPAGEVIEWS],
[SOCIALMEDIAPOSTS],
[AMOUNTFROMEMAIL],
[AMOUNTFROMSOCIALMEDIA],
[AMOUNTOFFLINE],
[AMOUNTONLINE],
[AMOUNTRAISED],
[AMOUNTRAISEDBYGROUP],
[AMOUNTRAISEDBYPREVIOUSEVENT],
[AMOUNTSELFDONATION],
[REGISTEREDFOREVENTTYPE],
[RAISEDFOREVENTTYPE],
[FUNDRAISERTEAMSYSTEMID],
[FUNDRAISERTEAMDIMID],
[LASTLOGINDATE],
[REGISTRATIONOPTION],
[REGISTRATIONREVENUEFACTID],
[PENDINGGIFTAMOUNT],
[DONORRETENTION],
[FINANCIALTRANSACTIONFACTID],
[FINANCIALTRANSACTIONLINEITEMFACTID]
from
[BBDW].[FACT_EVENTREGISTRANTTOTAL]