FACT_SPONSORSHIPTRANSACTION_STAGE

Intermediate storage for sponsorship transactions

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]
CONTEXTSPONSORSHIPSYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPTRANSACTION].[CONTEXTSPONSORSHIPID]
TARGETSPONSORSHIPSYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPTRANSACTION].[TARGETSPONSORSHIPID]
DECLINEDSPONSORSHIPSYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPTRANSACTION].[DECLINEDSPONSORSHIPID]
GIFTFINANCIALSPONSORCONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPTRANSACTION].[GIFTFINANCIALSPONSORID]
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.