v_DIM_CONSTITUENTGROUPMEMBERROLE
Stores information about constituent group members
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTGROUPMEMBERROLEDIMID | int | BBDW.[DIM_CONSTITUENTGROUPMEMBERROLE].[CONSTITUENTGROUPMEMBERROLEDIMID] | |
| ROLESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTGROUPMEMBERROLE].[ROLESYSTEMID] |
| ROLE | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTGROUPMEMBERROLE].[ROLE] |
| ISACTIVE | bit | yes | BBDW.[DIM_CONSTITUENTGROUPMEMBERROLE].[ISACTIVE] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTGROUPMEMBERROLE] as
select
[CONSTITUENTGROUPMEMBERROLEDIMID],
[ROLESYSTEMID],
[ROLE],
[ISACTIVE]
from [BBDW].[DIM_CONSTITUENTGROUPMEMBERROLE];