| SPONSORSHIPTRANSACTIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[SPONSORSHIPTRANSACTION].[ID] |
| SPONSORSHIPTRANSACTIONSEQUENCE |
smallint |
yes |
|
dbo.[SPONSORSHIPTRANSACTION].[TRANSACTIONSEQUENCE] |
| SPONSORSHIPTRANSACTIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[SPONSORSHIPTRANSACTION].[TRANSACTIONDATE] |
| SPONSORSHIPTRANSACTIONDATE |
datetime |
yes |
|
dbo.[SPONSORSHIPTRANSACTION].[TRANSACTIONDATE] |
| SPONSORSHIPTRANSACTIONACTIONCODE |
smallint |
yes |
|
dbo.[SPONSORSHIPTRANSACTION].[ACTIONCODE] |
| SPONSORSHIPTRANSACTIONACTION |
nvarchar(50) |
yes |
|
dbo.[SPONSORSHIPTRANSACTION].[ACTION] |
| SPONSORSHIPREASONDIMID |
int |
yes |
|
Reference key to the sponsorship reason dimension, derived from dbo.[SPONSORSHIPTRANSACTION].[SPONSORSHIPREASONID] |
| SPONSORSHIPCOMMITMENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[SPONSORSHIPTRANSACTION].[SPONSORSHIPCOMMITMENTID] |
| CONTEXTSPONSORSHIPDIMID |
int |
yes |
|
Reference key to the sponsorship dimension, derived from dbo.[SPONSORSHIPTRANSACTION].[CONTEXTSPONSORSHIPID] |
| TARGETSPONSORSHIPDIMID |
int |
yes |
|
Reference key to the sponsorship dimension, derived from dbo.[SPONSORSHIPTRANSACTION].[TARGETSPONSORSHIPID] |
| DECLINEDSPONSORSHIPDIMID |
int |
yes |
|
Reference key to the sponsorship dimension, derived from dbo.[SPONSORSHIPTRANSACTION].[DECLINEDSPONSORSHIPID] |
| GIFTFINANCIALSPONSORCONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[SPONSORSHIPTRANSACTION].[GIFTFINANCIALSPONSORID] |
| GIFTFINANCIALSPONSORCONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[SPONSORSHIPTRANSACTION].[GIFTFINANCIALSPONSORID] |
| ISFIRSTSPONSORSHIPTRANSACTION |
bit |
yes |
|
The first transaction for the sponsorship based on dbo.[SPONSORSHIPTRANSACTION].[TRANSACTIONDATE] and dbo.[SPONSORSHIPTRANSACTION].[TRANSACTIONSEQUENCE] |
| ISLASTSPONSORSHIPTRANSACTION |
bit |
yes |
|
The last transaction for the sponsorship based on dbo.[SPONSORSHIPTRANSACTION].[TRANSACTIONDATE] and dbo.[SPONSORSHIPTRANSACTION].[TRANSACTIONSEQUENCE] |
| 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. |