FACT_MEMBERSHIPADDON_STAGE

Intermediate storage table for membership add-ons.

Fields

Field	Field Type	Null	Notes	Description
MEMBERSHIPADDONSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPADDON].[ID]
MEMBERSHIPSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPADDON].[MEMBERSHIPID]
ADDONDIMID	int	yes		Reference key to the Add On dimension, derived from [dbo].[MEMBERSHIPADDON].[ADDONID]
MEMBERSHIPTRANSACTIONSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPADDON].[MEMBERSHIPTRANSACTIONID]
REVENUEAPPLICATIONSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPADDON].[REVENUESPLITID]
QUANTITY	int	yes		[dbo].[MEMBERSHIPADDON].[QUANTITY]
PURCHASEPRICE	money	yes		[dbo].[MEMBERSHIPADDON].[ORGANIZATIONPURCHASEPRICE]
BASECURRENCYDIMID	int	yes		Reference key to the Currency dimension, derived from [dbo].[MEMBERSHIPADDON].[BASECURRENCYID]
BASEPURCHASEPRICE	money	yes		[dbo].[MEMBERSHIPADDON].[PURCHASEPRICE]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process.
SOURCEDIMID	int	yes		Source system used.