FACT_EVENTREGISTRANT_STAGE

Contains information about an event registrations.

Fields

Field	Field Type	Null	Notes	Description
EVENTREGISTRANTSYSTEMID	uniqueidentifier	yes		[dbo].[REGISTRANT].[ID]
EVENTDIMID	int	yes		Reference key to the event dimension, derived from [dbo].[REGISTRANT].[EVENTID]
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]
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
COMPANYCONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[REGISTRANTEXTENSION].[ORGANIZATIONCONSTITUENTID]
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]
ISCOMPANYREGISTRATION	bit	yes		If dbo.[REGISTRANTEXTENSION].[ORGANIZATIONCONSTITUENTID] is not null then yes
ISPREVIOUSPARTICIPANT	bit	yes		Is dbo.[REGISTRANTEXTENSION].[ID] empty
ATTENDED	bit	yes		dbo.[REGISTRANT].[ATTENDED]
WILLNOTATTEND	bit	yes		dbo.[REGISTRANT].[WILLNOTATTEND]
BENEFITSWAIVED	bit	yes		dbo.[REGISTRANT].[BENEFITSWAIVED]
ISCANCELLED	bit	yes		dbo.[REGISTRANT].[ISCANCELLED]
ONLINEREGISTRANT	bit	yes		dbo.[REGISTRANT].[ONLINEREGISTRANT]
EVENTSYSTEMID	uniqueidentifier	yes		dbo.[EVENT].[ID]
INBOUNDCHANNEL	nvarchar(50)	yes		Default value of "Website"
RECRUITMENTCHANNEL	nvarchar(30)	yes		dbo.[FAFEVENTCOMMUNICATIONCHANNEL].[CHANNEL]
FUNDRAISERTEAMDIMID	int	yes		Reference key to the DIM_FUNDRAISERTEAM dimension derived from dbo.[TEAMFUNDRAISER].[ID]
EVENTREGISTRATIONCODESDIMID	int	yes		Reference key to the event registration channel dimension derived from dbo.[TEAMFUNDRAISER].[ID] and dbo.[TEAMFUNDRAISERTEAMCAPTAIN].[ID]
EVENTREGISTRANTLOOKUPID	nvarchar(200)	yes		[dbo].[REGISTRANT].[LOOKUPID]
EVENTPRICEFACTID	int	yes		Surrogate key to the Event Price Fact, derived from dbo.[REGISTRANTREGISTRATION].[EVENTPRICEID]