FACT_SITEPERMISSION_STAGE

Intermediate storage table for site permissions

Fields

Field	Field Type	Null	Notes	Description
SITEPERMISSIONSYSTEMID	uniqueidentifier	yes		[dbo].[SITEPERMISSION].[ID]
SITESYSTEMID	uniqueidentifier	yes		[dbo].[SITEPERMISSION].[SITEID]
SITEDIMID	int	yes		Reference key to the site dimension, derived from dbo.[SITEPERMISSION].[SITEID]
APPUSERDIMID	int	yes		Reference key to the application user dimension, derived from dbo.[SITEPERMISSION].[APPUSERID]
SYSTEMROLEDIMID	int	yes		Reference key to the system role dimension, derived from dbo.[SITEPERMISSION].[SYSTEMROLEID]
SYSTEMROLEAPPUSERSYSTEMID	uniqueidentifier	yes		[dbo].[SITEPERMISSION].[SYSTEMROLEAPPUSERID]
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.