FACT_INTERACTIONRESPONSE_STAGE

Intermediate storage table for FACT_INTERACTIONRESPONSE

Fields

Field	Field Type	Null	Notes	Description
INTERACTIONRESPONSESYSTEMID	uniqueidentifier	yes		dbo.[INTERACTIONRESPONSE].[ID]
INTERACTIONSYSTEMID	uniqueidentifier	yes		dbo.[INTERACTIONRESPONSE].[INTERACTIONID]
RESPONSEDIMID	int	yes		Reference key to the response dimension, derived from dbo.[INTERACTIONRESPONSE].[RESPONSEID]
INTERACTIONRESPONSEDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[INTERACTIONRESPONSE].[DATE]
INTERACTIONRESPONSEDATE	datetime	yes		dbo.[INTERACTIONRESPONSE].[DATE]
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