v_DIM_SPONSOR
Stores information about sponsors
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORDIMID | int | BBDW.[DIM_SPONSOR].[SPONSORDIMID] | |
| SPONSORSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SPONSOR].[SPONSORSYSTEMID] |
| DONOTTERMINATE | bit | yes | BBDW.[DIM_SPONSOR].[DONOTTERMINATE] |
| UNIQUEOPPORTUNITIESFORGIFTDONOR | bit | yes | BBDW.[DIM_SPONSOR].[UNIQUEOPPORTUNITIESFORGIFTDONOR] |
| ACTIVESPONSORSHIPS | int | yes | BBDW.[DIM_SPONSOR].[ACTIVESPONSORSHIPS] |
| SPONSORSHIPTOTALAMOUNT | money | yes | BBDW.[DIM_SPONSOR].[SPONSORSHIPTOTALAMOUNT] |
| ACTIVECOMMITMENTS | int | yes | BBDW.[DIM_SPONSOR].[ACTIVECOMMITMENTS] |
| SPONSORSINCEDATEDIMID | int | yes | BBDW.[DIM_SPONSOR].[SPONSORSINCEDATEDIMID] |
| SPONSORSINCEDATE | datetime | yes | BBDW.[DIM_SPONSOR].[SPONSORSINCEDATE] |
| STATUS | nvarchar(25) | yes | BBDW.[DIM_SPONSOR].[STATUS] |
Definition
Copy
create view [BBDW].[v_DIM_SPONSOR] as
select
[SPONSORDIMID],
[SPONSORSYSTEMID],
[DONOTTERMINATE],
[UNIQUEOPPORTUNITIESFORGIFTDONOR],
[ACTIVESPONSORSHIPS],
[SPONSORSHIPTOTALAMOUNT],
[ACTIVECOMMITMENTS],
[SPONSORSINCEDATEDIMID],
[SPONSORSINCEDATE],
[STATUS]
from [BBDW].[DIM_SPONSOR];