v_FACT_BENEFITATTRIBUTE
The benefit attribute fact table relates benefits to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| BENEFITATTRIBUTEFACTID | bigint | BBDW.[FACT_BENEFITATTRIBUTE].[BENEFITATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_BENEFITATTRIBUTE].[ATTRIBUTEDIMID] |
| BENEFITDIMID | int | yes | BBDW.[FACT_BENEFITATTRIBUTE].[BENEFITDIMID] |
| BENEFITSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_BENEFITATTRIBUTE].[BENEFITSYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_BENEFITATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_BENEFITATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_BENEFITATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_BENEFITATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_BENEFITATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_BENEFITATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_BENEFITATTRIBUTE].[ATTRIBUTECOMMENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_BENEFITATTRIBUTE] as
select
ba.[BENEFITATTRIBUTEFACTID],
ba.[ATTRIBUTEDIMID],
ba.[BENEFITDIMID],
ba.[BENEFITSYSTEMID],
ba.[ATTRIBUTESTARTDATEDIMID],
ba.[ATTRIBUTESTARTDATE],
ba.[ATTRIBUTEENDDATEDIMID],
ba.[ATTRIBUTEENDDATE],
ba.[ATTRIBUTEVALUE],
ba.[ATTRIBUTEISCURRENT],
ba.[ATTRIBUTECOMMENT]
from
BBDW.[FACT_BENEFITATTRIBUTE] ba
left join BBDW.[DIM_ATTRIBUTE] a on ba.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);