v_FACT_DESIGNATIONATTRIBUTE

The designation attribute fact table relates designations to their attributes.

Fields

Field	Field Type	Null	Description
DESIGNATIONATTRIBUTEFACTID	bigint		BBDW.[FACT_DESIGNATIONATTRIBUTE].[DESIGNATIONATTRIBUTEFACTID]
ATTRIBUTEDIMID	int	yes	BBDW.[FACT_DESIGNATIONATTRIBUTE].[ATTRIBUTEDIMID]
DESIGNATIONDIMID	int	yes	BBDW.[FACT_DESIGNATIONATTRIBUTE].[DESIGNATIONDIMID]
DESIGNATIONSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_DESIGNATIONATTRIBUTE].[DESIGNATIONSYSTEMID]
ATTRIBUTESTARTDATEDIMID	int	yes	BBDW.[FACT_DESIGNATIONATTRIBUTE].[ATTRIBUTESTARTDATEDIMID]
ATTRIBUTESTARTDATE	datetime	yes	BBDW.[FACT_DESIGNATIONATTRIBUTE].[ATTRIBUTESTARTDATE]
ATTRIBUTEENDDATEDIMID	int	yes	BBDW.[FACT_DESIGNATIONATTRIBUTE].[ATTRIBUTEENDDATEDIMID]
ATTRIBUTEENDDATE	datetime	yes	BBDW.[FACT_DESIGNATIONATTRIBUTE].[ATTRIBUTEENDDATE]
ATTRIBUTEVALUE	nvarchar(255)	yes	BBDW.[FACT_DESIGNATIONATTRIBUTE].[ATTRIBUTEVALUE]
ATTRIBUTEISCURRENT	bit	yes	BBDW.[FACT_DESIGNATIONATTRIBUTE].[ATTRIBUTEISCURRENT]
ATTRIBUTECOMMENT	nvarchar(255)	yes	BBDW.[FACT_DESIGNATIONATTRIBUTE].[ATTRIBUTECOMMENT]

Definition

Copy


CREATE view [BBDW].[v_FACT_DESIGNATIONATTRIBUTE] as
  select
    da.[DESIGNATIONATTRIBUTEFACTID], 
    da.[ATTRIBUTEDIMID], 
    da.[DESIGNATIONDIMID], 
    da.[DESIGNATIONSYSTEMID],
    da.[ATTRIBUTESTARTDATEDIMID],  
    da.[ATTRIBUTESTARTDATE],
    da.[ATTRIBUTEENDDATEDIMID], 
    da.[ATTRIBUTEENDDATE],
    da.[ATTRIBUTEVALUE], 
    da.[ATTRIBUTEISCURRENT],
    da.[ATTRIBUTECOMMENT]
  from 
    BBDW.[FACT_DESIGNATIONATTRIBUTE] da 
    left join BBDW.[DIM_ATTRIBUTE] a on da.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
  where (a.[ATTRIBUTEHASCODETABLE] = 1);