FACT_SYSTEMROLEAPPUSER_STAGE

Contains information about application user system roles

Fields

Field	Field Type	Null	Notes	Description
SYSTEMROLEAPPUSERSYSTEMID	uniqueidentifier	yes		[dbo].[SYSTEMROLEAPPUSER].[ID]
APPUSERSYSTEMID	uniqueidentifier	yes		[dbo].[SYSTEMROLEAPPUSER].[APPUSERID]
APPUSERDIMID	int	yes		Reference key to the application user dimension, derived from dbo.[SYSTEMROLEAPPUSER].[APPUSERID]
SYSTEMROLEDIMID	int	yes		Reference key to the system role dimension, derived from dbo.[SYSTEMROLEAPPUSER].[SYSTEMROLEID]
SITESECURITYMODE	tinyint	yes		[dbo].[SYSTEMROLEAPPUSER].[SECURITYMODECODE]
CONSTITUENTSECURITYMODE	tinyint	yes		[dbo].[SYSTEMROLEAPPUSER].[CONSTITUENTSECURITYMODECODE]
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.