FACT_CONSTITUENTGROUPMEMBER

Stores information about constituent group members

Primary Key

Primary Key	Field Type
CONSTITUENTGROUPMEMBERFACTID	int

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTGROUPMEMBERSYSTEMID	uniqueidentifier	yes		[dbo].[GROUPMEMBER].[ID]
MEMBERCONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[GROUPMEMBER].[MEMBERID]
MEMBERCONSTITUENTDIMID	int	yes		Reference key to the constituent dimension for the group member, derived from dbo.[GROUPMEMBER].[MEMBERID]
GROUPCONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[GROUPMEMBER].[GROUPID]
GROUPCONSTITUENTDIMID	int	yes		Reference key to the constituent dimension for the group, derived from dbo.[GROUPMEMBER].[GROUPID]
CONSTITUENTGROUPDIMID	int	yes		Reference key to the constituent group dimension, derived from 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.
ISCURRENT	bit	yes		Determines whether a member is currently in a group. Derived from BBDW.[FACT_CONSTITUENTGROUPMEMBER].[TODATE]

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FACT_CONSTITUENTGROUPMEMBER	CONSTITUENTGROUPMEMBERFACTID	yes	yes	yes