v_FACT_EDUCATIONATTRIBUTE

The education attribute fact table relates education records to their attributes.

Fields

Field	Field Type	Null	Description
EDUCATIONATTRIBUTEFACTID	bigint		BBDW.[FACT_EDUCATIONATTRIBUTE].[EDUCATIONATTRIBUTEFACTID]
ATTRIBUTEDIMID	int	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[ATTRIBUTEDIMID]
CONSTITUENTDIMID	int	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[CONSTITUENTDIMID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[CONSTITUENTSYSTEMID]
EDUCATIONDIMID	int	yes	BBDW.[FACT_EDUCATION].[CONSTITUENTDIMID]
EDUCATIONSYSTEMID	uniqueidentifier	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[EDUCATIONSYSTEMID]
ATTRIBUTESTARTDATEDIMID	int	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[ATTRIBUTESTARTDATEDIMID]
ATTRIBUTESTARTDATE	datetime	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[ATTRIBUTESTARTDATE]
ATTRIBUTEENDDATEDIMID	int	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[ATTRIBUTEENDDATEDIMID]
ATTRIBUTEENDDATE	datetime	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[ATTRIBUTEENDDATE]
ATTRIBUTEVALUE	nvarchar(255)	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[ATTRIBUTEVALUE]
ATTRIBUTEISCURRENT	bit	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[ATTRIBUTEISCURRENT]
ATTRIBUTECOMMENT	nvarchar(255)	yes	BBDW.[FACT_EDUCATIONATTRIBUTE].[ATTRIBUTECOMMENT]

Definition

Copy


CREATE view [BBDW].[v_FACT_EDUCATIONATTRIBUTE] as
  select
    ea.[EDUCATIONATTRIBUTEFACTID], 
    ea.[ATTRIBUTEDIMID], 
    e.[CONSTITUENTDIMID],
    e.[CONSTITUENTSYSTEMID],
    ea.[EDUCATIONDIMID], 
    ea.[EDUCATIONSYSTEMID],
    ea.[ATTRIBUTESTARTDATEDIMID],  
    ea.[ATTRIBUTESTARTDATE],
    ea.[ATTRIBUTEENDDATEDIMID], 
    ea.[ATTRIBUTEENDDATE],
    ea.[ATTRIBUTEVALUE], 
    ea.[ATTRIBUTEISCURRENT],
    ea.[ATTRIBUTECOMMENT]
  from 
    BBDW.[FACT_EDUCATIONATTRIBUTE] ea 
    left join BBDW.[DIM_EDUCATION] e on ea.[EDUCATIONDIMID] = e.[EDUCATIONDIMID]
    left join BBDW.[DIM_ATTRIBUTE] a on ea.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
  where (a.[ATTRIBUTEHASCODETABLE] = 1);