FACT_SMARTQUERYSECURITY_STAGE

Intermediate storage for smart query permissions.

Fields

Field	Field Type	Null	Notes	Description
PERMISSIONSYSTEMID	uniqueidentifier	yes		dbo.[SYSTEMROLEPERM_SMARTQUERY].[ID]
SMARTQUERYCATALOGID	uniqueidentifier	yes		dbo.[SYSTEMROLEPERM_SMARTQUERY].[SMARTQUERYCATALOGID]
SYSTEMROLEDIMID	int	yes		Surrogate key for the system role dimension, derived from dbo.[SYSTEMROLEPERM_SMARTQUERY].[SYSTEMROLEID]
GRANTORDENY	bit	yes		dbo.[SYSTEMROLEPERM_SMARTQUERY].[GRANTORDENY]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
SOURCEDIMID	int	yes		Source system used.
ETLCONTROLID	int	yes		ID generated through the ETL process.