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. |