v_FACT_PURPOSELEVELATTRIBUTE
The purpose level attribute fact table relates purpose levels to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PURPOSELEVELATTRIBUTEFACTID | bigint | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[PURPOSELEVELATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[ATTRIBUTEDIMID] |
| PURPOSELEVELDIMID | int | yes | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[PURPOSELEVELDIMID] |
| PURPOSELEVELSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[PURPOSELEVELSYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_PURPOSELEVELATTRIBUTE].[ATTRIBUTECOMMENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_PURPOSELEVELATTRIBUTE] as
select
pa.[PURPOSELEVELATTRIBUTEFACTID],
pa.[ATTRIBUTEDIMID],
pa.[PURPOSELEVELDIMID],
pa.[PURPOSELEVELSYSTEMID],
pa.[ATTRIBUTESTARTDATEDIMID],
pa.[ATTRIBUTESTARTDATE],
pa.[ATTRIBUTEENDDATEDIMID],
pa.[ATTRIBUTEENDDATE],
pa.[ATTRIBUTEVALUE],
pa.[ATTRIBUTEISCURRENT],
pa.[ATTRIBUTECOMMENT]
from
BBDW.[FACT_PURPOSELEVELATTRIBUTE] pa
left join BBDW.[DIM_ATTRIBUTE] a on pa.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);