v_DIM_SYSTEMROLE
Contains information about system roles
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SYSTEMROLEDIMID | int | BBDW.[DIM_SYSTEMROLE].[SYSTEMROLEDIMID] | |
| SYSTEMROLESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SYSTEMROLE].[SYSTEMROLESYSTEMID] |
| SYSTEMROLENAME | nvarchar(255) | yes | BBDW.[DIM_SYSTEMROLE].[SYSTEMROLENAME] |
| SYSTEMROLEDESCRIPTION | nvarchar(500) | yes | BBDW.[DIM_SYSTEMROLE].[SYSTEMROLEDESCRIPTION] |
Definition
Copy
create view [BBDW].[v_DIM_SYSTEMROLE] as
select
[SYSTEMROLEDIMID],
[SYSTEMROLESYSTEMID],
[SYSTEMROLENAME],
[SYSTEMROLEDESCRIPTION]
from [BBDW].[DIM_SYSTEMROLE];