v_FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE
The sponsorship opportunity child attribute fact table relates sponsorship opportunity children to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORSHIPOPPORTUNITYCHILDATTRIBUTEFACTID | int | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[SPONSORSHIPOPPORTUNITYCHILDATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[ATTRIBUTEDIMID] |
| SPONSORSHIPOPPORTUNITYCHILDDIMID | int | yes | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[SPONSORSHIPOPPORTUNITYCHILDDIMID] |
| SPONSORSHIPOPPORTUNITYCHILDSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[SPONSORSHIPOPPORTUNITYCHILDSYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE].[ATTRIBUTECOMMENT] |
Definition
Copy
create view [BBDW].[v_FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE] as
select
soca.[SPONSORSHIPOPPORTUNITYCHILDATTRIBUTEFACTID],
soca.[ATTRIBUTEDIMID],
soca.[SPONSORSHIPOPPORTUNITYCHILDDIMID],
soca.[SPONSORSHIPOPPORTUNITYCHILDSYSTEMID],
soca.[ATTRIBUTESTARTDATEDIMID],
soca.[ATTRIBUTESTARTDATE],
soca.[ATTRIBUTEENDDATEDIMID],
soca.[ATTRIBUTEENDDATE],
soca.[ATTRIBUTEVALUE],
soca.[ATTRIBUTEISCURRENT],
soca.[ATTRIBUTECOMMENT]
from
BBDW.[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE] soca
left join BBDW.[DIM_ATTRIBUTE] a on soca.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);