| EVENTREGISTRANTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[REGISTRANT].[ID] |
| EVENTDIMID |
int |
yes |
|
Reference key to the event dimension, derived from [dbo].[REGISTRANT].[EVENTID] |
| EVENTREGISTRATIONDIMID |
int |
yes |
|
Reference key to the event dimension, derived from [dbo].[REGISTRANT].[ATTENDED], [dbo].[REGISTRANT].[WILLNOTATTEND], [dbo].[REGISTRANT].[BENEFITSWAIVED], [dbo].[REGISTRANT].[ONLINEREGISTRANT], and [dbo].[REGISTRANT].[ISCANCELLED] |
| EVENTSTARTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from [dbo].[REGISTRANT].[EVENTID] |
| EVENTENDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from [dbo].[REGISTRANT].[EVENTID] |
| APPEALDIMID |
int |
yes |
|
Reference key to the appeal dimension, derived from [dbo].[REGISTRANT].[EVENTID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from [dbo].[REGISTRANT].[CONSTITUENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[REGISTRANT].[CONSTITUENTID] |
| 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. |
| DATEADDEDDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[REGISTRANT].[DATEADDED] |
| DATEADDED |
datetime |
yes |
|
dbo.[REGISTRANT].[DATEADDED] |
| COMMUNICATIONSTOSEND |
int |
yes |
|
dbo.[REGISTRANTEXTENSION].[COMMUNICATIONGOAL] |
| PARTICIPANTSTORECRUIT |
int |
yes |
|
dbo.[REGISTRANTEXTENSION].[MEMBERECRUITMENTGOAL] |
| MONEYTORAISE |
money |
yes |
|
dbo.[REGISTRANTEXTENSION].[FUNDRAISINGGOAL] |
| DONORSTORETAIN |
decimal(18, 0) |
yes |
|
dbo.[REGISTRANTEXTENSION].[DONORRETENTIONGOAL] * 100 |
| REGISTRATIONFEE |
money |
yes |
|
dbo.[EVENTPRICE].[AMOUNT] |
| REGISTRATIONFEERECEIVED |
money |
yes |
|
dbo.[REGISTRANTREGISTRATION].[AMOUNT] |
| COMPANYCONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[REGISTRANTEXTENSION].[ORGANIZATIONCONSTITUENTID] |
| COMPANYCONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from [dbo].[DIM_CONSTITUENT][CONSTITUENTDIMID] |
| MODIFIEDBYAPPUSERDIMID |
int |
yes |
|
Reference key to DIM_APPUSER dimension derived from dbo.[REGISTRANTEXTENSION].[MODIFIEDBY] and dbo.[CHANGEAGENT].[USERNAME] |
| MODIFIEDDATE |
datetime |
yes |
|
dbo.[REGISTRANT].[DATECHANGED] |
| MODIFIEDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from [dbo].[REGISTRANT].[MODIFIEDDATE] |
| EVENTREGISTRATIONCODESDIMID |
int |
yes |
|
Reference key to the Event registration channel dimension derived from dbo.[DIM_EVENTREGISTRATIONCHANNEL].[EVENTREGISTRATIONCHANNELDIMID] |
| EVENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[EVENT].[ID] |
| FUNDRAISERTEAMDIMID |
int |
yes |
|
Reference key to the fundraiser team dimension derived from dbo.[TEAMFUNDRAISER].[ID] |
| HASIMAGEORVIDEO |
bit |
yes |
|
If exists in [dbo].[STORY].[FAFIMAGESID] |
| HASSTORY |
bit |
yes |
|
If exists in [dbo].[STORY].[STORYTEXT] |
| PERSONALPAGEURL |
nvarchar(2100) |
yes |
|
[dbo].[CMSSITESETTING].[VALUE] where [ENUMID] = 11 + [dbo].[VANITYURL].[VANITYURL] |
| EVENTREGISTRANTLOOKUPID |
nvarchar(200) |
yes |
|
[dbo].[REGISTRANT].[LOOKUPID] |
| EVENTPRICEFACTID |
int |
yes |
|
Reference key for event price fact table BBDW.[FACT_EVENTPRICE] |