FACT_MEMBERSHIPREVENUE_STAGE

Intermediate storage table for membership revenue.

Fields

Field	Field Type	Null	Notes	Description
MEMBERSHIPREVENUESYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE].[ID]
REVENUEAPPLICATIONSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE].[FINANCIALTRANSACTIONLINEITEMID]
ORIGINALMEMBERSHIPTRANSACTIONSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE].[ORIGINALMEMBERSHIPTRANSACTIONID]
CURRENTMEMBERSHIPTRANSACTIONSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE].[CURRENTMEMBERSHIPTRANSACTIONID]
MEMBERSHIPPROGRAMDIMID	int	yes		Reference key to the membership program dimension, derived using [dbo].[MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE].[MEMBERSHIPPROGRAMID]
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.