FACT_MEMBER_STAGE

Intermediate storage table for members.

Fields

Field	Field Type	Null	Notes	Description
MEMBERSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBER].[ID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBER].[CONSTITUENTID]
MEMBERSHIPSYSTEMID	uniqueidentifier	yes		[dbo].[MEMBER].[MEMBERSHIPID]
MEMBERFLAGDIMID	int	yes		Reference key to the member flag dimension, derived using [dbo].[MEMBER].[ISPRIMARY]
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.