FACT_SPONSORSHIPTRANSACTION

Stores information about sponsorship transactions

Primary Key

Primary Key Field Type
SPONSORSHIPTRANSACTIONFACTID int

Fields

Field Field Type Null Notes Description
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.

Indexes

Index Name Fields Unique Primary Clustered
PK_FACT_SPONSORSHIPTRANSACTION SPONSORSHIPTRANSACTIONFACTID yes yes yes