FACT_CONSTITUENTGROUPMEMBERROLE_STAGE

Intermediate storage table for FACT_CONSTITUENTGROUPMEMBERROLE

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTGROUPMEMBERROLESYSTEMID	uniqueidentifier	yes		[dbo].[GROUPMEMBERROLE].[ID]
CONSTITUENTGROUPMEMBERSYSTEMID	uniqueidentifier	yes		[dbo].[GROUPMEMBERROLE].[GROUPMEMBERID]
CONSTITUENTGROUPMEMBERROLEDIMID	int	yes		Reference key to the Constituent Group Member Role Dimension, derived from [dbo].[GROUPMEMBERROLE].[GROUPMEMBERROLECODEID]
STARTDATE	datetime	yes		[dbo].[GROUPMEMBERROLE].[STARTDATE]
STARTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[GROUPMEMBERROLE].[STARTDATE]
ENDDATE	datetime	yes		[dbo].[GROUPMEMBERROLE].[ENDDATE]
ENDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[GROUPMEMBERROLE].[ENDDATE]
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.