v_FACT_INTERACTIONRESPONSE

The interaction response fact table relates responses back to interactions.

Fields

Field	Field Type	Null	Description
INTERACTIONRESPONSEFACTID	int		BBDW.[FACT_INTERACTIONRESPONSE].[INTERACTIONRESPONSEFACTID]
RESPONSEDIMID	int	yes	BBDW.[FACT_INTERACTIONRESPONSE].[RESPONSEDIMID]
INTERACTIONRESPONSEDATEDIMID	int	yes	BBDW.[FACT_INTERACTIONRESPONSE].[INTERACTIONRESPONSEDATEDIMID]
INTERACTIONFACTID	int	yes	BBDW.[FACT_INTERACTIONRESPONSE].[INTERACTIONFACTID]
INTERACTIONDATEDIMID	int	yes	BBDW.[FACT_INTERACTION].[INTERACTIONDATEDIMID]
INTERACTIONDIMID	int	yes	BBDW.[FACT_INTERACTION].[INTERACTIONDIMID]
CONSTITUENTDIMID	int	yes	BBDW.[FACT_INTERACTION].[CONSTITUENTDIMID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_INTERACTION].[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]
FUNDRAISERDIMID	int	yes	BBDW.[FACT_INTERACTION].[FUNDRAISERDIMID]
EVENTDIMID	int	yes	BBDW.[FACT_INTERACTION].[EVENTDIMID]
EVENTSTARTDATEDIMID	int	yes	BBDW.[DIM_EVENT].[EVENTSTARTDATEDIMID]
EVENTENDDATEDIMID	int	yes	BBDW.[DIM_EVENT].[EVENTENDDATEDIMID]

Definition

Copy


CREATE view [BBDW].[v_FACT_INTERACTIONRESPONSE] as
  select
    ir.[INTERACTIONRESPONSEFACTID],     
    ir.[RESPONSEDIMID], 
    ir.[INTERACTIONRESPONSEDATEDIMID],  
    ir.[INTERACTIONFACTID], 
    i.[INTERACTIONDATEDIMID], 
    i.[INTERACTIONDIMID],
    i.[CONSTITUENTDIMID], 
    i.[CONSTITUENTSYSTEMID], 
    c.[AGE] as [CONSTITUENTAGE], 
    c.[CONSTITUENTINFORMATIONDIMID], 
    c.[CONSTITUENTADDRESSDIMID], 
    c.[CONSTITUENTADDRESSDETAILDIMID],
    c.[CONSTITUENTADDRESSFLAGDIMID],
    c.[CONSTITUENTADDRESSTYPEDIMID],    
    c.[CONSTITUENTDEMOGRAPHICDIMID], 
    i.[FUNDRAISERDIMID],
    i.[EVENTDIMID], 
    e.[EVENTSTARTDATEDIMID], 
    e.[EVENTENDDATEDIMID]
  from            
    BBDW.[FACT_INTERACTIONRESPONSE] ir
    left join BBDW.[FACT_INTERACTION] i
      on i.[INTERACTIONFACTID] = ir.[INTERACTIONFACTID]
    left join BBDW.[DIM_CONSTITUENT] c
      on i.[CONSTITUENTDIMID] = c.[CONSTITUENTDIMID]
    left join BBDW.[DIM_EVENT] e
      on i.[EVENTDIMID] = e.[EVENTDIMID]