v_FACT_SITEPERMISSION
Contains information about site permissions
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SITEPERMISSIONFACTID | int | BBDW.[FACT_SITEPERMISSION].[SITEPERMISSIONFACTID] | |
| SITEPERMISSIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SITEPERMISSION].[SITEPERMISSIONSYSTEMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SITEPERMISSION].[SITESYSTEMID] |
| SITEDIMID | int | yes | BBDW.[FACT_SITEPERMISSION].[SITEDIMID] |
| APPUSERDIMID | int | yes | BBDW.[FACT_SITEPERMISSION].[APPUSERDIMID] |
| SYSTEMROLEDIMID | int | yes | BBDW.[FACT_SITEPERMISSION].[SYSTEMROLEDIMID] |
| SYSTEMROLEAPPUSERSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SITEPERMISSION].[SYSTEMROLEAPPUSERSYSTEMID] |
| SYSTEMROLEAPPUSERFACTID | int | yes | BBDW.[FACT_SITEPERMISSION].[SYSTEMROLEAPPUSERFACTID] |
Definition
Copy
create view [BBDW].[v_FACT_SITEPERMISSION] as
select
[SITEPERMISSIONFACTID],
[SITEPERMISSIONSYSTEMID],
[SITESYSTEMID],
[SITEDIMID],
[APPUSERDIMID],
[SYSTEMROLEDIMID],
[SYSTEMROLEAPPUSERSYSTEMID],
[SYSTEMROLEAPPUSERFACTID]
from [BBDW].[FACT_SITEPERMISSION];