FACT_DATAFORMINSTANCESECURITY_STAGE

Intermediate storage table for data form instance security

Fields

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