FACT_CONSTITUENTGROUPMEMBER_STAGE

Intermediate storage table for FACT_CONSTITUENTGROUPMEMBER

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTGROUPMEMBERSYSTEMID	uniqueidentifier	yes		[dbo].[GROUPMEMBER].[ID]
MEMBERCONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[GROUPMEMBER].[MEMBERID]
GROUPCONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[GROUPMEMBER].[GROUPID]
ISPRIMARY	bit	yes		[dbo].[GROUPMEMBER].[ISPRIMARY]
FROMDATE	datetime	yes		[dbo].[GROUPMEMBERDATERANGE].[DATEFROM]
FROMDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[GROUPMEMBERDATERANGE].[DATEFROM]
TODATE	datetime	yes		[dbo].[GROUPMEMBERDATERANGE].[DATETO]
TODATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[GROUPMEMBERDATERANGE].[DATETO]
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.