V_QUERY_BBDW_INTERACTION_STEPS

Fields

Field	Field Type	Null
INTERACTIONFACTID	int
INTERACTIONSYSTEMID	uniqueidentifier	yes
PROSPECTPLANDIMID	int	yes
INTERACTIONOBJECTIVE	nvarchar(100)	yes
FUNDRAISERCONSTITUENTDIMID	int	yes
INTERACTIONDATEDIMID	int	yes
INTERACTIONDATE	datetime	yes
EXPECTEDDATEDIMID	int	yes
EXPECTEDDATE	datetime	yes
EXPECTEDSTARTTIME	UDT_HOURMINUTE	yes
EXPECTEDENDTIME	UDT_HOURMINUTE	yes
ACTUALDATEDIMID	int	yes
ACTUALDATE	datetime	yes
ACTUALSTARTTIME	UDT_HOURMINUTE	yes
ACTUALENDTIME	UDT_HOURMINUTE	yes
INTERACTIONCOMMENT	nvarchar(4000)	yes
ISFIRSTINTERACTION	bit	yes
ISLASTINTERACTION	bit	yes
STAGE	nvarchar(100)	yes
INTERACTIONSTATUS	nvarchar(50)	yes
INTERACTIONTYPE	nvarchar(100)	yes
ISALLDAYEVENT	bit	yes
ISCONTACTREPORT	bit	yes
TIMEZONENAME	nvarchar(200)	yes

Definition

Copy

create view BBDW.[V_QUERY_BBDW_INTERACTION_STEPS] as 

select  
  i.[INTERACTIONFACTID],
  i.[INTERACTIONSYSTEMID],
  i.[PROSPECTPLANDIMID],  
  i.[INTERACTIONOBJECTIVE],
  i.[FUNDRAISERCONSTITUENTDIMID], 
  i.[INTERACTIONDATEDIMID],
  i.[INTERACTIONDATE],
  i.[EXPECTEDDATEDIMID],
  i.[EXPECTEDDATE],
  i.[EXPECTEDSTARTTIME],
  i.[EXPECTEDENDTIME],
  i.[ACTUALDATEDIMID],
  i.[ACTUALDATE],
  i.[ACTUALSTARTTIME],
  i.[ACTUALENDTIME],
  i.[INTERACTIONCOMMENT],
  i.[ISFIRSTINTERACTION],
  i.[ISLASTINTERACTION],
  pps.[PROSPECTPLANSTATUS] [STAGE], 
  di.[INTERACTIONSTATUS],
  di.[INTERACTIONTYPE],
  di.[ISALLDAYEVENT],
  di.[ISCONTACTREPORT],
  tz.[TIMEZONENAME]
from BBDW.[FACT_INTERACTION] i
left join BBDW.[DIM_INTERACTION] di on i.[INTERACTIONDIMID] = di.[INTERACTIONDIMID] and i.[INTERACTIONDIMID] <> 0
left join BBDW.[DIM_PROSPECTPLANSTATUS] pps on i.[PROSPECTPLANSTATUSDIMID] = pps.[PROSPECTPLANSTATUSDIMID] and i.[PROSPECTPLANSTATUSDIMID] <> 0
left join BBDW.[DIM_TIMEZONE] tz on i.[TIMEZONEDIMID] = tz.[TIMEZONEDIMID] and i.[TIMEZONEDIMID] <> 0