FACT_MEMBERSHIPTRANSACTION_STAGE

Intermediate storage table for membership transactions.

Fields

Field	Field Type	Null	Notes	Description
MEMBERSHIPTRANSACTIONSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPTRANSACTION].[ID]
MEMBERSHIPTRANSACTIONSEQUENCE	int			Sequence of transactions for a membership ordered by transaction date and action code
MEMBERSHIPSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPID]
MEMBERSHIPPROGRAMDIMID	int	yes		Reference key to the membership program dimension, derived using [dbo].[MEMBERSHIPLEVEL].[MEMBERSHIPPROGRAMID], [dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELID] ,[dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELTERMID] , and [dbo].[MEMBERSHIPTRANSACTION].[MEMBERSHIPLEVELTYPECODEID]
MEMBERSHIPTRANSACTIONDATEDIMID	int	yes		Reference key to the date dimension, derived using [dbo].[MEMBERSHIPTRANSACTION].[TRANSACTIONDATE]
MEMBERSHIPTRANSACTIONDATE	datetime	yes		[dbo].[MEMBERSHIPTRANSACTION].[TRANSACTIONDATE]
MEMBERSHIPEXPIRATIONDATEDIMID	int	yes		Reference key to the date dimension, derived using [dbo].[MEMBERSHIPTRANSACTION].[EXPIRATIONDATE]
MEMBERSHIPEXPIRATIONDATE	datetime	yes		[dbo].[MEMBERSHIPTRANSACTION].[EXPIRATIONDATE]
MEMBERSHIPACTIONDIMID	int	yes		Reference key to the membership action dimension, derived using [dbo].[MEMBERSHIPTRANSACTION].[ACTIONCODE]
REVENUEAPPLICATIONSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPTRANSACTION].[REVENUESPLITID]
ISGIFTMEMBERSHIP	bit	yes		[dbo].[MEMBERSHIPTRANSACTION].[ISGIFT]
GIVENBYCONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIPTRANSACTION].[DONORID]
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.
MEMBERSHIPSTATUSDIMID	int	yes		Reference key to the membership status dimension, derived using [dbo].[MEMBERSHIPTRANSACTION].[ACTIONCODE].