Stores information about sponsorship transactions
Primary Key
| Primary Key |
Field Type |
| SPONSORSHIPRECURRINGADDITIONALGIFTFACTID |
int |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| SPONSORSHIPRECURRINGADDITIONALGIFTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[SPONSORSHIPRECURRINGADDITIONALGIFT].[ID] |
| SPONSORSHIPDIMID |
int |
yes |
|
dReference key to the sponsorship dimension, derived from bo.[SPONSORSHIPRECURRINGADDITIONALGIFT].[SPONSORSHIPID] |
| FINANCIALTRANSACTIONFACTID |
int |
yes |
|
Reference key to the financial transaction fact, derived from dbo.[SPONSORSHIPRECURRINGADDITIONALGIFT].[REVENUEID] |
| 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_FACT_SPONSORSHIPRECURRINGADDITIONALGIFT |
SPONSORSHIPRECURRINGADDITIONALGIFTFACTID |
yes |
yes |
yes |