V_QUERY_BBDW_SPONSORSHIPTRANSACTION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORSHIPTRANSACTIONFACTID | int | ||
| SPONSORSHIPTRANSACTIONSYSTEMID | uniqueidentifier | yes | |
| SPONSORSHIPTRANSACTIONSEQUENCE | smallint | yes | |
| SPONSORSHIPTRANSACTIONACTION | nvarchar(50) | yes | |
| SPONSORSHIPREASON | nvarchar(100) | yes | |
| SPONSORSHIPREASONTYPE | nvarchar(100) | yes | |
| SPONSORSHIPTRANSACTIONDATEDIMID | int | yes | |
| SPONSORSHIPTRANSACTIONDATE | datetime | yes | |
| ISFIRSTSPONSORSHIPTRANSACTION | bit | yes | |
| ISLASTSPONSORSHIPTRANSACTION | bit | yes | |
| CONTEXTSPONSORSHIPDIMID | int | yes | |
| TARGETSPONSORSHIPDIMID | int | yes | |
| DECLINEDSPONSORSHIPDIMID | int | yes | |
| GIFTFINANCIALSPONSORCONSTITUENTDIMID | int | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_SPONSORSHIPTRANSACTION] as
select
st.[SPONSORSHIPTRANSACTIONFACTID],
st.[SPONSORSHIPTRANSACTIONSYSTEMID],
st.[SPONSORSHIPTRANSACTIONSEQUENCE],
st.[SPONSORSHIPTRANSACTIONACTION],
sr.[SPONSORSHIPREASON],
sr.[SPONSORSHIPREASONTYPE],
st.[SPONSORSHIPTRANSACTIONDATEDIMID],
st.[SPONSORSHIPTRANSACTIONDATE],
st.[ISFIRSTSPONSORSHIPTRANSACTION],
st.[ISLASTSPONSORSHIPTRANSACTION],
st.[CONTEXTSPONSORSHIPDIMID],
st.[TARGETSPONSORSHIPDIMID],
st.[DECLINEDSPONSORSHIPDIMID],
st.[GIFTFINANCIALSPONSORCONSTITUENTDIMID]
from bbdw.[FACT_SPONSORSHIPTRANSACTION] st
left join bbdw.[DIM_SPONSORSHIPREASON] sr on st.[SPONSORSHIPREASONDIMID] = sr.[SPONSORSHIPREASONDIMID] and st.[SPONSORSHIPREASONDIMID] <> 0