V_QUERY_BBDW_SPONSOR
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORDIMID | int | ||
| SPONSORSYSTEMID | uniqueidentifier | yes | |
| DONOTTERMINATE | bit | yes | |
| ACTIVESPONSORSHIPS | int | yes | |
| UNIQUEOPPORTUNITIESFORGIFTDONOR | bit | yes | |
| SPONSORSINCEDATEDIMID | int | yes | |
| SPONSORSINCEDATE | datetime | yes | |
| SPONSORSHIPTOTALAMOUNT | money | yes | |
| STATUS | nvarchar(25) | yes | |
| ACTIVECOMMITMENTS | int | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_SPONSOR] as
select
s.[SPONSORDIMID],
s.[SPONSORSYSTEMID],
s.[DONOTTERMINATE],
s.[ACTIVESPONSORSHIPS],
s.[UNIQUEOPPORTUNITIESFORGIFTDONOR],
s.[SPONSORSINCEDATEDIMID],
s.[SPONSORSINCEDATE],
s.[SPONSORSHIPTOTALAMOUNT],
s.[STATUS],
s.[ACTIVECOMMITMENTS],
c.[CURRENCYSYSTEMID]
from BBDW.[DIM_SPONSOR] s
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1 and s.[SPONSORDIMID] > 0