FACT_SYSTEMPRIVILEGESECURITY_STAGE

Intermediate storage table for system privilege security.

Fields

Field	Field Type	Null	Notes	Description
PERMISSIONSYSTEMID	uniqueidentifier	yes		dbo.[SYSTEMROLEPERM_SYSTEMPRIVILEGE].[ID] and dbo.[FEATUREGROUPFEATURE].[ID]
SYSTEMROLESYSTEMID	uniqueidentifier	yes		dbo.[SYSTEMROLEPERM_SYSTEMPRIVILEGE].[SYSTEMROLEID]
SYSTEMROLEDIMID	int	yes		Reference to the system role dimension, derived from dbo.[SYSTEMROLEPERM_SYSTEMPRIVILEGE].[SYSTEMROLEID]
SYSTEMPRIVILEGECATALOGID	uniqueidentifier	yes		dbo.[SYSTEMROLEPERM_SYSTEMPRIVILEGE].[SYSTEMPRIVILEGECATALOGID] and dbo.[FEATUREGROUPFEATURE].[FEATUREID]
GRANTORDENY	bit	yes		dbo.[SYSTEMROLEPERM_SYSTEMPRIVILEGE].[GRANTORDENY]
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.