DIM_APPUSER

Contains information about application users

Primary Key

Primary Key	Field Type
APPUSERDIMID	int

Fields

Field	Field Type	Null	Notes	Description
APPUSERSYSTEMID	uniqueidentifier	yes		[dbo].[APPUSER].[ID]
APPUSERNAME	nvarchar(128)	yes		[dbo].[APPUSER].[USERNAME]
APPUSERDISPLAYNAME	nvarchar(255)	yes		[dbo].[APPUSER].[DISPLAYNAME]
APPUSERISSYSADMIN	bit	yes		[dbo].[APPUSER].[ISSYSADMIN]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[APPUSER].[CONSTITUENTID]
CONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from dbo.[APPUSER].[CONSTITUENTID]
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.
SITESYSTEMID	uniqueidentifier	yes		[dbo].[APPUSER].[SITEID]
SITEDIMID	int	yes		Reference key to the site dimension, derived using [dbo].[APPUSER].[SITEID]
WINDOWSUSERNAME	nvarchar(255)	yes		dbo.[APPUSER].[WINDOWSUSERNAME]
CUSTOM_AUTHENTICATION_USERID	nvarchar(255)	yes		dbo.[APPUSER].[CUSTOM_AUTHENTICATION_USERID]
APPUSERISACTIVE	bit	yes		App user can be active 1, or inactive 0. If null assumed active.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DIM_APPUSER_APPUSERSYSTEMID	APPUSERSYSTEMID
IX_DIM_APPUSER_CONSTITUENTDIMID	CONSTITUENTDIMID
IX_DIM_APPUSER_CONSTITUENTSYSTEMID	CONSTITUENTSYSTEMID
IX_DIM_APPUSER_SITEDIMID	SITEDIMID
IX_DIM_APPUSER_SITESYSTEMID	SITESYSTEMID
PK_DIM_APPUSER	APPUSERDIMID	yes	yes	yes