DIM_MEMBERSHIP

Contains information about memberships.

Primary Key

Primary Key	Field Type
MEMBERSHIPDIMID	int

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]
GIVENBYCONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from [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.

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_DIM_MEMBERSHIP	MEMBERSHIPDIMID	yes	yes	yes