v_FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY
Contains information about the constituent security groups assigned to system role application users
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SYSTEMROLEAPPUSERCONSTITUENTSECURITYFACTID | int | BBDW.[FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY].[SYSTEMROLEAPPUSERCONSTITUENTSECURITYFACTID] | |
| SYSTEMROLEAPPUSERCONSTITUENTSECURITYSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY].[SYSTEMROLEAPPUSERCONSTITUENTSECURITYSYSTEMID] |
| SYSTEMROLEAPPUSERFACTID | int | yes | BBDW.[FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY].[SYSTEMROLEAPPUSERFACTID] |
| CONSTITUENTSECURITYGROUPDIMID | int | yes | BBDW.[FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY].[CONSTITUENTSECURITYGROUPDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY] as
select
[SYSTEMROLEAPPUSERCONSTITUENTSECURITYFACTID],
[SYSTEMROLEAPPUSERCONSTITUENTSECURITYSYSTEMID],
[SYSTEMROLEAPPUSERFACTID],
[CONSTITUENTSECURITYGROUPDIMID]
from [BBDW].[FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY];