v_FACT_FUNDINGREQUESTATTRIBUTE
The funding request attribute fact table relates funding requests to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FUNDINGREQUESTATTRIBUTEFACTID | bigint | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[FUNDINGREQUESTATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[ATTRIBUTEDIMID] |
| FUNDINGREQUESTDIMID | int | yes | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[FUNDINGREQUESTDIMID] |
| FUNDINGREQUESTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[FUNDINGREQUESTSYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_FUNDINGREQUESTATTRIBUTE].[ATTRIBUTECOMMENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_FUNDINGREQUESTATTRIBUTE] as
select
fa.[FUNDINGREQUESTATTRIBUTEFACTID],
fa.[ATTRIBUTEDIMID],
fa.[FUNDINGREQUESTDIMID],
fa.[FUNDINGREQUESTSYSTEMID],
fa.[ATTRIBUTESTARTDATEDIMID],
fa.[ATTRIBUTESTARTDATE],
fa.[ATTRIBUTEENDDATEDIMID],
fa.[ATTRIBUTEENDDATE],
fa.[ATTRIBUTEVALUE],
fa.[ATTRIBUTEISCURRENT],
fa.[ATTRIBUTECOMMENT]
from
BBDW.[FACT_FUNDINGREQUESTATTRIBUTE] fa
left join BBDW.[DIM_ATTRIBUTE] a on fa.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);