v_DIM_CONSTITUENTSECURITYGROUP
Contains information about constituent security groups
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTSECURITYGROUPDIMID | int | BBDW.[DIM_CONSTITUENTSECURITYGROUP].[CONSTITUENTSECURITYGROUPDIMID] | |
| CONSTITUENTSECURITYGROUPSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTSECURITYGROUP].[CONSTITUENTSECURITYGROUPSYSTEMID] |
| CONSTITUENTSECURITYGROUPNAME | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTSECURITYGROUP].[CONSTITUENTSECURITYGROUPNAME] |
| CONSTITUENTSECURITYGROUPDESCRIPTION | nvarchar(255) | yes | BBDW.[DIM_CONSTITUENTSECURITYGROUP].[CONSTITUENTSECURITYGROUPDESCRIPTION] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTSECURITYGROUP] as
select
[CONSTITUENTSECURITYGROUPDIMID],
[CONSTITUENTSECURITYGROUPSYSTEMID],
[CONSTITUENTSECURITYGROUPNAME],
[CONSTITUENTSECURITYGROUPDESCRIPTION]
from [BBDW].[DIM_CONSTITUENTSECURITYGROUP];