FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY_STAGE

Intermediate storage table for system role application user constituent security groups

Fields

Field	Field Type	Null	Notes	Description
SYSTEMROLEAPPUSERCONSTITUENTSECURITYSYSTEMID	uniqueidentifier	yes		[dbo].[SYSTEMROLEAPPUSERCONSTITUENTSECURITY].[ID]
SYSTEMROLEAPPUSERSYSTEMID	uniqueidentifier	yes		dbo.[SYSTEMROLEAPPUSERCONSTITUENTSECURITY].[SYSTEMROLEAPPUSERID]
CONSTITUENTSECURITYGROUPDIMID	int	yes		Reference key to the constituent security group dimension, derived from[dbo].[SYSTEMROLEAPPUSERCONSTITUENTSECURITY].[CONSTITUENTSECURITYATTRIBUTEID]
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.