FACT_FUNDRAISERINTERACTIONADDITIONAL_STAGE

Intermediate storage for additional participants on an interaction.

Fields

Field	Field Type	Null	Notes	Description
FUNDRAISERINTERACTIONADDITIONALSYSTEMID	uniqueidentifier	yes		dbo.[INTERACTIONADDITIONALFUNDRAISER].[ID]
INTERACTIONSYSTEMID	uniqueidentifier	yes		dbo.[INTERACTIONADDITIONALFUNDRAISER].[INTERACTIONID]
ADDITIONALFUNDRAISERDIMID	int	yes		Reference key to the fundraiser dimension, derived from dbo.[INTERACTIONADDITIONALFUNDRAISER].[FUNDRAISERID]
ADDITIONALFUNDRAISERSYSTEMID	uniqueidentifier	yes		dbo.[INTERACTIONADDITIONALFUNDRAISER].[FUNDRAISERID]
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