Stores information about sponsors
Primary Key
| Primary Key |
Field Type |
| SPONSORDIMID |
int |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| SPONSORSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[SPONSOR].[ID] |
| DONOTTERMINATE |
bit |
yes |
|
dbo.[SPONSOR].[DONOTTERMINATE] |
| UNIQUEOPPORTUNITIESFORGIFTDONOR |
bit |
yes |
|
dbo.[SPONSOR].[UNIQUEOPPORTUNITIESFORGIFTDONOR] |
| ACTIVESPONSORSHIPS |
int |
yes |
|
Derived by dbo.UFN_SPONSORSHIP_GETACTIVESPONSORSHIPSFORSPONSOR(dbo.[SPONSOR].[ID]) |
| SPONSORSHIPTOTALAMOUNT |
money |
yes |
|
Derived by sum(dbo.[FINANCIALTRANSACTIONLINEITEM].[ORGAMOUNT]) where dbo.[FINANCIALTRANSACTION].[TYPECODE] = 9 and dbo.[FINANCIALTRANSACTION].[TRANSACTIONTYPECODE] = 0 |
| ACTIVECOMMITMENTS |
int |
yes |
|
Derived by dbo.UFN_SPONSORSHIP_GETACTIVEFINANCIALCOMMITMENTFORSPONSOR(dbo.[SPONSOR].[ID]) |
| SPONSORSINCEDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from min(dbo.[SPONSORDATERANGE].[DATEFROM]) |
| SPONSORSINCEDATE |
datetime |
yes |
|
Derived by min(dbo.[SPONSORDATERANGE].[DATEFROM]) |
| STATUS |
nvarchar(25) |
yes |
|
If the sponsor has at least one sponsorship with status code of 1 then 'Active' else 'Inactive'. |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| PK_DIM_SPONSOR |
SPONSORDIMID |
yes |
yes |
yes |