FACT_CONSTITUENTSECURITYGROUPASSIGNMENT_STAGE

Intermediate storage table for constituent security group assignments

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTSECURITYGROUPASSIGNMENTSYSTEMID	uniqueidentifier	yes		[dbo].[CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT].[ID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT].[CONSTITUENTID]
CONSTITUENTSECURITYGROUPSYSTEMID	uniqueidentifier	yes		[dbo].[CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT].[CONSTIT_SECURITY_ATTRIBUTEID]
CONSTITUENTSECURITYGROUPDIMID	int	yes		Reference key to the constituent security group dimension, derived from dbo.[CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT].[CONSTIT_SECURITY_ATTRIBUTEID]
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.