v_DIM_APPUSER
Contains information about application users
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| APPUSERDIMID | int | BBDW.[DIM_APPUSER].[APPUSERDIMID] | |
| APPUSERSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_APPUSER].[APPUSERSYSTEMID] |
| APPUSERNAME | nvarchar(128) | yes | BBDW.[DIM_APPUSER].[APPUSERNAME] |
| APPUSERDISPLAYNAME | nvarchar(255) | yes | BBDW.[DIM_APPUSER].[APPUSERDISPLAYNAME] |
| APPUSERISSYSADMIN | bit | yes | BBDW.[DIM_APPUSER].[APPUSERISSYSADMIN] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_APPUSER].[CONSTITUENTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_APPUSER].[CONSTITUENTDIMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_APPUSER].[SITESYSTEMID] |
| SITEDIMID | int | yes | BBDW.[DIM_APPUSER].[SITEDIMID] |
| WINDOWSUSERNAME | nvarchar(255) | yes | BBDW.[DIM_APPUSER].[WINDOWSUSERNAME] |
| CUSTOM_AUTHENTICATION_USERID | nvarchar(255) | yes | BBDW.[DIM_APPUSER].[CUSTOM_AUTHENTICATION_USERID] |
| APPUSERISACTIVE | bit | yes | App user can be active 1, or inactive 0. If null assumed active. |
Definition
Copy
CREATE view BBDW.v_DIM_APPUSER as
select
[APPUSERDIMID],
[APPUSERSYSTEMID],
[APPUSERNAME],
[APPUSERDISPLAYNAME],
[APPUSERISSYSADMIN],
[CONSTITUENTSYSTEMID],
[CONSTITUENTDIMID],
[SITESYSTEMID],
[SITEDIMID],
[WINDOWSUSERNAME],
[CUSTOM_AUTHENTICATION_USERID],
[APPUSERISACTIVE]
from [BBDW].[DIM_APPUSER];