v_FACT_MEMBERSHIPATTRIBUTE
The financial transaction attribute fact table relates MEMBERSHIP to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| MEMBERSHIPATTRIBUTEFACTID | bigint | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[MEMBERSHIPATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[ATTRIBUTEDIMID] |
| MEMBERSHIPDIMID | int | yes | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[MEMBERSHIPDIMID] |
| MEMBERSHIPSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[MEMBERSHIPSYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_MEMBERSHIPATTRIBUTE].[ATTRIBUTECOMMENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_MEMBERSHIPATTRIBUTE] as
select
ma.[MEMBERSHIPATTRIBUTEFACTID],
ma.[ATTRIBUTEDIMID],
ma.[MEMBERSHIPDIMID],
ma.[MEMBERSHIPSYSTEMID],
ma.[ATTRIBUTESTARTDATEDIMID],
ma.[ATTRIBUTESTARTDATE],
ma.[ATTRIBUTEENDDATEDIMID],
ma.[ATTRIBUTEENDDATE],
ma.[ATTRIBUTEVALUE],
ma.[ATTRIBUTEISCURRENT],
ma.[ATTRIBUTECOMMENT]
from
BBDW.[FACT_MEMBERSHIPATTRIBUTE] ma
left join BBDW.[DIM_ATTRIBUTE] a on ma.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);