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