v_FACT_SPONSORSHIPTRANSACTION
Stores information about sponsorship transactions
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORSHIPTRANSACTIONFACTID | int | BBDW.[FACT_SPONSORSHIPTRANSACTION].[SPONSORSHIPTRANSACTIONDIMID] | |
| SPONSORSHIPTRANSACTIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[SPONSORSHIPTRANSACTIONSYSTEMID] |
| SPONSORSHIPTRANSACTIONSEQUENCE | smallint | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[SPONSORSHIPTRANSACTIONSEQUENCE] |
| SPONSORSHIPTRANSACTIONDATEDIMID | int | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[SPONSORSHIPTRANSACTIONDATEDIMID] |
| SPONSORSHIPTRANSACTIONDATE | datetime | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[SPONSORSHIPTRANSACTIONDATE] |
| SPONSORSHIPTRANSACTIONACTION | nvarchar(50) | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[SPONSORSHIPTRANSACTIONACTION] |
| SPONSORSHIPCOMMITMENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[SPONSORSHIPCOMMITMENTSYSTEMID] |
| SPONSORSHIPREASONDIMID | int | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[SPONSORSHIPREASONDIMID] |
| CONTEXTSPONSORSHIPDIMID | int | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[CONTEXTSPONSORSHIPDIMID] |
| TARGETSPONSORSHIPDIMID | int | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[TARGETSPONSORSHIPDIMID] |
| DECLINEDSPONSORSHIPDIMID | int | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[DECLINEDSPONSORSHIPDIMID] |
| GIFTFINANCIALSPONSORCONSTITUENTDIMID | int | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[GIFTFINANCIALSPONSORCONSTITUENTDIMID] |
| GIFTFINANCIALSPONSORCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[GIFTFINANCIALSPONSORCONSTITUENTSYSTEMID] |
| ISFIRSTSPONSORSHIPTRANSACTION | bit | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[ISFIRSTSPONSORSHIPTRANSACTION] |
| ISLASTSPONSORSHIPTRANSACTION | bit | yes | BBDW.[FACT_SPONSORSHIPTRANSACTION].[ISLASTSPONSORSHIPTRANSACTION] |
Definition
Copy
create view [BBDW].[v_FACT_SPONSORSHIPTRANSACTION] as
select
[SPONSORSHIPTRANSACTIONFACTID],
[SPONSORSHIPTRANSACTIONSYSTEMID],
[SPONSORSHIPTRANSACTIONSEQUENCE],
[SPONSORSHIPTRANSACTIONDATEDIMID],
[SPONSORSHIPTRANSACTIONDATE],
[SPONSORSHIPTRANSACTIONACTION],
[SPONSORSHIPCOMMITMENTSYSTEMID],
[SPONSORSHIPREASONDIMID],
[CONTEXTSPONSORSHIPDIMID],
[TARGETSPONSORSHIPDIMID],
[DECLINEDSPONSORSHIPDIMID],
[GIFTFINANCIALSPONSORCONSTITUENTDIMID],
[GIFTFINANCIALSPONSORCONSTITUENTSYSTEMID],
[ISFIRSTSPONSORSHIPTRANSACTION],
[ISLASTSPONSORSHIPTRANSACTION]
from [BBDW].[FACT_SPONSORSHIPTRANSACTION];