DIM_MEMBERSHIP_STAGE

Intermediate storage table for memberships.

Fields

Field	Field Type	Null	Notes	Description
MEMBERSHIPSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIP].[ID]
MEMBERSHIPLOOKUPID	nvarchar(100)	yes		[dbo].[MEMBERSHIP].[LOOKUPID]
MEMBERSHIPPROGRAMDIMID	int	yes		Reference key to the membership program dimension, derived using [dbo].[MEMBERSHIP].[MEMBERSHIPPROGRAMID], [dbo].[MEMBERSHIP].[MEMBERSHIPLEVELID] ,[dbo].[MEMBERSHIP].[MEMBERSHIPLEVELTERMID] , and [dbo].[MEMBERSHIP].[MEMBERSHIPLEVELTYPECODEID]
MEMBERSHIPSTATUSDIMID	int	yes		Reference key to the membership status dimension, derived from dbo.[MEMBERSHIP].[STATUSCODE]
JOINDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[MEMBERSHIP].[JOINDATE]
JOINDATE	datetime	yes		dbo.[MEMBERSHIP].[JOINDATE]
EXPIRATIONDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[MEMBERSHIP].[EXPIRATIONDATE]
EXPIRATIONDATE	datetime	yes		dbo.[MEMBERSHIP].[EXPIRATIONDATE]
LASTRENEWEDONDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[MEMBERSHIP].[LASTRENEWEDON]
LASTRENEWEDONDATE	datetime	yes		dbo.[MEMBERSHIP].[LASTRENEWEDON]
ISGIFTMEMBERSHIP	bit	yes		[dbo].[MEMBERSHIP].[ISGIFT]
GIVENBYCONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBERSHIP].[GIVENBYID]
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.