Surrogate key for the dataform instance security fact
Primary Key
| Primary Key |
Field Type |
| DATAFORMINSTANCESECURITYFACTID |
int |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| PERMISSIONSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[SYSTEMROLEPERM_DATAFORMINSTANCE].[ID] and [dbo].[SYSTEMROLEPERM_FEATUREGROUP].[ID] |
| DATAFORMINSTANCECATALOGID |
uniqueidentifier |
yes |
|
[dbo].[SYSTEMROLEPERM_DATAFORMINSTANCE].[DATAFORMINSTANCECATALOGID] and [dbo].[FEATUREGROUPFEATURE].[FEATUREID] |
| SYSTEMROLEDIMID |
int |
yes |
|
Reference key to the system role dimension, derived from dbo.[SYSTEMROLEPERM_DATAFORMINSTANCE].[SYSTEMROLEID] and dbo.[SYSTEMROLEPERM_FEATUREGROUP].[SYSTEMROLEID] |
| GRANTORDENY |
bit |
yes |
|
[dbo].[SYSTEMROLEPERM_DATAFORMINSTANCE].[GRANTORDENY] and [dbo].[SYSTEMROLEPERM_FEATUREGROUP].[GRANTORDENY] |
| 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. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| PK_FACT_DATAFORMINSTANCESECURITY |
DATAFORMINSTANCESECURITYFACTID |
yes |
yes |
yes |