v_FACT_MODELINGANDPROPENSITYATTRIBUTE
The modeling and propensity attribute fact table relates constituent's modeling and propensities to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| MODELINGANDPROPENSITYATTRIBUTEFACTID | bigint | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[MODELINGANDPROPENSITYATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[ATTRIBUTEDIMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[CONSTITUENTSYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE].[ATTRIBUTECOMMENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_MODELINGANDPROPENSITYATTRIBUTE] as
select
mpa.[MODELINGANDPROPENSITYATTRIBUTEFACTID],
mpa.[ATTRIBUTEDIMID],
mpa.[CONSTITUENTDIMID],
mpa.[CONSTITUENTSYSTEMID],
mpa.[ATTRIBUTESTARTDATEDIMID],
mpa.[ATTRIBUTESTARTDATE],
mpa.[ATTRIBUTEENDDATEDIMID],
mpa.[ATTRIBUTEENDDATE],
mpa.[ATTRIBUTEVALUE],
mpa.[ATTRIBUTEISCURRENT],
mpa.[ATTRIBUTECOMMENT]
from
BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE] mpa
left join BBDW.[DIM_ATTRIBUTE] a on mpa.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);