v_FACT_SYSTEMROLEAPPUSER
Contains information about application user system roles
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SYSTEMROLEAPPUSERFACTID | int | BBDW.[FACT_SYSTEMROLEAPPUSER].[SYSTEMROLEAPPUSERFACTID] | |
| SYSTEMROLEAPPUSERSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SYSTEMROLEAPPUSER].[SYSTEMROLEAPPUSERSYSTEMID] |
| APPUSERDIMID | int | yes | BBDW.[FACT_SYSTEMROLEAPPUSER].[APPUSERDIMID] |
| APPUSERSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SYSTEMROLEAPPUSER].[APPUSERSYSTEMID] |
| SYSTEMROLEDIMID | int | yes | BBDW.[FACT_SYSTEMROLEAPPUSER].[SYSTEMROLEDIMID] |
| SITESECURITYMODE | tinyint | yes | BBDW.[FACT_SYSTEMROLEAPPUSER].[SITESECURITYMODE] |
| CONSTITUENTSECURITYMODE | tinyint | yes | BBDW.[FACT_SYSTEMROLEAPPUSER].[CONSTITUENTSECURITYMODE] |
Definition
Copy
create view [BBDW].[v_FACT_SYSTEMROLEAPPUSER] as
select
[SYSTEMROLEAPPUSERFACTID],
[SYSTEMROLEAPPUSERSYSTEMID],
[APPUSERDIMID],
[APPUSERSYSTEMID],
[SYSTEMROLEDIMID],
[SITESECURITYMODE],
[CONSTITUENTSECURITYMODE]
from [BBDW].[FACT_SYSTEMROLEAPPUSER];