v_FACT_PROSPECTPLANATTRIBUTE

The prospect plan attribute fact table relates prospect plans to their attributes.

Fields

Field	Field Type	Null	Description
PROSPECTPLANATTRIBUTEFACTID	bigint		BBDW.[FACT_PROSPECTPLANATTRIBUTE].[PROSPECTPLANATTRIBUTEFACTID]
ATTRIBUTEDIMID	int	yes	BBDW.[FACT_PROSPECTPLANATTRIBUTE].[ATTRIBUTEDIMID]
PROSPECTPLANDIMID	int	yes	BBDW.[FACT_PROSPECTPLANATTRIBUTE].[PROSPECTPLANDIMID]
PROSPECTPLANSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_PROSPECTPLANATTRIBUTE].[PROSPECTPLANSYSTEMID]
ATTRIBUTESTARTDATEDIMID	int	yes	BBDW.[FACT_PROSPECTPLANATTRIBUTE].[ATTRIBUTESTARTDATEDIMID]
ATTRIBUTESTARTDATE	datetime	yes	BBDW.[FACT_PROSPECTPLANATTRIBUTE].[ATTRIBUTESTARTDATE]
ATTRIBUTEENDDATEDIMID	int	yes	BBDW.[FACT_PROSPECTPLANATTRIBUTE].[ATTRIBUTEENDDATEDIMID]
ATTRIBUTEENDDATE	datetime	yes	BBDW.[FACT_PROSPECTPLANATTRIBUTE].[ATTRIBUTEENDDATE]
ATTRIBUTEVALUE	nvarchar(255)	yes	BBDW.[FACT_PROSPECTPLANATTRIBUTE].[ATTRIBUTEVALUE]
ATTRIBUTEISCURRENT	bit	yes	BBDW.[FACT_PROSPECTPLANATTRIBUTE].[ATTRIBUTEISCURRENT]
ATTRIBUTECOMMENT	nvarchar(255)	yes	BBDW.[FACT_PROSPECTPLANATTRIBUTE].[ATTRIBUTECOMMENT]

Definition

Copy


CREATE view [BBDW].[v_FACT_PROSPECTPLANATTRIBUTE] as
  select
    pa.[PROSPECTPLANATTRIBUTEFACTID], 
    pa.[ATTRIBUTEDIMID], 
    pa.[PROSPECTPLANDIMID], 
    pa.[PROSPECTPLANSYSTEMID],
    pa.[ATTRIBUTESTARTDATEDIMID],  
    pa.[ATTRIBUTESTARTDATE],
    pa.[ATTRIBUTEENDDATEDIMID], 
    pa.[ATTRIBUTEENDDATE],
    pa.[ATTRIBUTEVALUE], 
    pa.[ATTRIBUTEISCURRENT],
    pa.[ATTRIBUTECOMMENT]
  from 
    BBDW.[FACT_PROSPECTPLANATTRIBUTE] pa 
    left join BBDW.[DIM_ATTRIBUTE] a on pa.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
  where (a.[ATTRIBUTEHASCODETABLE] = 1);