v_FACT_EVENTREGISTRANT
The event registrant fact table contains information event registrants.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTREGISTRANTFACTID | int | BBDW.[FACT_EVENTREGISTRANT].[EVENTREGISTRANTFACTID] | |
| EVENTDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[EVENTDIMID] |
| EVENTREGISTRATIONDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[EVENTREGISTRATIONDIMID] |
| EVENTSTARTDATEDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[EVENTSTARTDATEDIMID] |
| EVENTENDDATEDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[EVENTENDDATEDIMID] |
| APPEALDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[APPEALDIMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANT].[CONSTITUENTSYSTEMID] |
| CONSTITUENTAGE | int | yes | BBDW.[DIM_CONSTITUENT].[AGE] |
| CONSTITUENTINFORMATIONDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTINFORMATIONDIMID] |
| CONSTITUENTADDRESSDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSDIMID] |
| CONSTITUENTADDRESSDETAILDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSDETAILDIMID] |
| CONSTITUENTADDRESSFLAGDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSFLAGDIMID] |
| CONSTITUENTADDRESSTYPEDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSTYPEDIMID] |
| CONSTITUENTDEMOGRAPHICDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTDEMOGRAPHICDIMID] |
| APPEALENDDATEDIMID | int | yes | BBDW.[DIM_APPEAL].[APPEALENDDATEDIMID] |
| APPEALSTARTDATEDIMID | int | yes | BBDW.[DIM_APPEAL].[APPEALSTARTDATEDIMID] |
| COMMUNICATIONSTOSEND | int | yes | BBDW.[FACT_EVENTREGISTRANT].[COMMUNICATIONSTOSEND] |
| PARTICIPANTSTORECRUIT | int | yes | BBDW.[FACT_EVENTREGISTRANT].[PARTICIPANTSTORECRUIT] |
| DONORSTORETAIN | decimal(18, 0) | yes | BBDW.[FACT_EVENTREGISTRANT].[DONORSTORETAIN] |
| MONEYTORAISE | money | yes | BBDW.[FACT_EVENTREGISTRANT].[MONEYTORAISE] |
| REGISTRATIONFEE | money | yes | BBDW.[FACT_EVENTREGISTRANT].[REGISTRATIONFEE] |
| REGISTRATIONFEERECEIVED | money | yes | BBDW.[FACT_EVENTREGISTRANT].[REGISTRATIONFEERECEIVED] |
| COMPANYCONSTITUENTDIMID | int | yes | Reference key to the constituent dimension, derived from [dbo].[DIM_CONSTITUENT].[CONSTITUENTDIMID] |
| MODIFIEDBYAPPUSERDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[MODIFIEDBYAPPUSERDIMID] |
| MODIFIEDDATEDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[MODIFIEDDATEDIMID] |
| FUNDRAISERTEAMDIMID | int | yes | Reference key to the event group constituent dimension, derived from [dbo].[DIM_FUNDRAISERTEAM].[FUNDRAISERTEAMDIMID] |
| EVENTREGISTRATIONCODESDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[EVENTREGISTRATIONCODESDIMID] |
| HASIMAGEORVIDEO | bit | yes | BBDW.[FACT_EVENTREGISTRANT].[HASIMAGEORVIDEO] |
| HASSTORY | bit | yes | BBDW.[FACT_EVENTREGISTRANT].[HASSTORY] |
| PERSONALPAGEURL | nvarchar(2100) | yes | BBDW.[FACT_EVENTREGISTRANT].[PERSONALPAGEURL] |
| EVENTREGISTRANTLOOKUPID | nvarchar(200) | yes | BBDW.[FACT_EVENTREGISTRANT].[EVENTREGISTRANTLOOKUPID] |
| EVENTPRICEFACTID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[EVENTPRICEFACTID] |
Definition
Copy
CREATE view [BBDW].[v_FACT_EVENTREGISTRANT] as
select
er.[EVENTREGISTRANTFACTID],
er.[EVENTDIMID],
er.[EVENTREGISTRATIONDIMID],
er.[EVENTSTARTDATEDIMID],
er.[EVENTENDDATEDIMID],
er.[APPEALDIMID],
er.[CONSTITUENTDIMID],
er.[CONSTITUENTSYSTEMID],
c.[AGE] AS [CONSTITUENTAGE],
c.[CONSTITUENTINFORMATIONDIMID],
c.[CONSTITUENTADDRESSDIMID],
c.[CONSTITUENTADDRESSDETAILDIMID],
c.[CONSTITUENTADDRESSFLAGDIMID],
c.[CONSTITUENTADDRESSTYPEDIMID],
c.[CONSTITUENTDEMOGRAPHICDIMID],
a.[APPEALENDDATEDIMID],
a.[APPEALSTARTDATEDIMID],
er.[COMMUNICATIONSTOSEND],
er.[PARTICIPANTSTORECRUIT],
er.[DONORSTORETAIN],
er.[MONEYTORAISE],
er.[REGISTRATIONFEE],
er.[REGISTRATIONFEERECEIVED],
er.[COMPANYCONSTITUENTDIMID],
er.[MODIFIEDBYAPPUSERDIMID],
er.[MODIFIEDDATEDIMID],
er.[FUNDRAISERTEAMDIMID],
er.[EVENTREGISTRATIONCODESDIMID],
er.[HASIMAGEORVIDEO],
er.[HASSTORY],
er.[PERSONALPAGEURL],
er.[EVENTREGISTRANTLOOKUPID],
er.[EVENTPRICEFACTID]
from
BBDW.[FACT_EVENTREGISTRANT] er
inner join BBDW.[DIM_CONSTITUENT] c on er.[CONSTITUENTDIMID] = c.[CONSTITUENTDIMID]
inner join BBDW.[DIM_APPEAL] a on er.[APPEALDIMID] = a.[APPEALDIMID]